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. |
Privileges
No explicit privileges are required. You only see the records for tables that you have privileges to view.