Get query monitoring data
GET/v1/query/monitoring
Get query monitoring data
Request
Query Parameters
The earliest timestamp to fetch queries for (inclusive). Accepts strings in the format YYYY-MM-DDTHH:mm:ss.sssZ with possibly omitted parts, e.g. YYYY-MM-DD.
The maximum number of inbound queries to fetch.
Whether or not to include query text in any subqueries.
The latest timestamp to fetch queries for (exclusive). Accepts strings in the format YYYY-MM-DDTHH:mm:ss.sssZ with possibly omitted parts, e.g. YYYY-MM-DD.
Header Parameters
Responses
- 200
- 400
- 401
- 500
A list of query monitoring data
- application/json
- Schema
- Example (from schema)
Schema
Array [
Array [
]
]
results
object[]
required
Possible values: [query_execution_info, subquery_execution_info]
subqueries
object[]
required
Possible values: [query_execution_info, subquery_execution_info]
extraProps
object
required
{
"results": [
{
"type": "query_execution_info",
"queryId": "string",
"catalogId": "string",
"catalogName": "string",
"modelId": "string",
"modelName": "string",
"receivedTime": "string",
"startedPlanning": "string",
"finishedPlanning": "string",
"queryFinished": "string",
"subqueries": [
{
"type": "query_execution_info",
"queryId": "string",
"queryText": "string",
"succeeded": true,
"started": "string",
"subqueryFetchStart": "string",
"finished": "string",
"dialect": "string",
"usedLocalCache": true,
"isCanary": true,
"extraProps": {},
"subqueryWaitDuration": 0,
"subqueryExecDuration": 0,
"subqueryFetchResultsDuration": 0,
"subqueryWallDuration": 0,
"subqueryWallRunningDuration": 0
}
],
"succeeded": true,
"aggregateDefinitionIds": [
"string"
],
"aggregateInstanceTableNames": [
"string"
],
"queryLanguage": "string",
"subqueriesResultsProcessingDuration": 0,
"queryWallDuration": 0,
"queryPrePlanningDuration": 0,
"queryPlanningDuration": 0,
"subqueriesWallDuration": 0,
"subqueriesWallRunningDuration": 0,
"subqueriesFirstWaitDuration": 0,
"queryWallRunningDuration": 0
}
]
}
Invalid request for example: Invalid parameters, missing parameters.
Unauthorized. This error will occur if calling user does not have access to the API.
A server error occurred. Check the logs for more details.