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:

ColumnTypeDescription

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>';

Last updated