PROJECTION_USAGE

Records information about projections Vertica used in each processed query.

Column Name Data Type Description
QUERY_START_TIMESTAMP

TIMESTAMPTZ

Value of query at beginning of history interval.

NODE_NAME

VARCHAR

Name of the node that is reporting the requested information.

USER_NAME

VARCHAR

Name of the user at the time Vertica 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.

IO_TYPE

VARCHAR

Input/output.

PROJECTION_ID

INTEGER

Unique numeric ID assigned by the Vertica catalog, which identifies the projection.

PROJECTION_NAME

VARCHAR

Projection name for which information is listed.

ANCHOR_TABLE_ID

INTEGER

Unique numeric ID assigned by the Vertica, which identifies the anchor table.

ANCHOR_TABLE_SCHEMA

VARCHAR

Name of the schema that contains the anchor table.

ANCHOR_TABLE_NAME

VARCHAR

Name of the projection's associated anchor table.

Privileges

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