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