| account_name | TEXT | The name of the account that ran the query. |
| user_name | TEXT | The user name that was used to run the query. The user_name is present for account-level operations, and NULL for organization-level operations. |
| login_name | TEXT | The login name that was used to run the query. The login_name is present for organization-level statements, and otherwise NULL (not supported in Firebolt OSS). |
| service_account_name | TEXT | The service account name that was used to run the query. The service_account_name is present for organization-level statements, and otherwise NULL (not supported in Firebolt OSS). |
| submitted_time | TIMESTAMPTZ | The time that the user submitted the query. |
| start_time | TIMESTAMPTZ | The time that the query started running in Coordinated Universal Time (UTC). |
| end_time | TIMESTAMPTZ | The time that the query stopped running in UTC. |
| duration_us | BIGINT | The duration of query run time in microseconds. |
| e2e_duration_us | BIGINT | The end-to-end duration of query run time. Starting from the time the query was submitted and ending when the result was fully returned in microseconds. |
| status | TEXT | Can be one of the following values:
STARTED_EXECUTION–Successful start of query execution.
ENDED_SUCCESSFULLY–Successful end of query execution.
CANCELED_EXECUTION–Query was canceled.
PARSE_ERROR–Query could not be parsed.
EXECUTION_ERROR–Query could not be executed successfully. |
| request_id | TEXT | The ID of the request from which the query originates. |
| query_id | TEXT | The unique identifier of the SQL query. |
| query_label | TEXT | A user-provided query label. |
| query_text | TEXT | The text of the SQL statement. |
| query_text_normalized | TEXT | The normalized text of the SQL statement. |
| query_text_normalized_hash | TEXT | The hash of the normalized text of the SQL statement. |
| telemetry | TEXT | Displays additional telemetry information about the query in JSON format. Currently, only SELECT queries and VACUUM jobs provide telemetry. |
| error_message | TEXT | The returned error message. |
| scanned_rows | BIGINT | The total number of rows scanned. |
| scanned_bytes | BIGINT | The total number of uncompressed bytes scanned. |
| scanned_cache_bytes | BIGINT | The total number of compressed bytes scanned from disk-based cache. |
| scanned_storage_bytes | BIGINT | The total number of compressed bytes scanned from Firebolt-managed storage. Does not apply to EXTERNAL tables. |
| inserted_rows | BIGINT | The total number of rows written. |
| inserted_bytes | BIGINT | The total number of bytes written to both cache and storage. |
| spilled_bytes | BIGINT | The total number of uncompressed bytes spilled. |
| peak_memory_bytes | BIGINT | Peak memory usage by the query. For distributed queries represents the peak memory used by any node. |
| returned_rows | BIGINT | The total number of rows returned from the query. |
| returned_bytes | BIGINT | The total number of bytes returned from the query. |
| time_in_queue_us | BIGINT | The number of microseconds the query spent in queue. |
| retries | BIGINT | The number of retried attempts in case of query failure. Defaults to 0. |
| node_ordinal | INTEGER | Index of the node in the cluster that has received the query and manages the execution of it. (1-indexed) |
| cluster_ordinal | INTEGER | Index of the cluster in the engine that has received the query and executes it. (1-indexed) |
| number_of_clusters | INTEGER | Number of cluster in the engine at the point of query execution. |
