STORAGE_CONTAINERS
Monitors information about WOS and ROS storage containers in the database.
Column Name | Data Type | Description |
---|---|---|
NODE_NAME*
|
VARCHAR |
Node name for which information is listed. |
SCHEMA_NAME* |
VARCHAR |
Schema name for which information is listed. |
PROJECTION_ID* |
INTEGER |
Unique numeric ID assigned by the Vertica catalog, which identifies the projection. |
PROJECTION_NAME* |
VARCHAR |
Projection name for which information is listed on that node. |
STORAGE_TYPE* |
VARCHAR |
Type of storage container: ROS or WOS. |
STORAGE_OID* |
INTEGER |
Numeric ID assigned by the Vertica catalog, which identifies the storage. |
SAL_STORAGE_ID | VARCHAR |
Unique hexadecimal numeric ID assigned by the Vertica catalog, which identifies the storage. |
TOTAL_ROW_COUNT* |
VARCHAR |
Total rows in the storage container listed for that projection. |
DELETED_ROW_COUNT* |
INTEGER |
Total rows in the storage container deleted for that projection. |
USED_BYTES* |
INTEGER |
Total bytes in the storage container listed for that projection. |
START_EPOCH* |
INTEGER |
Number of the start epoch in the storage container for which information is listed. |
END_EPOCH* |
INTEGER |
Number of the end epoch in the storage container for which information is listed. |
GROUPING |
VARCHAR |
The group by which columns are stored:
|
SEGMENT_LOWER_BOUND |
INTEGER |
Lower bound of the segment range spanned by the storage container or |
SEGMENT_UPPER_BOUND |
INTEGER |
Upper bound of the segment range spanned by the storage container or |
IS_SORTED |
BOOLEAN |
Whether the storage container's data is sorted (WOS containers only). |
LOCATION_LABEL |
VARCHAR (128) |
The location label (if any) for the storage container is stored. |
DELETE_VECTOR_COUNT |
INTEGER |
The number of delete vectors in the storage container. |
SHARD_ID | INTEGER | Set only for an Eon Mode database, ID of the shard that this container belongs to. |
SHARD_NAME | VARCHAR(128) | Set only for an Eon Mode database, name of the shard that this container belongs to. |
Privileges
Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.