API Definition
REPLACE PROCEDURE TDStats.DailyQueryActivity(
IN jIn JSON(2000) CHARACTER SET UNICODE)
DYNAMIC RESULT SETS 1
JSON Input Keys
| JSON Key | Data Type | Description |
|---|---|---|
| BeginDate | DATE | Starting date for query activity. |
| EndDate | DATE | Ending date for query activity. |
| LogDatabaseName | VARCHAR(128) | Source of DBQL telemetry. Supported values are ‘DBC’ and ‘TD_METRIC_SVC' (default). |
| ByUser | BOOLEAN | When true, break down results by individual users. Default is false. |
| ReturnTable | BOOLEAN | When true, results will be stored in a session level temporary table named AutoDBA_DailyQueryActivity rather than being returned as a dynamic result. Default is false. |
Dynamic SQL Result Columns
| Column Name | Data Type | Description |
|---|---|---|
| ReportDate | DATE | Date for reported usage. |
| UserOrUtility | VARCHAR(25) | Name of user executing queries or Load Utility name. Returned only when ByUser is true. |
| NumQueriesForAutoDBA | BIGINT | Number of queries referencing AutoDBA designated objects. |
| NumQueriesForStatsTuning | BIGINT | Number of queries referencing AutoDBA designated objects and having stats tuning opportunities. |
| NumTableLoads | BIGINT | Number of bulk table load operations. |
| QueryAmpCPUTime | FLOAT | Amp CPU usage from AutoDBA eligible queries as recorded by DBQL. |
| QueryParserCPUTime | FLOAT | Parser CPU usage from AutoDBA eligible queries as recorded by DBQL. |
| QueryTotalIOCount | FLOAT | IO usage from AutoDBA eligible queries as recorded by DBQL. |
| TableLoadsUDICount | BIGINT | Total rows updated, deleted, or inserted during bulk loads. |