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.
Events are logged if they take longer to complete than the threshold specified by UDFSSlowRequestThreshold (default 1000ms).
HTTP requests are logged if they take longer to complete than the threshold specified by HTTPSlowRequestThreshold (default 500ms), or if they produce errors or are retries. HTTP requests are logged only for S3.
| 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