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 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
Given the unsegmented projection states_p
replicated across three nodes, the following query on the PARTITIONS
table returns twelve rows, representing twelve ROS containers:
=> SELECT PARTITION_KEY, ROS_ID, ROS_SIZE_BYTES, ROS_ROW_COUNT, NODE_NAME FROM partitions WHERE PROJECTION_NAME='states_p' order by ROS_ID; PARTITION_KEY | ROS_ID | ROS_SIZE_BYTES | ROS_ROW_COUNT | NODE_NAME ---------------+-------------------+----------------+---------------+------------------ VT | 45035996281231297 | 95 | 14 | v_vmart_node0001 PA | 45035996281231309 | 92 | 11 | v_vmart_node0001 NY | 45035996281231321 | 90 | 9 | v_vmart_node0001 MA | 45035996281231333 | 96 | 15 | v_vmart_node0001 VT | 49539595902704977 | 95 | 14 | v_vmart_node0002 PA | 49539595902704989 | 92 | 11 | v_vmart_node0002 NY | 49539595902705001 | 90 | 9 | v_vmart_node0002 MA | 49539595902705013 | 96 | 15 | v_vmart_node0002 VT | 54043195530075651 | 95 | 14 | v_vmart_node0003 PA | 54043195530075663 | 92 | 11 | v_vmart_node0003 NY | 54043195530075675 | 90 | 9 | v_vmart_node0003 MA | 54043195530075687 | 96 | 15 | v_vmart_node0003 (12 rows)