QUERY_REQUESTS

Returns information about user-issued 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 NULL.
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:

  • QUERY

  • DDL

  • LOAD

  • UTILITY

  • TRANSACTION

  • PREPARE

  • EXECUTE

  • SET

  • SHOW

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 TIMESTAMPTZ Length of time in days, hours, minutes, seconds, and milliseconds.
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

Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.

See also

QUERY_PROFILES