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  159 807 85 119 134,258 0.00 15 26
sql  graphSelect SettingValue from sd_configsettings where SettingKEY=? and ProjectID=? and (ServiceID=? or ServiceID=0)
 1.00 1 822 6     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 170 4     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 11     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.75 1 306 6     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.01 2 60,081 170     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 338 6     0.00    
sql  graphselect groupdetai0_.GroupID as col_0_0_ from groupdetail groupdetai0_ where groupdetai0_.UserID=?
 1.00 0 47 2     0.00    
jsp  graph/SD_DashboardFilters.jsp
 1.00 1 3 0 3 264 0.00    
sql  graphselect sdprojectr0_.AccessValue as col_0_0_ from sd_project_roles_access sdprojectr0_ where (sdprojectr0_.ProjectRoleID in (? , ? , ? , ?)) and sdprojectr0_.AccessValue=?
 0.26 1 119 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.01 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.01 1 433 6     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