Information schema
Engine running queries
Use this reference to learn about the metadata available for running queries in Firebolt using the information schema.
You can use the information_schema.engine_running_queries view to return information about queries currently running in a database. This view is available in each database and includes one row for each running query. The table contains a maximum of ten thousand queries per engine cluster. You can use a SELECT query to return information about each running query as shown in the example below.
Columns in information_schema.engine_running_queries
Each row has the following columns with information about each running query.
| Column Name | Data Type | Description |
|---|---|---|
| account_name | TEXT | The name of the account in which the query was executed. |
| user_name | TEXT | The user that executed the query |
| submitted_time | TIMESTAMPTZ | The time when the query was submitted by a user (UTC) |
| start_time | TIMESTAMPTZ | The query execution start time (UTC). |
| duration_us | BIGINT | The time elapsed in microseconds from <START_TIME> to when the query on information_schema.engine_running_queries returns results. |
| e2e_duration_us | BIGINT | The time elapsed in microseconds from the time of query submission to when the query on information_schema.engine_running_queries returns results. |
| status | TEXT | The status of the query, eiteher RUNNING, SUSPENDED, or CANCELING. |
| request_id | TEXT | The ID of the request from which the query originates. |
| query_id | TEXT | The query id of this query. |
| query_label | TEXT | User provided query label (query_label parameter) |
| query_text | TEXT | Text of the SQL statement. |
| scanned_rows | BIGINT | The number of rows scanned to return query results. |
| scanned_bytes | BIGINT | The number of bytes scanned from cache and storage. |
| inserted_rows | BIGINT | The number of rows written |
| inserted_bytes | BIGINT | The number of bytes written. |
| async_token | TEXT | If the query is an async query, this handle can be used to check the status via the built in stored procedure fb_GetAsyncStatus(<async_token>). |
| retries | BIGINT | The total number of retries executed for a given query after a failure (by default, the number of retries is 0 and the number increases with each retry). |
| telemetry | TEXT | Displays additional telemetry information about the query in JSON format. This data is currently only available for VACUUM queries and jobs. |