Running Queries
The running_queries system table displays information about queries running within your organization.
From a worksheet within Upsolver, run the following query:
The system.monitoring.running_queries table includes the following columns:
Column | Type | Description |
---|---|---|
bytes_scanned | bigint | The number of bytes scanned to fulfil the query result. |
duration_millis | bigint | The total or ongoing running time of the query in milliseconds. |
items_scanned | bigint | The number of items scanned to fulfil the query result. |
query | string | The SQL syntax executed by the query engine. |
query_id | string | The unique identifier for the query. |
start_time | datetime | The date and time in UTC format when the query was executed. |
Cancel a Running Query
To cancel a running query, click the Cancel button in the Event Log tab in the Upsolver query editor window.
Alternatively, run an ABORT QUERY
statement using the query_id value for your SQL statement, taken from the system.monitoring_running_queries table:
Last updated