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