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.
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