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 |
---|---|---|
NODE_NAME
|
VARCHAR |
The node name for which information is listed. |
SCHEMA_NAME
|
VARCHAR |
The schema name for which information is listed. |
PROJECTION_NAME
|
VARCHAR |
The projection name for which information is listed on that node. |
PROJECTION_ID
|
INTEGER |
A unique numeric ID assigned by the Vertica catalog, which identifies the projection. |
PARTITION_KEY
|
VARCHAR |
Deprecated in favor of |
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 |
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. |
STRATUM_CAPACITY
|
INTEGER |
The maximum number of ROS containers that the strata can contained before it must merge them. |
STRATUM_HEIGHT
|
FLOAT |
The size ratio between the smallest and largest ROS container in a stratum. |
ACTIVE_STRATA_COUNT
|
INTEGER |
The total number of strata that have ROS containers in them. |
Example
=> \pset expanded Expanded display is on. => 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