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 |
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 |
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.