Vertica Analytics Platform Version 10.1.x Documentation

PROJECTION_STORAGE

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

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

Catalog-assigned numeric value that uniquely 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

(Deprecated) The number of WOS rows in the projection.

WOS_USED_BYTES

INTEGER

(Deprecated) 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