The following example reports query activity for the past three days.
CALL TDSTATS.DAILYQUERYACTIVITY('{"BeginDate":"CURRENT_DATE - 2","EndDate":"CURRENT_DATE"}');
Result:
| ReportDate | NumQueriesForAutoDBA | NumQueriesForStatsTuning | QueryAmpCPUTime | QueryParserCPUTime | QueryTotalIOCount |
|---|---|---|---|---|---|
| 2024/02/04 | 268 | 237 | 135,160.944 | 10.656 | 549,924,918 |
| 2024/02/05 | 38212 | 867 | 267,167.816 | 407.052 | 473,901,883 |
| 2024/02/06 | 337 | 235 | 256,825.940 | 14.800 | 834,812,156 |