Information schema for running queries
You can use the catalog.running_queries
view to return information about queries currently running in a database. The view is available in each database and contains one row for each running query in the database. You can use a SELECT
query to return information about each running query as shown in the example below.
SELECT
*
FROM
catalog.running_queries
LIMIT
100;
Columns in catalog.running_queries
Each row has the following columns with information about each running query.
Column Name | Data type | Description |
---|---|---|
ENGINE_ID | STRING | The ID of the engine that was used to execute the query. |
ENGINE_NAME | STRING | The name of the engine that was used to execute the query. |
ACCOUNT_ID | STRING | The ID of the account in which the query was executed. |
USER_ID | STRING | The user ID that was used to execute the query. |
START_TIME | TIMESTAMP | The query execution start time (UTC). |
STATUS | STRING | The status of the query. Always contains the value ‘RUNNING’. |
DURATION | DOUBLE | The elapsed time in milliseconds between <START_TIME> and the time that the query over catalog.running_queries returns results. |
QUERY_ID | STRING | The unique identifier of the SQL query. |
QUERY_TEXT | STRING | Text of the SQL statement. |
SCANNED_ROWS | LONG | The number of rows scanned to return query results. |
SCANNED_BYTES | LONG | The number of bytes scanned from cache and storage. |
INSERTED_ROWS | LONG | The number of rows written. |
INSERTED_BYTES | LONG | The number of bytes written. |