# | Name | Min | Avg | Max | Total | Measurements | Deviation | % |
1 | SELECT KEY_VALUE FROM PRIMARY_KEY WHERE KEY_NAME=? | 0.0 | 24.429172510518935 | 26939.0 | 52254.0 | 2139.0 | 87.5047674991436 | 42.01 |
2 | select ID from ${METRIC} where PARENT=? AND NAME=? | 0.0 | 18.392352016762704 | 5178.0 | 35111.0 | 1909.0 | 37.32995279964137 | 28.23 |
3 | INSERT INTO ${SLICE} (ID, METRIC_ID, TIME_FROM, TIME_TO, MEASUREMENTS, TOTAL, MIN_VALUE, MAX_VALUE, DEVIATION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) | 0.0 | 10.015207131620347 | 4367.0 | 19099.0 | 1907.0 | 19.476898175017965 | 15.35 |
4 | UPDATE PRIMARY_KEY SET KEY_VALUE=KEY_VALUE+1 WHERE KEY_NAME=? | 0.0 | 7.541159962581852 | 5478.0 | 16123.0 | 2138.0 | 18.4167106267474 | 12.96 |
5 | INSERT INTO ${KINDRED} SELECT ANCESTOR, ? FROM ${KINDRED} WHERE DESCENDANT=? | 0.0 | 3.9267241379310347 | 561.0 | 911.0 | 232.0 | 5.517409493374692 | 0.73 |
6 | INSERT INTO ${METRIC} (ID, NAME, PARENT) VALUES (?, ?, ?) | 0.0 | 1.771551724137931 | 411.0 | 411.0 | 232.0 | 5.143145224595603 | 0.33 |
7 | INSERT INTO ${KINDRED} (ANCESTOR,DESCENDANT) VALUES (?,?) | 0.0 | 1.3836206896551724 | 261.0 | 321.0 | 232.0 | 2.072054228354945 | 0.26 |
8 | UPDATE COMPILATION_UNIT SET STORE_LEVEL=? WHERE ID=? | 0.0 | 0.11931394481730052 | 10.0 | 160.0 | 1341.0 | 0.23436160800993308 | 0.13 |
9 | INSERT INTO PRIMARY_KEY (KEY_NAME, KEY_VALUE) VALUES (?, 0) | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0 |
10 | SELECT R.*, S.RESULT_DATE FROM REPORT R JOIN RESULT S ON R.RESULT_ID=S.ID WHERE R.NAME=? AND (S.COMMITED=1 OR R.ID=?) AND NOT EXISTS (SELECT * FROM HISTORY WHERE HISTORY.ID=R.ID) | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0 |
11 | SELECT AVG(CODEBASE) AS CODEBASE, MIN(MAX_SEVERITY) AS MAX_SEVERITY, AVG(REVIEWS) AS REVIEWS, AVG(VIOLATION_LEVEL) AS VIOLATION_LEVEL, AVG(VIOLATIONS) AS VIOLATIONS, AVG(WAIVED_VIOLATIONS) AS WAIVED_VIOLATIONS, MAX(HAS_WARNINGS) AS HAS_WARNINGS, SUM(CHANGE_RATIO) AS CHANGE_RATIO, AVG(COMPILATION_UNITS) AS COMPILATION_UNITS, COUNT(*) AS REPORTS, REPORT_DATE, AVG(EXECUTION_TIME) AS EXECUTION_TIME, MAX(ID) AS LAST_REPORT_ID FROM HISTORY H WHERE NAME=? GROUP BY REPORT_DATE ORDER BY REPORT_DATE | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0 |
12 | SELECT DESCRIPTION FROM HISTORY H WHERE ID=(SELECT MAX(ID) FROM HISTORY HH WHERE HH.REPORT_DATE=? ) | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0 |
13 | SELECT SUM(R.CODEBASE) AS CODEBASE, MAX(R.RESULT_DATE) AS RESULT_DATE, MIN(R.MAX_SEVERITY) AS MAX_SEVERITY, SUM(R.REVIEWS) AS REVIEWS, SUM(R.VIOLATION_LEVEL) AS VIOLATION_LEVEL, SUM(R.VIOLATIONS) AS VIOLATIONS, SUM(R.WAIVED_VIOLATIONS) AS WAIVED_VIOLATIONS, SUM(R.HAS_WARNINGS) AS HAS_WARNINGS, COUNT(R.COMPILATION_UNIT) AS COMPILATION_UNITS FROM RESULT R JOIN KINDRED K ON R.ID=K.DESCENDANT WHERE K.ANCESTOR=? AND R.COMMITED=1 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0 |
14 | INSERT INTO HISTORY (ID,CODEBASE,MAX_SEVERITY,REVIEWS,VIOLATION_LEVEL,VIOLATIONS,WAIVED_VIOLATIONS,HAS_WARNINGS,CHANGE_RATIO,COMPILATION_UNITS,REPORT_DATE,NAME,DESCRIPTION,EXECUTION_TIME) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?) | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0 |
15 | SELECT COUNT(*) AS MEASUREMENTS, SUM(MS.MEASUREMENT_VALUE) AS TOTAL_VALUE, MIN(MS.MEASUREMENT_VALUE) AS MIN_VALUE, MAX(MS.MEASUREMENT_VALUE) AS MAX_VALUE FROM METRIC M JOIN KINDRED K ON M.RESULT_ID=K.DESCENDANT JOIN MEASUREMENT MS ON MS.RESULT_ID=M.RESULT_ID AND MS.NAME=M.NAME WHERE K.ANCESTOR=? AND M.NAME=? | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0 |