Vertica Analytics Platform Version 9.3.x Documentation

UDX_EVENTS

Records information about events raised from the execution of user-defined extensions.

A UDx populates the __RAW__ column using ServerInterface::logEvent() (C++ only). VMap support is provided by Flex Tables, which must not be disabled.

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

Privileges

Superuser

Column Name Data Type Description
REPORT_TIME TIMESTAMPTZ Time the event occurred.
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 user running the UDx.

USER_NAME VARCHAR Identifies the user running the UDx.
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.
UDX_NAME

VARCHAR

Name of the UDx, as specified in the corresponding CREATE FUNCTION statement.

__RAW__

VARBINARY

VMap containing UDx-specific values.