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