QUERY_REQUESTS
Returns information about user-issued query requests.
Column Name | Data Type | Description |
---|---|---|
NODE_NAME |
VARCHAR |
Name of the node that is reporting 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 when the session closes. |
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 |
STATEMENT_ID |
INTEGER |
Unique numeric ID 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 available. |
SEARCH_PATH |
VARCHAR |
Contents of the search path. |
MEMORY_ACQUIRED_MB |
FLOAT |
Memory acquired by this query request in megabytes. |
SUCCESS |
BOOLEAN |
Value returned if the query successfully executed. |
ERROR_COUNT |
INTEGER |
Number of errors encountered in this query request (logged in ERROR_MESSAGES table). |
START_TIMESTAMP |
TIMESTAMPTZ |
Beginning of history interval. |
END_TIMESTAMP |
TIMESTAMPTZ |
End of history interval. |
REQUEST_DURATION_MS |
INTEGER |
Length of time the query ran in milliseconds. |
IS_EXECUTING |
BOOLEAN |
Distinguishes between actively-running (t) and completed (f) queries. |
Privileges
No explicit privileges are required. You can only see the records for requests associated with your user name. Users with SYSMONITOR Role or DBADMIN Role can see all records from all users.