Period HammurapiTask

Root category.org.hammurapi.HammurapiTask

FromFri May 27 22:42:52 EDT 2005 (1117248172507)
To Fri May 27 22:49:12 EDT 2005 (1117248552733)
Min 0.0
Avg 0.9454495169611947
Max 1642.0
Total 99137.0
Measurements 104857.0
Deviation 1.2107162901050863
Length 380226

Composite chart

Average chart

Intensity chart

Total chart

Slices

#MinAvgMaxTotalMeasurementsDeviationFromToLength
10.00.00.00.00.00.0111724817250711172481801107603
20.00.00.00.00.00.0111724818011111172481877157604
30.00.00.00.00.00.0111724818771611172481953197603
40.00.00.00.00.00.0111724819532011172482029247604
50.00.00.00.00.00.0111724820292511172482105287603
60.00.603330102981072510.08.63665457648815914.3149737329766640.2513875429087802111724821052911172482181337604
70.00.644185598486648820.031.35907830168551448.6801915090243260.43959596903123466111724821813411172482257377603
80.00.00.00.00.00.0111724822573811172482333427604
90.00.00.00.00.00.0111724823334311172482409467603
100.00.00.00.00.00.0111724824094711172482485517604
110.00.00.00.00.00.0111724824855211172482561557603
120.00.00.00.00.00.0111724825615611172482637607604
130.00.00.00.00.00.0111724826376111172482713647603
140.00.00.00.00.00.0111724827136511172482789697604
150.00.2834588600451979460.046.5200811781759164.115812681805750.509799958426639111724827897011172482865737603
160.00.4086985256011874760.01375.80892068886033366.31730849792670.7203618272074043111724828657411172482941787604
170.00.3713125379306703270.02229.2307003789816003.650490237990.7121117079820192111724829417911172483017827603
180.00.3642747839527896270.02595.2546768885267124.4422925109020.672182349074445111724830178311172483093877604
190.00.388941374580722680.02747.38241406524967063.7442905808570.6648503829253414111724830938811172483169917603
200.00.8766558636086879310.02742.8100499217133128.71922014089071.324739716098429111724831699211172483245967604
210.00.8925133550802719310.03317.778918651053717.34372350389281.3639575864437772111724832459711172483322007603
220.00.540588599538179890.02315.69900299442274283.66229878451850.9022778574903092111724833220111172483398057604
230.00.6656080530951848110.02787.67477236936754188.162627249221.0258133664608424111724833980611172483474097603
240.00.6833289648550721301.03348.0214434155064899.5748981979581.0365065355909027111724834741011172483550147604
250.00.8035276044053237301.03094.3046346881253850.90022760097241.1283626158658018111724835501511172483626197604
260.01.023876160318229100.04117.6448465945954021.6239093942751.3697175723349122111724836262011172483702237603
270.00.60341277374921100.02821.17297836741054675.3617110862560.8686782657689838111724837022411172483778287604
280.00.510188438057717780.03222.98140187320276317.2372430529010.8002705610587415111724837782911172483854327603
290.00.6691396540115273430.04049.1570381222336051.2884176678580.9377034547158729111724838543311172483930377604
300.01.2414461177450677430.04599.2264334383823704.73302682866641.3261802357310655111724839303811172484006417603
310.00.6439141445370584270.03297.2122165446595120.5774007576540.848346136521254111724840064211172484082467604
320.00.7534392189791694270.03242.39754934736634303.4626651642480.9208046102550701111724840824711172484158507603
330.00.8331417299541193200.03026.57091582245363632.72034878042361.0122431597309856111724841585111172484234557604
340.00.91458879206620041642.04440.9005891522774855.6254216931541.1415599002546655111724842345611172484310597603
350.01.04468143908820351642.05096.10092974297554878.1386737289461.2341800068161624111724843106011172484386647604
360.00.91652481544894421642.03352.0834243656763657.38424957289861.1105346936586495111724843866511172484462687603
370.01.2845668826569636130.03152.31191600536162453.9881562921851.297343379206976111724844626911172484538737604
380.02.3905425626545016130.0499.1252551407631208.79162033681822.223448485498713111724845387411172484614777603
390.00.00.00.00.00.0111724846147811172484690827604
400.00.00.00.00.00.0111724846908311172484766867603
410.00.00.00.00.00.0111724847668711172484842917604
420.00.00.00.00.00.0111724848429211172484918957603
430.00.00.00.00.00.0111724849189611172484995007604
440.0204.2177315159083521.02986.942152469695414.62626252038754376.2492778427206111724849950111172485071047603
450.0282.9957025989528521.08014.10594240690128.31882558218238105.813678291893111724850710511172485147097604
460.09.800978754951602470.06931.795534801901707.25543928965818.99173569473911111724851471011172485223137603
470.04.548505035133267470.08275.3552413173221819.35716843168464.997682281347142111724852231411172485299187604
480.02.03711342577187390.01022.0315080347336501.705744562299231.3378076614907002111724852991911172485375227603
490.09.0211.0336.5788333188870637.314726532027391.725970929976786111724853752311172485451277604
500.00.00.00.00.00.0111724854512811172485527337605

