COLUMN_STORAGE
Returns the amount of disk storage used by each column of each projection on each node.
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 thecolumn. |
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 ENCODINGS and COMPRESSION columns to see how different encoding types affect column storage when optimizing for compression. |
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 theanchor table. |
ANCHOR_TABLE_NAME | VARCHAR | The associated table name. |
ANCHOR_TABLE_SCHEMA | VARCHAR |
The associated table's schema name. If the schema belongs to a non-default namespace in an Eon Mode database, the schema name is front-qualified with the name of the schema's namespace. For example, |
ANCHOR_TABLE_NAMESPACE | VARCHAR | For Eon Mode databases, name of the namespace that contains the table. |
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. |