Running Queries

The running_queries system table displays information about queries running within your organization.

From a worksheet within Upsolver, run the following query:

SELECT * 
FROM system.monitoring.running_queries;

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:

ABORT QUERY '<query_id>';