What is execution time measuring in report_stats?

Lisa Baremore
Tera Expert

What is the execution time measuring in the report_stats table?

I understand that run time is the average execution time in milliseconds of all runs of the report, and recent run time is the average execution time of the report in milliseconds based on the 25 most recent runs. So what is the execution time field measuring? Is it the most recent execution time, relating to the field "last run"?

I see a lot of very high execution times with very low run times and low recent run times in my table. I am trying to understand how to interpret this overall.

Thanks!

1 ACCEPTED SOLUTION

Marcello Correa
ServiceNow Employee
ServiceNow Employee

Hi Lisa,

That field lists the aggregated sum of all run times for that particular widget. 

View solution in original post

12 REPLIES 12

So how to calculate the final execution time of individual dashboard

Lisa Baremore
Tera Expert

Actually mine does have an execution time field. Perhaps my instance is different than yours, I am on Kingston. Here are the fields in my table.

 

find_real_file.png

Thanks!

That's weird, I am also on Kingston but i dont have it. Neither I could find it on London as well.

 

Lisa Baremore
Tera Expert

I think it is what you listed: 5) Total executions duration - Total execution duration for all executions

I was looking at the column label but you did list the actual field name. I think we got it!!! Thank you so much Alikutty!

 

find_real_file.png

 

 

SanjivMeher
Kilo Patron
Kilo Patron

I do see Execution time on Report Stat table. It could be the number time the report has been executed

 

find_real_file.png


Please mark this response as correct or helpful if it assisted you with your question.