The following example reports tuning overhead for days within an specified date range.
CALL TDSTATS.DAILYTUNINGOVERHEAD('{"BeginDate":"2024-02-04","EndDate":"2024-02-06"}');
Result:
| ReportDate | StatsAnalysisAMPCPUTime | StatsAnalysisCPUTime | StatsAnalysisTotalIOCount | StatsCollectAmpCPUTime | StatsCollectParserCUTime | StatsCollectTotalIOCount |
|---|---|---|---|---|---|---|
| 2024/02/04 | 805.404 | 382.864 | 27,740,234 | 149,956.204 | 18.768 | 171,017,493 |
| 2024/02/05 | 812.768 | 389.672 | 28,137,569 | 308,447.140 | 18.028 | 499,277,685 |
| 2024/02/06 | 796.000 | 363.388 | 27,611,268 | 13,170.412 | 1.392 | 11,939,461 |