UDFS_EVENTS

Records information about events involving the S3, HDFS, GCS, and Azure file systems.

Records information about events involving the S3, HDFS, GCS, and Azure file systems.

Column Name Data Type Description
START_TIME TIMESTAMPTZ Event start time
END_TIME TIMESTAMPTZ Event end time
NODE_NAME VARCHAR Name of the node that reported the event
SESSION_ID VARCHAR Identifies the event session, unique within the cluster at any point in time but can be reused when the session closes.
USER_ID INTEGER Identifies the event user.
TRANSACTION_ID* INTEGER Identifies the event transaction within the SESSION_ID-specified session, if any; otherwise NULL.
STATEMENT_ID* INTEGER Uniquely identifies the current statement, if any; otherwise NULL.
REQUEST_ID* INTEGER Uniquely identifies the event request in the user session.
FILESYSTEM VARCHAR Name of the file system, such as S3
PATH VARCHAR Complete file path
EVENT VARCHAR An event type, such as HttpRequestAttempt, or a function call, such as virtual size_t SAL::S3FileOperator::read(void*, size_t)
STATUS VARCHAR Status of the event: OK, CANCEL, or FAIL
DESCRIPTION VARCHAR Other event details. Depending on the event type, this column can be plain text or JSON.
ACTIVITY VARCHAR Points to the component that was active and logged the event, for internal use only.
PLAN_ID VARCHAR Uniquely identifies the node-specific Optimizer plan for this event.
OPERATOR_ID INTEGER Identifier assigned by the Execution Engine operator instance that performs the work

* In combination, TRANSACTION_ID, STATEMENT_ID, and REQUEST_ID uniquely identify an event within a given session.

Privileges

Superuser