Return Return     Main page Main page      Update Update     PDF PDF     Choice of period :  Day Day  Week Week  All All  Customized Customized


           (m/d/yy)     



Request Hits by parent request Mean time (ms)Max time (ms) Standard deviationMean cpu time (ms) Mean allocated Kb % of system error Mean hits sql Mean time sql (ms)
http  /getSDHomeDashboardFilters.* ajax POST  176 699 101 124 133,904 0.00 16 33
sql  graphselect sdprojectt1_.ProjectTypeID as col_0_0_ from sd_project_details sdprojectd0_ cross join sd_projecttype_master sdprojectt1_ where sdprojectd0_.ParameterID=3 and sdprojectd0_.ProjectID=? and sdprojectd0_.ParameterValue=sdprojectt1_.ProjectTypeID
 1.00 1 270 9     0.00    
sql  graphselect sdprojectm0_.ProjectID as col_0_0_ from sd_project_master sdprojectm0_ cross join sd_project_details sdprojectd1_ where sdprojectd1_.ParameterID=3 and sdprojectd1_.ParameterValue=? and sdprojectd1_.ProjectID=sdprojectm0_.ProjectID and sdprojectm0_.Status=0 and (sdprojectm0_.ProjectID in (select distinct sdprojectr2_.ProjectID from sd_project_roles sdprojectr2_ cross join sd_project_roles_details sdprojectr3_ where sdprojectr2_.ProjectRoleID=sdprojectr3_.ProjectRoleID and sdprojectr3_.UserID=?))
 2.00 1 273 9     0.00    
sql  graphselect distinct sdprojectr0_.ProjectRoleID as col_0_0_ from sd_project_roles_details sdprojectr0_ inner join sd_project_roles sdprojectr1_ on sdprojectr0_.ProjectRoleID=sdprojectr1_.ProjectRoleID where sdprojectr1_.RoleName=? and sdprojectr1_.ProjectID=? and sdprojectr0_.UserID=?
 2.13 1 105 3     0.00    
sql  graphselect distinct sdprojectr1_.ProjectRoleID as col_0_0_ from sd_project_roles_details sdprojectr0_ inner join sd_project_roles sdprojectr1_ on sdprojectr0_.ProjectRoleID=sdprojectr1_.ProjectRoleID where sdprojectr0_.ProjectRoleID=sdprojectr1_.ProjectRoleID and sdprojectr1_.ProjectID=? and sdprojectr0_.UserID=?
 1.13 1 2,060 17     0.00    
sql  graphselect groupdetai0_.GroupID as col_0_0_ from groupdetail groupdetai0_ where groupdetai0_.UserID=?
 1.00 1 61 4     0.00    
jsp  graph/SD_DashboardFilters.jsp
 1.00 2 2 0 0 249 0.00    
sql  graphselect sdprojectr0_.AccessValue as col_0_0_ from sd_project_roles_access sdprojectr0_ where (sdprojectr0_.ProjectRoleID in (? , ? , ? , ? , ? , ?)) and sdprojectr0_.AccessValue=?
 0.17 1 163 4     0.00    
sql  graphselect sdprojectr0_.AccessValue as col_0_0_ from sd_project_roles_access sdprojectr0_ where (sdprojectr0_.ProjectRoleID in (? , ? , ? , ? , ?)) and sdprojectr0_.AccessValue=?
 0.13 1 299 13     0.00    

      
zoom
The units of the values are "m" for milli (1 / 1000), "k" for kilo/thousands, "M" for mega/millions, "G" for giga/billions and "u" for micro (1 / 1000000)
Last value    XML    TXT
Powered by JavaMelody