Subcategories

#NameMinAvgMaxTotalMeasurementsDeviation%
1SELECT 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=00.011.054545454545455521.031008.02805.013.78666998538018331.28
2SELECT 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_VALUE0.07.901199040767386270.016474.02085.06.862351149061443516.62
3SELECT 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=20.08.28901734104046390.08604.01038.04.6818555483573318.68
4SELECT KEY_VALUE FROM PRIMARY_KEY WHERE KEY_NAME=?0.00.2793570828835312130.04658.016674.00.54832875096354924.7
5SELECT * FROM INSPECTOR WHERE REPORT_ID=? AND NAME=?0.00.3906650222939270.04118.010541.00.76797097040801434.15
6SELECT 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 DESC0.04.319634703196347330.03784.0876.05.0026967690828893.82
7SELECT COUNT(*) AS NCNT FROM RESULT R JOIN KINDRED K ON R.ID=K.DESCENDANT WHERE K.ANCESTOR=? AND R.IS_NEW=10.03.58148505303760831642.03714.01037.04.5484066692030313.75
8SELECT 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.NAME0.08.32301.03536.0425.07.12748663954083.57
9INSERT INTO VIOLATION (ID, RESULT_ID, REPORT_ID, INSPECTOR, MESSAGE_ID, SOURCE_ID, LINE, COL, SIGNATURE_POSTFIX, VIOLATION_TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)0.00.48375298916865944190.03439.07109.00.93278857377467623.47
10UPDATE RESULT SET COMMITED=1, HAS_WARNINGS = (SELECT COUNT(*) FROM VIOLATION V WHERE V.RESULT_ID=RESULT.ID AND VIOLATION_TYPE=2) WHERE ID=?0.09.33522727272727361.03286.0352.06.6860934360694583.31
11SELECT 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=00.01.245535714285714250.02511.02016.02.33356008115322042.53
12UPDATE RESULT SET VIOLATIONS=? WHERE ID=?0.00.227113177117920560.02394.010541.00.44194531659385612.41
13UPDATE PRIMARY_KEY SET KEY_VALUE=KEY_VALUE+1 WHERE KEY_NAME=?0.00.136952609478104460.02283.016670.00.26795834123285072.3
14UPDATE RESULT SET VIOLATION_LEVEL=? WHERE ID=?0.00.2062422920026562970.02174.010541.00.40884742022456692.19
15INSERT INTO MEASUREMENT (ID, RESULT_ID, NAME, MEASUREMENT_VALUE, SOURCE, LINE, COL) VALUES (?, ?, ?, ?, ?, ?, ?)0.00.2718927850192766660.01481.05447.00.57846004211819851.49
16SELECT 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=00.02.736470588235294261.01163.0425.03.37683540599248431.17
17INSERT INTO VIOLATION (ID, RESULT_ID, REPORT_ID, INSPECTOR, MESSAGE_ID, SOURCE_ID, LINE, COL, VIOLATION_TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)0.00.338286713286713370.01161.03432.00.67449134272300491.17
18SELECT 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=10.00.482160077145612350.0500.01037.00.92286962429436910.5
19SELECT ID, TYPE FROM RESULT WHERE COMPILATION_UNIT=? AND COMMITED=10.01.204819277108433860.0400.0332.02.0482915342386240.4
20UPDATE RESULT SET CODEBASE=? WHERE ID=?0.00.543674698795180750.0361.0664.01.00865732466953140.36
21SELECT COMPILATION_UNIT FROM RESULT WHERE ID=?0.00.2364607170099160850.0310.01311.00.3949043216181020.31
22SELECT HANDLE FROM ANNOTATION WHERE RESULT_ID=?0.00.215827338129496440.0300.01390.00.332714493075236650.3
23SELECT * FROM METRIC WHERE RESULT_ID=? AND NAME=?0.00.152532031726662650.0250.01639.00.32635723128527250.25
24SELECT 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=10.03.083333333333333511.0222.072.03.95114813873411030.22
25INSERT INTO METRIC (RESULT_ID,NAME) VALUES (?,?)0.00.092129347162904220.0151.01639.00.195035719978763650.15
26INSERT INTO KINDRED (ANCESTOR, DESCENDANT) SELECT A.ANCESTOR, D.DESCENDANT FROM KINDRED A, KINDRED D WHERE A.DESCENDANT=? AND D.ANCESTOR=? 0.00.428977272727272730.0151.0352.00.57011325383183380.15
27UPDATE RESULT SET MAX_SEVERITY=? WHERE ID=?0.00.1890331890331890350.0131.0693.00.276319920248224050.13
28SELECT * FROM RESULT_NET WHERE PARENT=? AND CHILD=?0.00.312520.0110.0352.00.5157544464787330.11
29UPDATE RESULT SET REVIEWS=? WHERE ID=?0.00.1521084337349397611.0101.0664.00.21729617403491140.1
30INSERT INTO RESULT (ID, TYPE, RESULT_DATE, CODEBASE) VALUES (?, ?, ?, 0)0.00.2294617563739376811.081.0353.00.268950018414596540.08
31INSERT INTO RESULT_NET (PARENT, CHILD) VALUES (?,?)0.00.114893617021276620.081.0705.00.207967768894325780.08
32UPDATE RESULT SET COMPILATION_UNIT=?, IS_NEW=1 WHERE ID=?0.00.1807228915662650610.060.0332.00.312704385971722950.06
33INSERT INTO MEASUREMENT (ID, RESULT_ID, NAME, MEASUREMENT_VALUE) VALUES (?, ?, ?, ?)0.00.1506024096385542310.050.0332.00.26843476783258120.05
34UPDATE RESULT SET NAME=? WHERE ID=?0.00.1133144475920679910.040.0353.00.20147913405129730.04
35INSERT INTO KINDRED (ANCESTOR, DESCENDANT) VALUES (?, ?)0.00.05665722379603399510.020.0353.00.11190264826472710.02
36SELECT R.ID FROM RESULT R JOIN RESULT_NET N ON N.CHILD=R.ID WHERE N.PARENT=? and N.PARENT<>N.CHILD0.00.952380952380952310.020.021.00.86167800453514740.02
37SELECT NAME FROM RESULT WHERE ID=?0.00.138888888888888910.010.072.00.195624290036033040.01
38INSERT INTO PRIMARY_KEY (KEY_NAME, KEY_VALUE) VALUES (?, 0)0.00.00.00.04.00.00
39INSERT INTO INSPECTOR (REPORT_ID, NAME, SEVERITY, DESCRIPTION, CONFIG_INFO) VALUES (?, ?, ?, ?, ?)0.00.00.00.056.00.00
40UPDATE REPORT SET RESULT_ID=? WHERE ID=?0.00.00.00.01.00.00
41INSERT INTO REPORT (ID, NAME, REPORT_NUMBER, HOST_NAME, HOST_ID, DESCRIPTION) VALUES (?, ?, ?, ?, ?, ?)0.00.00.00.01.00.00
42SELECT TYPE FROM RESULT WHERE ID=?0.00.00.00.072.00.00
43SELECT COUNT(*) FROM KINDRED WHERE ANCESTOR=?0.00.00.00.041.00.00
44INSERT INTO ANNOTATION (RESULT_ID, HANDLE) VALUES (?, ?)0.00.00.00.02.00.00

Averages chart

Intensities chart

Totals chart