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