PROJECTION_STORAGE

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

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

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 Number of bytes in disk storage used to store the compressed projection data. This value should not be compared to the output of the AUDIT function, which returns the raw data size of database objects.
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.
DISK_SIZE INTEGER Size in bytes of the projection's compressed storage.

See also