Metric | Total | Number | Min | Avg | Max |
SELECT NAME_ID FROM PACKAGE P WHERE REPOSITORY=? AND EXISTS (SELECT * FROM COMPILATION_UNIT C WHERE C.REPOSITORY=P.REPOSITORY AND C.PACKAGE=P.NAME_ID AND EXISTS (SELECT * FROM COMPILATION_UNIT_SCAN S WHERE S.COMPILATION_UNIT_ID=C.ID AND S.REPOSITORY=C.REPOSITORY AND S.SCAN_ID=?)) | 222179.0 | 1 | 222179.0 | 222179.0 | 222179.0 |
SELECT T.SUPERCLASS, T.COMPILATION_UNIT_ID, T.DECLARING_TYPE, T.IMPLEMENTOR, T.SUPERCLASS_SIGNATURE, T.STORE_LEVEL, T.NAME FROM TYPE T WHERE T.NAME=? AND EXISTS(SELECT * FROM COMPILATION_UNIT C, COMPILATION_UNIT_SCAN S WHERE C.ID=S.COMPILATION_UNIT_ID AND C.ID=T.COMPILATION_UNIT_ID AND C.REPOSITORY=? AND S.SCAN_ID=?) | 28403.0 | 42343 | 0.0 | 0.6707838367616843 | 541.0 |
SELECT * FROM COMPILATION_UNIT C WHERE REPOSITORY=? AND PACKAGE=? AND EXISTS(SELECT * FROM COMPILATION_UNIT_SCAN S WHERE S.COMPILATION_UNIT_ID=C.ID AND S.REPOSITORY=C.REPOSITORY AND S.SCAN_ID=?) AND C.NAME=? | 11249.0 | 6198 | 0.0 | 1.8149403033236529 | 1692.0 |
SELECT SUPPLIER_NAME FROM TYPE_DEPENDENCY WHERE SUPPLIER_NAME=? AND CLIENT_CU_ID=? AND CLIENT_NAME=? | 4898.0 | 38747 | 0.0 | 0.12640978656412108 | 11.0 |
SELECT KEY_VALUE FROM PRIMARY_KEY WHERE KEY_NAME=? | 3586.0 | 17671 | 0.0 | 0.20293135645973628 | 50.0 |
SELECT * FROM TYPE_DEPENDENCY WHERE SUPPLIER_NAME=? AND CLIENT_CU_ID=? AND CLIENT_NAME=? | 2942.0 | 9824 | 0.0 | 0.29947068403908794 | 30.0 |
SELECT * FROM COMPILATION_UNIT WHERE ID=? | 2626.0 | 3174 | 0.0 | 0.8273471959672338 | 140.0 |
SELECT DISTINCT(TD.CLIENT_CU_ID) AS CU_ID FROM TYPE_DEPENDENCY TD JOIN COMPILATION_UNIT_SCAN CUS ON CUS.COMPILATION_UNIT_ID=TD.CLIENT_CU_ID WHERE CUS.REPOSITORY=? AND CUS.SCAN_ID=? AND TD.SUPPLIER_PACKAGE=? AND NOT EXISTS(SELECT * FROM TYPE ST JOIN COMPILATION_UNIT_SCAN SCUS ON ST.COMPILATION_UNIT_ID=SCUS.COMPILATION_UNIT_ID WHERE ST.NAME=TD.SUPPLIER_NAME AND SCUS.SCAN_ID=CUS.SCAN_ID) | 2144.0 | 101 | 0.0 | 21.22772277227723 | 291.0 |
UPDATE PRIMARY_KEY SET KEY_VALUE=KEY_VALUE+1 WHERE KEY_NAME=? | 2132.0 | 17665 | 0.0 | 0.12069063119162185 | 50.0 |
SELECT TD.CLIENT_NAME FROM TYPE_DEPENDENCY TD JOIN COMPILATION_UNIT_SCAN CUS ON CUS.COMPILATION_UNIT_ID=TD.CLIENT_CU_ID WHERE CUS.REPOSITORY=? AND CUS.SCAN_ID=? AND TD.SUPPLIER_NAME=? | 1944.0 | 371 | 0.0 | 5.2398921832884096 | 280.0 |
select td.supplier_package, count(distinct td.client_name) as CARDINALITY from type_dependency td JOIN COMPILATION_UNIT_SCAN CUS ON CUS.COMPILATION_UNIT_ID=TD.CLIENT_CU_ID WHERE CUS.REPOSITORY=? AND cus.SCAN_ID=? AND NOT EXISTS(SELECT * FROM TYPE ST JOIN COMPILATION_UNIT_SCAN SCUS ON ST.COMPILATION_UNIT_ID=SCUS.COMPILATION_UNIT_ID WHERE ST.NAME=TD.SUPPLIER_NAME AND SCUS.SCAN_ID=CUS.SCAN_ID) group by td.supplier_package order by td.supplier_package | 1703.0 | 1 | 1703.0 | 1703.0 | 1703.0 |
SELECT * FROM COMPILATION_UNIT C WHERE REPOSITORY=? AND EXISTS(SELECT * FROM COMPILATION_UNIT_SCAN S WHERE S.COMPILATION_UNIT_ID=C.ID AND S.REPOSITORY=C.REPOSITORY AND S.SCAN_ID=?) AND EXISTS(SELECT * FROM TYPE T WHERE T.COMPILATION_UNIT_ID=C.ID AND T.NAME=?) | 1571.0 | 299 | 0.0 | 5.254180602006689 | 80.0 |
INSERT INTO TYPE_DEPENDENCY (SUPPLIER_NAME,CLIENT_CU_ID,CLIENT_NAME,SUPPLIER_PACKAGE,CLIENT_PACKAGE) VALUES (?,?,?,?,?) | 1471.0 | 7062 | 0.0 | 0.20829793259699803 | 30.0 |
SELECT * FROM TYPE WHERE NAME=? | 1092.0 | 2161 | 0.0 | 0.5053216103655715 | 20.0 |
SELECT ID FROM OPERATION WHERE COMPILATION_UNIT_ID=? AND DECLARING_TYPE=? AND NAME=? AND PARAMETERS=? | 881.0 | 4946 | 0.0 | 0.17812373635260817 | 11.0 |
INSERT INTO CALL_TRACE (ID, CALLER, CALLEE_NAME) VALUES (?, ?, ?) | 812.0 | 6772 | 0.0 | 0.11990549320732427 | 20.0 |
SELECT * FROM TYPE WHERE COMPILATION_UNIT_ID=? AND NAME=? | 773.0 | 2041 | 0.0 | 0.3787359137677609 | 11.0 |
SELECT * FROM INTERFACE WHERE COMPILATION_UNIT_ID=? AND DECLARING_TYPE=? | 764.0 | 3653 | 0.0 | 0.2091431699972625 | 30.0 |
SELECT ID FROM MESSAGE WHERE HASH_CODE=? AND MESSAGE_VALUE=? | 741.0 | 4972 | 0.0 | 0.14903459372485922 | 40.0 |
INSERT INTO MESSAGE (ID,HASH_CODE,MESSAGE_VALUE) VALUES (?,?,?) | 553.0 | 4972 | 0.0 | 0.11122284794851167 | 40.0 |
SELECT * FROM OPERATION WHERE COMPILATION_UNIT_ID=? AND DECLARING_TYPE=? | 490.0 | 546 | 0.0 | 0.8974358974358975 | 120.0 |
UPDATE TYPE SET STORE_LEVEL=? WHERE NAME=? AND COMPILATION_UNIT_ID=? | 450.0 | 1497 | 0.0 | 0.30060120240480964 | 190.0 |
SELECT * FROM TYPE WHERE COMPILATION_UNIT_ID=? AND DECLARING_TYPE=? | 450.0 | 1140 | 0.0 | 0.39473684210526316 | 60.0 |
INSERT INTO CALL_TRACE (ID, CALLER, CALLEE) VALUES (?, ?, ?) | 450.0 | 2908 | 0.0 | 0.15474552957359008 | 30.0 |
INSERT INTO OPERATION (ID, COMPILATION_UNIT_ID, DECLARING_TYPE, NAME, RETURN_TYPE, PARAMETERS, MODIFIERS, SIGNATURE) VALUES (?, ?, ?, ?, ?, ?, ?, ?) | 371.0 | 2041 | 0.0 | 0.18177364037236649 | 11.0 |
SELECT * FROM FIELD WHERE COMPILATION_UNIT_ID=? AND DECLARING_TYPE=? | 371.0 | 783 | 0.0 | 0.47381864623243936 | 50.0 |
SELECT ID FROM COMPILATION_UNIT WHERE REPOSITORY=? AND PACKAGE=? AND PATH=? AND COMPILATION_UNIT_SIZE=? AND CHECKSUM=? | 280.0 | 332 | 0.0 | 0.8433734939759037 | 50.0 |
SELECT * FROM PACKAGE WHERE REPOSITORY=? AND NAME_ID=? | 220.0 | 332 | 0.0 | 0.6626506024096386 | 10.0 |
INSERT INTO FIELD (COMPILATION_UNIT_ID, DECLARING_TYPE, NAME, TYPE, SIGNATURE) VALUES (?, ?, ?, ?, ?) | 140.0 | 871 | 0.0 | 0.16073478760045926 | 10.0 |
INSERT INTO OVERRIDE (ID, SPECIFICATION, IMPLEMENTATION) VALUES (?, ?, ?) | 110.0 | 469 | 0.0 | 0.2345415778251599 | 10.0 |
INSERT INTO COMPILATION_UNIT_SCAN (REPOSITORY,SCAN_ID,COMPILATION_UNIT_ID) VALUES (?,?,?) | 91.0 | 332 | 0.0 | 0.2740963855421687 | 11.0 |
INSERT INTO COMPILATION_UNIT (ID, REPOSITORY, PACKAGE, PATH, NAME, COMPILATION_UNIT_SIZE, CHECKSUM, ROOT) VALUES (?, ?, ?, ?, ?, ?, ?, ?) | 90.0 | 332 | 0.0 | 0.2710843373493976 | 10.0 |
SELECT * FROM COMPILATION_UNIT C WHERE REPOSITORY=? AND PACKAGE=? AND EXISTS(SELECT * FROM COMPILATION_UNIT_SCAN S WHERE S.COMPILATION_UNIT_ID=C.ID AND S.REPOSITORY=C.REPOSITORY AND S.SCAN_ID=?) | 90.0 | 40 | 0.0 | 2.25 | 30.0 |
UPDATE TYPE SET SUPERCLASS=?, SUPERCLASS_SIGNATURE=? WHERE COMPILATION_UNIT_ID=? AND NAME=? | 70.0 | 236 | 0.0 | 0.2966101694915254 | 20.0 |
SELECT * FROM CALL_TRACE WHERE CALLEE=? | 61.0 | 13 | 0.0 | 4.6923076923076925 | 61.0 |
UPDATE TYPE SET SUPERCLASS=?, STORE_LEVEL=? WHERE COMPILATION_UNIT_ID=? AND NAME=? | 50.0 | 123 | 0.0 | 0.4065040650406504 | 10.0 |
INSERT INTO OPERATION (ID, COMPILATION_UNIT_ID, DECLARING_TYPE, NAME, PARAMETERS, SIGNATURE) VALUES (?, ?, ?, ?, ?, ?) | 41.0 | 176 | 0.0 | 0.23295454545454544 | 11.0 |
DELETE FROM COMPILATION_UNIT WHERE REPOSITORY=? AND NOT EXISTS (SELECT * FROM COMPILATION_UNIT_SCAN S WHERE S.COMPILATION_UNIT_ID=COMPILATION_UNIT.ID) | 40.0 | 1 | 40.0 | 40.0 | 40.0 |
SELECT * FROM COMPILATION_UNIT C WHERE REPOSITORY=? AND C.STORE_LEVEL=? AND EXISTS(SELECT * FROM COMPILATION_UNIT_SCAN S WHERE S.COMPILATION_UNIT_ID=C.ID AND S.REPOSITORY=C.REPOSITORY AND S.SCAN_ID=?) | 40.0 | 5 | 0.0 | 8.0 | 20.0 |
SELECT NAME_ID FROM PACKAGE P WHERE NAME_ID=? AND REPOSITORY=? AND EXISTS (SELECT * FROM COMPILATION_UNIT C WHERE C.REPOSITORY=P.REPOSITORY AND C.PACKAGE=P.NAME_ID AND EXISTS (SELECT * FROM COMPILATION_UNIT_SCAN S WHERE S.COMPILATION_UNIT_ID=C.ID AND S.REPOSITORY= C.REPOSITORY AND S.SCAN_ID=?)) | 30.0 | 53 | 0.0 | 0.5660377358490566 | 10.0 |
UPDATE TYPE SET STORE_LEVEL=? WHERE COMPILATION_UNIT_ID=? AND NAME=? | 20.0 | 274 | 0.0 | 0.072992700729927 | 10.0 |
INSERT INTO TYPE (COMPILATION_UNIT_ID, NAME, IMPLEMENTOR) VALUES (?, ?, ?) | 10.0 | 331 | 0.0 | 0.030211480362537766 | 10.0 |
SELECT * FROM COMPILATION_UNIT C WHERE REPOSITORY=? AND EXISTS(SELECT * FROM COMPILATION_UNIT_SCAN S WHERE S.COMPILATION_UNIT_ID=C.ID AND S.REPOSITORY=C.REPOSITORY AND S.SCAN_ID=?) AND EXISTS (SELECT * FROM TYPE T WHERE T.COMPILATION_UNIT_ID=C.ID AND T.STORE_LEVEL=?) | 10.0 | 3 | 0.0 | 3.3333333333333335 | 10.0 |
INSERT INTO INTERFACE (COMPILATION_UNIT_ID, DECLARING_TYPE, INTERFACE_NAME, SIGNATURE) VALUES (?, ?, ?, ?) | 10.0 | 131 | 0.0 | 0.07633587786259542 | 10.0 |
INSERT INTO PRIMARY_KEY (KEY_NAME, KEY_VALUE) VALUES (?, 0) | 10.0 | 6 | 0.0 | 1.6666666666666667 | 10.0 |
INSERT INTO PACKAGE (REPOSITORY,NAME_ID) VALUES (?,?) | 10.0 | 20 | 0.0 | 0.5 | 10.0 |
INSERT INTO TYPE (COMPILATION_UNIT_ID, NAME, DECLARING_TYPE, IMPLEMENTOR, STORE_LEVEL) VALUES (?, ?, ?, ?, ?) | 10.0 | 123 | 0.0 | 0.08130081300813008 | 10.0 |
INSERT INTO TYPE (COMPILATION_UNIT_ID, NAME, DECLARING_TYPE, IMPLEMENTOR) VALUES (?, ?, ?, ?) | 0.0 | 40 | 0.0 | 0.0 | 0.0 |
DELETE FROM SCAN WHERE REPOSITORY=? AND ID<>? | 0.0 | 1 | 0.0 | 0.0 | 0.0 |
INSERT INTO SCAN (REPOSITORY, ID, SCAN_DATE, DESCRIPTION) VALUES (?, ?, ?, ?) | 0.0 | 1 | 0.0 | 0.0 | 0.0 |
SELECT * FROM OPERATION WHERE ID=? | 0.0 | 8 | 0.0 | 0.0 | 0.0 |
UPDATE SCAN SET SCAN_SIZE=?, BYTE_SIZE=?, CHECKSUM=? WHERE REPOSITORY=? AND ID=? | 0.0 | 1 | 0.0 | 0.0 | 0.0 |
SELECT COUNT(*) AS CNT FROM REPOSITORY WHERE NAME=? | 0.0 | 1 | 0.0 | 0.0 | 0.0 |
INSERT INTO REPOSITORY (NAME,DESCRIPTION) VALUES (?,?) | 0.0 | 1 | 0.0 | 0.0 | 0.0 |
Metric | Total | Number | Min | Avg | Max |
SHUTDOWN COMPACT | 9554.0 | 1 | 9554.0 | 9554.0 | 9554.0 |
UPDATE COMPILATION_UNIT SET STORE_LEVEL=? WHERE ID=? | 260.0 | 1341 | 0.0 | 0.19388516032811334 | 20.0 |
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 | 20.0 | 1 | 20.0 | 20.0 | 20.0 |
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 | 1 | 0.0 | 0.0 | 0.0 |
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 | 1 | 0.0 | 0.0 | 0.0 |
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 | 1 | 0.0 | 0.0 | 0.0 |
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 | 1 | 0.0 | 0.0 | 0.0 |
Metric | Total | Number | Min | Avg | Max |
SELECT V.LINE, V.COL, V.SOURCE_ID, C.NAME AS COMPILATION_UNIT_NAME, PM.MESSAGE_VALUE AS COMPILATION_UNIT_PACKAGE FROM KINDRED K JOIN VIOLATION V ON V.RESULT_ID=K.DESCENDANT JOIN INSPECTOR I ON V.REPORT_ID=I.REPORT_ID AND V.INSPECTOR=I.NAME LEFT JOIN COMPILATION_UNIT C ON C.ID=V.SOURCE_ID LEFT JOIN MESSAGE PM ON C.PACKAGE=PM.ID WHERE K.ANCESTOR=? AND I.NAME=? AND V.VIOLATION_TYPE=0 | 32097.0 | 2805 | 0.0 | 11.442780748663102 | 691.0 |
SELECT M.MEASUREMENT_VALUE, M.SOURCE, M.LINE, M.COL FROM MEASUREMENT M JOIN KINDRED K ON M.RESULT_ID=K.DESCENDANT WHERE K.ANCESTOR=? AND M.NAME=? ORDER BY M.MEASUREMENT_VALUE | 17922.0 | 2085 | 0.0 | 8.59568345323741 | 150.0 |
SELECT V.INSPECTOR, V.LINE, V.COL, V.SOURCE_ID, C.PATH || V.SIGNATURE_POSTFIX AS SIGNATURE, M.MESSAGE_VALUE AS MESSAGE, C.NAME AS COMPILATION_UNIT_NAME, PM.MESSAGE_VALUE AS COMPILATION_UNIT_PACKAGE FROM VIOLATION V LEFT JOIN MESSAGE M ON V.MESSAGE_ID=M.ID LEFT JOIN COMPILATION_UNIT C ON V.SOURCE_ID=C.ID LEFT JOIN MESSAGE PM ON C.PACKAGE=PM.ID JOIN KINDRED K ON V.RESULT_ID=K.DESCENDANT WHERE K.ANCESTOR=? AND V.VIOLATION_TYPE=2 | 8382.0 | 1038 | 0.0 | 8.07514450867052 | 90.0 |
SELECT KEY_VALUE FROM PRIMARY_KEY WHERE KEY_NAME=? | 5640.0 | 16663 | 0.0 | 0.33847446438216405 | 110.0 |
SELECT * FROM INSPECTOR WHERE REPORT_ID=? AND NAME=? | 4114.0 | 10536 | 0.0 | 0.3904707668944571 | 160.0 |
UPDATE RESULT SET COMMITED=1, HAS_WARNINGS = (SELECT COUNT(*) FROM VIOLATION V WHERE V.RESULT_ID=RESULT.ID AND VIOLATION_TYPE=2) WHERE ID=? | 3994.0 | 353 | 0.0 | 11.314447592067989 | 80.0 |
SELECT DISTINCT I.* FROM KINDRED K JOIN VIOLATION V ON V.RESULT_ID=K.DESCENDANT JOIN INSPECTOR I ON I.REPORT_ID=V.REPORT_ID AND V.INSPECTOR=I.NAME WHERE K.ANCESTOR=? AND SEVERITY=? AND V.VIOLATION_TYPE=0 ORDER BY I.NAME, I.DESCRIPTION, I.CONFIG_INFO, I.REPORT_ID DESC | 3874.0 | 876 | 0.0 | 4.422374429223744 | 330.0 |
UPDATE RESULT SET VIOLATION_LEVEL=? WHERE ID=? | 3523.0 | 10536 | 0.0 | 0.33437737281700836 | 70.0 |
INSERT INTO VIOLATION (ID, RESULT_ID, REPORT_ID, INSPECTOR, MESSAGE_ID, SOURCE_ID, LINE, COL, SIGNATURE_POSTFIX, VIOLATION_TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | 3463.0 | 7105 | 0.0 | 0.48740323715693173 | 90.0 |
SELECT M.NAME, 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=? GROUP BY M.NAME | 3385.0 | 425 | 0.0 | 7.964705882352941 | 111.0 |
UPDATE RESULT SET VIOLATIONS=? WHERE ID=? | 2795.0 | 10536 | 0.0 | 0.2652809415337889 | 90.0 |
UPDATE PRIMARY_KEY SET KEY_VALUE=KEY_VALUE+1 WHERE KEY_NAME=? | 2794.0 | 16659 | 0.0 | 0.16771714988894892 | 70.0 |
SELECT V.INSPECTOR, V.LINE, V.COL, V.SOURCE_ID, C.PATH || V.SIGNATURE_POSTFIX AS SIGNATURE, M.MESSAGE_VALUE AS MESSAGE, C.NAME AS COMPILATION_UNIT_NAME, PM.MESSAGE_VALUE AS COMPILATION_UNIT_PACKAGE FROM VIOLATION V LEFT JOIN MESSAGE M ON V.MESSAGE_ID=M.ID LEFT JOIN COMPILATION_UNIT C ON V.SOURCE_ID=C.ID LEFT JOIN MESSAGE PM ON C.PACKAGE=PM.ID WHERE V.RESULT_ID=? AND V.VIOLATION_TYPE=0 | 2634.0 | 2016 | 0.0 | 1.306547619047619 | 100.0 |
SELECT COUNT(*) AS NCNT FROM RESULT R JOIN KINDRED K ON R.ID=K.DESCENDANT WHERE K.ANCESTOR=? AND R.IS_NEW=1 | 2413.0 | 1037 | 0.0 | 2.326904532304725 | 60.0 |
UPDATE RESULT SET CODEBASE=? WHERE ID=? | 2263.0 | 664 | 0.0 | 3.408132530120482 | 1643.0 |
INSERT INTO MEASUREMENT (ID, RESULT_ID, NAME, MEASUREMENT_VALUE, SOURCE, LINE, COL) VALUES (?, ?, ?, ?, ?, ?, ?) | 1901.0 | 5441 | 0.0 | 0.34938430435581697 | 71.0 |
SELECT DISTINCT(I.SEVERITY) AS SEVERITY FROM KINDRED K JOIN VIOLATION V ON V.RESULT_ID=K.DESCENDANT JOIN INSPECTOR I ON V.REPORT_ID=I.REPORT_ID AND V.INSPECTOR=I.NAME WHERE K.ANCESTOR=? AND V.VIOLATION_TYPE=0 | 1265.0 | 425 | 0.0 | 2.976470588235294 | 281.0 |
INSERT INTO VIOLATION (ID, RESULT_ID, REPORT_ID, INSPECTOR, MESSAGE_ID, SOURCE_ID, LINE, COL, VIOLATION_TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) | 1061.0 | 3431 | 0.0 | 0.30923928883707374 | 70.0 |
SELECT V.INSPECTOR, V.LINE, V.COL, V.SOURCE_ID, C.PATH || V.SIGNATURE_POSTFIX AS SIGNATURE, M.MESSAGE_VALUE AS MESSAGE, C.NAME AS COMPILATION_UNIT_NAME, PM.MESSAGE_VALUE AS COMPILATION_UNIT_PACKAGE, V.WAIVER_EXPIRES, R.MESSAGE_VALUE AS WAIVER_REASON FROM VIOLATION V LEFT JOIN MESSAGE M ON V.MESSAGE_ID=M.ID LEFT JOIN COMPILATION_UNIT C ON V.SOURCE_ID=C.ID LEFT JOIN MESSAGE R ON V.WAIVER_REASON=R.ID LEFT JOIN MESSAGE PM ON C.PACKAGE=PM.ID WHERE V.RESULT_ID=? AND V.VIOLATION_TYPE=1 | 520.0 | 1037 | 0.0 | 0.5014464802314368 | 40.0 |
SELECT HANDLE FROM ANNOTATION WHERE RESULT_ID=? | 340.0 | 1390 | 0.0 | 0.2446043165467626 | 50.0 |
SELECT * FROM RESULT_NET WHERE PARENT=? AND CHILD=? | 330.0 | 352 | 0.0 | 0.9375 | 90.0 |
SELECT * FROM METRIC WHERE RESULT_ID=? AND NAME=? | 310.0 | 1639 | 0.0 | 0.18913971934106164 | 50.0 |
SELECT ID, TYPE FROM RESULT WHERE COMPILATION_UNIT=? AND COMMITED=1 | 301.0 | 332 | 0.0 | 0.9066265060240963 | 80.0 |
INSERT INTO RESULT_NET (PARENT, CHILD) VALUES (?,?) | 270.0 | 705 | 0.0 | 0.3829787234042553 | 80.0 |
INSERT INTO METRIC (RESULT_ID,NAME) VALUES (?,?) | 240.0 | 1639 | 0.0 | 0.1464307504575961 | 60.0 |
INSERT INTO KINDRED (ANCESTOR, DESCENDANT) SELECT A.ANCESTOR, D.DESCENDANT FROM KINDRED A, KINDRED D WHERE A.DESCENDANT=? AND D.ANCESTOR=? | 231.0 | 352 | 0.0 | 0.65625 | 40.0 |
SELECT COMPILATION_UNIT FROM RESULT WHERE ID=? | 200.0 | 1311 | 0.0 | 0.15255530129672007 | 30.0 |
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 | 200.0 | 72 | 0.0 | 2.7777777777777777 | 10.0 |
UPDATE RESULT SET REVIEWS=? WHERE ID=? | 190.0 | 664 | 0.0 | 0.286144578313253 | 50.0 |
UPDATE RESULT SET MAX_SEVERITY=? WHERE ID=? | 150.0 | 693 | 0.0 | 0.21645021645021645 | 50.0 |
INSERT INTO RESULT (ID, TYPE, RESULT_DATE, CODEBASE) VALUES (?, ?, ?, 0) | 130.0 | 353 | 0.0 | 0.36827195467422097 | 20.0 |
DELETE FROM RESULT WHERE NOT EXISTS (SELECT * FROM REPORT R WHERE R.RESULT_ID=RESULT.ID) AND NOT EXISTS (SELECT * FROM RESULT_NET N WHERE N.CHILD=RESULT.ID AND N.PARENT<>N.CHILD) | 80.0 | 1 | 80.0 | 80.0 | 80.0 |
UPDATE RESULT SET COMPILATION_UNIT=?, IS_NEW=1 WHERE ID=? | 60.0 | 332 | 0.0 | 0.18072289156626506 | 10.0 |
UPDATE RESULT SET NAME=? WHERE ID=? | 50.0 | 353 | 0.0 | 0.141643059490085 | 20.0 |
INSERT INTO MEASUREMENT (ID, RESULT_ID, NAME, MEASUREMENT_VALUE) VALUES (?, ?, ?, ?) | 40.0 | 332 | 0.0 | 0.12048192771084337 | 10.0 |
INSERT INTO KINDRED (ANCESTOR, DESCENDANT) VALUES (?, ?) | 40.0 | 353 | 0.0 | 0.11331444759206799 | 20.0 |
SELECT R.ID FROM RESULT R JOIN RESULT_NET N ON N.CHILD=R.ID WHERE N.PARENT=? and N.PARENT<>N.CHILD | 40.0 | 21 | 0.0 | 1.9047619047619047 | 10.0 |
INSERT INTO INSPECTOR (REPORT_ID, NAME, SEVERITY, DESCRIPTION, CONFIG_INFO) VALUES (?, ?, ?, ?, ?) | 10.0 | 56 | 0.0 | 0.17857142857142858 | 10.0 |
SELECT TYPE FROM RESULT WHERE ID=? | 0.0 | 72 | 0.0 | 0.0 | 0.0 |
INSERT INTO PRIMARY_KEY (KEY_NAME, KEY_VALUE) VALUES (?, 0) | 0.0 | 4 | 0.0 | 0.0 | 0.0 |
INSERT INTO REPORT (ID, NAME, REPORT_NUMBER, HOST_NAME, HOST_ID, DESCRIPTION) VALUES (?, ?, ?, ?, ?, ?) | 0.0 | 1 | 0.0 | 0.0 | 0.0 |
UPDATE REPORT SET EXECUTION_TIME=? WHERE ID=? | 0.0 | 1 | 0.0 | 0.0 | 0.0 |
SELECT NAME FROM RESULT WHERE ID=? | 0.0 | 72 | 0.0 | 0.0 | 0.0 |
SELECT COUNT(*) FROM KINDRED WHERE ANCESTOR=? | 0.0 | 41 | 0.0 | 0.0 | 0.0 |
INSERT INTO ANNOTATION (RESULT_ID, HANDLE) VALUES (?, ?) | 0.0 | 2 | 0.0 | 0.0 | 0.0 |
UPDATE REPORT SET RESULT_ID=? WHERE ID=? | 0.0 | 1 | 0.0 | 0.0 | 0.0 |
UPDATE REPORT SET RESULT_ID=NULL WHERE ID<>? AND NAME=? | 0.0 | 1 | 0.0 | 0.0 | 0.0 |