PROJECTION_STORAGE

Monitors the amount of disk storage used by each projection on each node.

Note: Projections that have no data never have full statistics. Querying this system table lets you see if your projection contains data.

Column Name Data Type Description
NODE_NAME

VARCHAR

The node name for which information is listed.

PROJECTION_ID

VARCHAR

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

PROJECTION_NAME

VARCHAR

The projection name for which information is listed.

PROJECTION_SCHEMA

VARCHAR

The name of the schema associated with the projection.

PROJECTION_COLUMN_COUNT

INTEGER

The number of columns in the projection.

ROW_COUNT

INTEGER

The number of rows in the table's projections, including any rows marked for deletion.

USED_BYTES

INTEGER

The number of bytes of disk storage used by the projection.

WOS_ROW_COUNT

INTEGER

The number of WOS rows in the projection.

WOS_USED_BYTES

INTEGER

The number of WOS bytes in the projection.

ROS_ROW_COUNT

INTEGER

The number of ROS rows in the projection.

ROS_USED_BYTES

INTEGER

The number of ROS bytes in the projection.

ROS_COUNT

INTEGER

The number of ROS containers in the projection.

ANCHOR_TABLE_NAME

VARCHAR

The associated table name for which information is listed.

ANCHOR_TABLE_SCHEMA

VARCHAR

The associated table schema for which information is listed.

ANCHOR_TABLE_ID
INTEGER A unique numeric ID, assigned by the Vertica catalog, which identifies the anchor table.

See Also