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  161 807 87 121 134,276 0.00 15 27
sql  graphSelect SettingValue from sd_configsettings where SettingKEY=? and ProjectID=? and (ServiceID=? or ServiceID=0)
 1.00 1 4,109 13     0.00    
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 5     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 812 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=?
 1.78 1 271 5     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.02 2 60,081 165     0.00    
sql  graphselect sdprojectr0_.AccessValue as col_0_0_ from sd_project_roles_access sdprojectr0_ where (sdprojectr0_.ProjectRoleID in (? , ? , ? , ?)) and sdprojectr0_.AccessValue=?
 0.28 1 389 5     0.00    
sql  graphselect sdconfigse0_.SettingValue as col_0_0_ from sd_configsettings sdconfigse0_ where sdconfigse0_.ProjectID=? and (sdconfigse0_.ServiceID=? or sdconfigse0_.ServiceID=0) and sdconfigse0_.SettingKEY=?
 0.76 1 1,096 6     0.00    
sql  graphselect groupdetai0_.GroupID as col_0_0_ from groupdetail groupdetai0_ where groupdetai0_.UserID=?
 1.00 1 61 3     0.00    
jsp  graph/SD_DashboardFilters.jsp
 1.00 6 268 23 3 652 0.00    
sql  graphselect sdprojectr0_.AccessValue as col_0_0_ from sd_project_roles_access sdprojectr0_ where (sdprojectr0_.ProjectRoleID in (? , ? , ? , ? , ? , ?)) and sdprojectr0_.AccessValue=?
 0.22 1 163 5     0.00    
sql  graphselect sdprojectr0_.AccessValue as col_0_0_ from sd_project_roles_access sdprojectr0_ where (sdprojectr0_.ProjectRoleID in (? , ? , ?)) and sdprojectr0_.AccessValue=?
 0.29 1 276 6     0.00    
sql  graphselect sdprojectr0_.AccessValue as col_0_0_ from sd_project_roles_access sdprojectr0_ where (sdprojectr0_.ProjectRoleID in (? , ? , ? , ? , ? , ? , ?)) and sdprojectr0_.AccessValue=?
 0.02 1 263 3     0.00    
sql  graphselect sdprojectr0_.AccessValue as col_0_0_ from sd_project_roles_access sdprojectr0_ where (sdprojectr0_.ProjectRoleID in (? , ? , ? , ? , ?)) and sdprojectr0_.AccessValue=?
 0.02 1 433 8     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