SSRS Report Rendering Time

use ReportServer

GO

select top 10

  InstanceName,

  ItemPath,

  UserName,

  RequestType,

  Format,

  TimeStart,

  TimeEnd,

  CAST((TimeDataRetrieval)as numeric(18,2))/60000 TimeDataRetrieval,

  CAST((TimeProcessing)as numeric(18,2))/60000 TimeProcessing,

  CAST((TimeRendering)as numeric(18,2))/60000 TimeRendering,

  CAST((TimeDataRetrieval+TimeProcessing+TimeRendering)as numeric(18,2))/ 60000 [Total_Time(Minutes)]

 from ExecutionLog3