COLUMN_STORAGE
Returns the amount of disk storage used by each column of each projection on each node. WOS data is stored by row, so per-column byte counts are not available.
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 |
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 |
A unique numeric ID assigned by the Vertica catalog, which 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 |
A unique VARCHAR ID, assigned by the Vertica catalog, that identifies a column in a table. |
ANCHOR_TABLE_COLUMN_NAME |
VARCHAR |
The name of the anchor table. |