What is execution time measuring in report_stats?

[Lisa Baremore]

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!

[Alikutty A]

Hi Lisa,

You can get all the individual execution duration from the report_stats_executions table. Just search on the report name in this table and it would list you the execution time for all recent executions. You can see an Execution duration column which gives the required execution time.

Thanks!

[Lisa Baremore]

Thanks so much! But do you know what the execution time field in the report_stats table is showing? Is it the most recent execution?

[Alikutty A]

report_stats does not store the recent or any of its execution time instead it has the following fields:

1) Number executions total - Number of times report was executed (eg 30 times a report was run)

2) Average execution duration - Average of all report execution times (eg Sum of all 30 execution times/30)

3) Recent number executions - Count for Last 25 executions of a report (ie from execution number 5 to 30)

4) Recent avg execution duration - Average execution time for last 25 executions

5) Total executions duration - Total execution duration for all executions

And the report_stats_executions table contains 30 different entries with execution time for each instance.

If you need to see the recent execution time, then you can check the report_stats_executions table for latest Execution timestamp and its execution duration is the required time.

If I answered your query, can you please mark my response as correct answer?

Thanks

[JosephW1]

Since @Alikutty Abdulrazak used technical jargon (field names) rather than field labels - which is fine, thank you Alikutty - I just wanted to relist his comment using the plain jargon (field labels) that people see while on the table.

Since I'm just reusing his content, all credit goes to him.

1. Runs (number_executions_total) - Number of times report was executed (eg 30 times a report was run)

2. Run time (average_execution_duration) - Average of all report execution times (eg Sum of all 30 execution times/30)

3. Recent number executions (recent_number_executions) - Count for Last 25 executions of a report (ie from execution number 5 to 30)

4. Recent run time (recent_avg_execution_duration) - Average execution time for last 25 executions

5. Execution time (total_executions_duration) - Total execution duration for all executions

This would probably be the clearest answer for this question, but it should go to Alikutty.

I hope that helps!

Kind Regards,
Joseph