STRATA_STRUCTURES

This table provides an overview of Tuple Mover internal details. It summarizes how the ROS containers are classified by size. A more detailed view can be found in the STRATA virtual table.

Column Name Data Type Description
ACTIVE_STRATA_COUNT 

INTEGER

The total number of strata that have ROS containers in them
MERGING_STRATA_COUNT

INTEGER

In certain hardware configurations, a high strata could contain more ROS containers than the Tuple Mover can merge out; output from this column denotes the number of strata the Tuple Mover can merge out.
NODE_NAME

VARCHAR

The node name for which information is listed

PARTITION_KEY

VARCHAR

The data partition for which the 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

SCHEMA_NAME

VARCHAR

The schema name for which information is listed
STRATUM_CAPACITY

INTEGER

The maximum number of ROS containers that the strata can contained before it must merge them
STRATA_COUNT

INTEGER

The total number of strata for this projection partition

STRATUM_HEIGHT

FLOAT

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

Example

onenode=> SELECT * FROM strata_structures;
-[ RECORD 1 ]--------+-------------------
node_name            | v_onenode_node0001
schema_name          | public
projection_name      | trades_p
projection_id        | 45035996273718838
partition_key        |
strata_count         | 11
merging_strata_count | 4
stratum_capacity     | 32
stratum_height       | 28.8
active_strata_count  | 1
vmartdb=> \pset expanded
Expanded display is on.
vmartdb=> SELECT node_name, schema_name, projection_name, strata_count, 
            stratum_capacity, stratum_height, active_strata_count 
            FROM strata_structures WHERE stratum_capacity > 60;
-[ RECORD 1 ]-------+--------------------------------------------------------
node_name           | v_vmartdb_node0001
schema_name         | public
projection_name     | shipping_dimension_DBD_22_seg_vmart_design_vmart_design
partition_key       |
strata_count        | 4
stratum_capacity    | 62
stratum_height      | 25.6511590887058
active_strata_count | 1
-[ RECORD 2 ]-------+--------------------------------------------------------
node_name           | v_vmartdb_node0001
schema_name         | public
projection_name     | shipping_dimension_DBD_23_seg_vmart_design_vmart_design
partition_key       |
strata_count        | 4
stratum_capacity    | 62
stratum_height      | 25.6511590887058
active_strata_count | 1
-[ RECORD 3 ]-------+--------------------------------------------------------
node_name           | v_vmartdb_node0002
schema_name         | public
projection_name     | shipping_dimension_DBD_22_seg_vmart_design_vmart_design
partition_key       |
strata_count        | 4
stratum_capacity    | 62
stratum_height      | 25.6511590887058
active_strata_count | 1
-[ RECORD 4 ]-------+--------------------------------------------------------
node_name           | v_vmartdb_node0002
schema_name         | public
projection_name     | shipping_dimension_DBD_23_seg_vmart_design_vmart_design
partition_key       |
strata_count        | 4
stratum_capacity    | 62
stratum_height      | 25.6511590887058
active_strata_count | 1
-[ RECORD 5 ]-------+--------------------------------------------------------
node_name           | v_vmartdb_node0003
schema_name         | public
projection_name     | shipping_dimension_DBD_22_seg_vmart_design_vmart_design
partition_key       |
strata_count        | 4
stratum_capacity    | 62
stratum_height      | 25.6511590887058
active_strata_count | 1
-[ RECORD 6 ]-------+--------------------------------------------------------
node_name           | v_vmartdb_node0003
schema_name         | public
projection_name     | shipping_dimension_DBD_23_seg_vmart_design_vmart_design
partition_key       |
strata_count        | 4
stratum_capacity    | 62
stratum_height      | 25.6511590887058
active_strata_count | 1
-[ RECORD 7 ]-------+--------------------------------------------------------
node_name           | v_vmartdb_node0004
schema_name         | public
projection_name     | shipping_dimension_DBD_22_seg_vmart_design_vmart_design
partition_key       |
strata_count        | 4
stratum_capacity    | 62
stratum_height      | 25.6511590887058
active_strata_count | 1
-[ RECORD 8 ]-------+--------------------------------------------------------
node_name           | v_vmartdb_node0004
schema_name         | public
projection_name     | shipping_dimension_DBD_23_seg_vmart_design_vmart_design
partition_key       |
strata_count        | 4
stratum_capacity    | 62
stratum_height      | 25.6511590887058
active_strata_count | 1

See Also