Vertica Analytics Platform Version 9.2.x Documentation

STRATA

Contains internal details of how the Tuple Mover combines ROS containers in each projection, broken down by stratum and classifies the ROS containers by size and partition. The related STRATA_STRUCTURES table provides a summary of the strata values.

Mergeout in the Administrator's Guide describes how the Tuple Mover combines ROS containers.

Column Name Data Type Description
NODE_NAME

VARCHAR

The node name for which information is listed.

SCHEMA_NAME

VARCHAR

The schema name for which information is listed.

PROJECTION_ID

INTEGER

A unique numeric ID assigned by the Vertica catalog, which identifies the projection.

PROJECTION_NAME

VARCHAR

The projection name for which information is listed on that node.

PARTITION_KEY

VARCHAR

Deprecated in favor of STRATUM_KEY, references the partition or partition group for which information is listed.

STRATUM_KEY VARCHAR References the partition or partition group for which information is listed.
STRATA_COUNT

INTEGER

The total number of strata for this projection partition.

MERGING_STRATA_COUNT

INTEGER

The number of strata the Tuple Mover can merge out.

STRATUM_CAPACITY

INTEGER

The maximum number of ROS containers for the stratum before they must be merged.

STRATUM_HEIGHT

FLOAT

The size ratio between the smallest and largest ROS container in this stratum.

STRATUM_NO

INTEGER

The stratum number. Strata are numbered starting at 0, for the stratum containing the smallest ROS containers.

STRATUM_LOWER_SIZE

VARCHAR

The smallest ROS container size allowed in this stratum.

STRATUM_UPPER_SIZE

VARCHAR

The largest ROS container size allowed in this stratum.

ROS_CONTAINER_COUNT

INTEGER

The current number of ROS containers in the projection partition.