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

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)