Vertica Analytics Platform Version 9.2.x Documentation

QUERY_REQUESTS

Returns information about user-issued query requests.

If a query originates outside vsql, Vertica records information about the query in QUERY_REQUESTS only if global profiling is enabled by setting the following parameters to 1:

  • GlobalQueryProfiling
  • GlobalSessionProfiling
  • GlobalEEProfiling

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

No explicit privileges required. You can only see the records for requests associated with your user name. Users with SYSMONITOR or DBADMIN can see all records from all users.

See Also

QUERY_PROFILES