QUERY_REQUESTS
Returns information about user-issued query requests.
Returns information about user-issued query requests. A statement can include more than one query request; for example, adding data to a table could include a constraint check in addition to a load or insert request.
For a consolidated view with one row per statement, see STATEMENT_OUTCOMES.
| Column Name | Data Type | Description |
|---|---|---|
| NODE_NAME | VARCHAR | Name of the node that reported the requested information. |
| USER_NAME | VARCHAR | Name of the user who issued the query at the time Vertica recorded the session. |
| SESSION_ID | VARCHAR | Identifier for this session. This identifier is unique within the cluster at any point in time but can be reused after the session ends. |
| REQUEST_ID | INTEGER | Unique identifier of the query request in the user session. |
| TRANSACTION_ID | INTEGER | Identifier for the transaction within the session, if any, otherwise NULL. |
| STATEMENT_ID | INTEGER | Unique identifier for the currently-running statement. NULL indicates that no statement is currently being processed. The combination of TRANSACTION_ID, STATEMENT_ID, and REQUEST_ID uniquely identifies a statement within a session. |
| REQUEST_TYPE | VARCHAR |
Type of the query request. Examples include, but are not limited to:
|
| REQUEST | VARCHAR | Query statement. |
| REQUEST_LABEL | VARCHAR | Label of the query, if any. |
| SEARCH_PATH | VARCHAR | Contents of the search path. |
| MEMORY_ACQUIRED_MB | FLOAT | Memory acquired by this query request in megabytes. |
| SUCCESS | BOOLEAN | Whether the query request succeeded. |
| ERROR_COUNT | INTEGER | Number of errors encountered in this query request (logged in ERROR_MESSAGES). |
| START_TIMESTAMP | TIMESTAMPTZ | Beginning of history interval. |
| END_TIMESTAMP | TIMESTAMPTZ | End of history interval. |
| REQUEST_DURATION | TIMESTAMPTZ | Query request execution time in days, hours, minutes, seconds, and milliseconds. |
| REQUEST_DURATION_MS | INTEGER | Query request execution time in milliseconds. |
| IS_EXECUTING | BOOLEAN | Whether the query request is currently running. |
Privileges
Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.