PARTITIONS
Displays partition metadata, one row per partition key, per ROS container.
Column Name | Data Type | Description |
---|---|---|
PARTITION_KEY
|
VARCHAR |
The partition value(s). |
PROJECTION_ID
|
INTEGER |
Unique numeric ID assigned by the Vertica catalog, which identifies the projection. |
TABLE_SCHEMA
|
VARCHAR |
The schema name for which information is listed. |
PROJECTION_NAME
|
VARCHAR |
The projection name for which information is listed. |
ROS_ID
|
VARCHAR |
A unique numeric ID assigned by the Vertica catalog, which identifies the ROS container. |
ROS_SIZE_BYTES
|
INTEGER |
The ROS container size in bytes. |
ROS_ROW_COUNT
|
INTEGER |
Number of rows in the ROS container. |
NODE_NAME
|
VARCHAR |
Node where the ROS container resides. |
DELETED_ROW_COUNT
|
INTEGER |
The number of deleted rows in the partition. |
LOCATION_LABEL
|
VARCHAR |
The location label of the default storage location. |
Notes
- A many-to-many relationship exists between partitions and ROS containers. PARTITIONS displays information in a denormalized fashion.
- To find the number of ROS containers having data of a specific partition, aggregate PARTITIONS over the
partition_key
column. - To find the number of partitions stored in a ROS container, aggregate PARTITIONS over the
ros_id
column.
Example
See Viewing Partition Storage Data in the Administrator's Guide.