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