COLUMN_STORAGE
Returns the amount of disk storage used by each column of each projection on each node.
| Column Name | Data Type | Description |
|---|---|---|
| NODE_NAME |
VARCHAR |
The node name for which information is listed. |
| COLUMN_ID |
INTEGER |
Catalog-assigned integer value that uniquely identifies the column. |
| COLUMN_NAME |
VARCHAR |
The column name for which information is listed. |
| ROW_COUNT |
INTEGER |
The number of rows in the column. |
| USED_BYTES |
INTEGER |
The disk storage allocation of the column in bytes. |
| ENCODINGS |
VARCHAR |
The encoding type for the column. |
| COMPRESSION |
VARCHAR |
The compression type for the column. You can compare |
| WOS_ROW_COUNT |
INTEGER |
(Deprecated) The number of WOS rows in the column. |
| ROS_ROW_COUNT |
INTEGER |
The number of ROS rows in the column. |
| ROS_USED_BYTES |
INTEGER |
The number of ROS bytes in the column. |
| ROS_COUNT |
INTEGER |
The number of ROS containers. |
| PROJECTION_ID |
INTEGER |
Catalog-assigned numeric value that uniquely identifies the projection. |
| PROJECTION_NAME |
VARCHAR |
The associated projection name for the column. |
| PROJECTION_SCHEMA |
VARCHAR |
The name of the schema associated with the projection. |
| ANCHOR_TABLE_ID |
INTEGER |
Catalog-assigned integer value that uniquely identifies the anchor table. |
| ANCHOR_TABLE_NAME |
VARCHAR |
The associated table name. |
| ANCHOR_TABLE_SCHEMA |
VARCHAR |
The associated table's schema name. |
| ANCHOR_TABLE_COLUMN_ID |
VARCHAR |
Catalog-assigned VARCHAR value that uniquely identifies a table column. |
| ANCHOR_TABLE_COLUMN_NAME |
VARCHAR |
The name of the anchor table. |