QUERY_EVENTS

Returns information about query planning, optimization, and execution events.

Column Name Data Type Description
EVENT_TIMESTAMP

TIMESTAMPTZ

Time when Vertica recorded the event.

NODE_NAME

VARCHAR

Name of the node that is reporting the requested information.

USER_ID

INTEGER

Identifier of the user for the query event.

USER_NAME

VARCHAR

Name of the user for which Vertica lists query information at the time it 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.

EVENT_CATEGORY

VARCHAR

Category of event: OPTIMIZATION or EXECUTION.

EVENT_TYPE

VARCHAR

Type of event. For a list of events and their descriptions, see Check Query Events Proactively.

EVENT_DESCRIPTION

VARCHAR

Generic description of the event.

OPERATOR_NAME

VARCHAR

Name of the Execution Engine component that generated the event, if applicable; for example, NetworkSend. Values from the OPERATOR_NAME and PATH_ID columns let you tie a query event back to a particular operator in the query plan. If the event did not come from a specific operator, the OPERATOR_NAME column is NULL.

PATH_ID

INTEGER

Unique identifier that Vertica assigns to a query operation or path in a query plan. If the event did not come from a specific operator, the PATH_ID column is NULL.

See EXECUTION_ENGINE_PROFILES for more information.

OBJECT_ID

INTEGER

Object identifier (such as projection or table) to which the event refers.

EVENT_DETAILS

VARCHAR

Free-form text describing the specific event.

SUGGESTED_ACTION

VARCHAR

Suggested user action, if any is available.

Privileges

No explicit privileges are required. You only see the records for tables that you have privileges to view.

See Also