REBALANCE_OPERATIONS

Contains information on historic and ongoing rebalance operations.

Contains information on historic and ongoing rebalance operations.

Column Name Data Type Description
OBJECT_TYPE VARCHAR

The type of the rebalanced object:

  • Projection

  • DFSfile

OBJECT_ID INTEGER The ID of the rebalanced object.
OBJECT_NAME VARCHAR The name of the rebalanced object. Objects can be tables, projections, or other Vertica objects.
PATH_NAME VARCHAR The DFS path for unstructured data being rebalanced.
TABLE_NAME VARCHAR The name of the rebalanced table. This value is NULL for DFS files.
TABLE_SCHEMA VARCHAR The schema of the rebalanced table. This value is NULL for DFS files.
TRANSACTION_ID INTEGER The identifier for the transaction within the session.
STATEMENT_ID INTEGER The unique numeric ID for the currently-running statement.
NODE_NAME VARCHAR Name of the rebalancing node.
OPERATION_NAME VARCHAR

Identifies the specific rebalance operation being performed, one of:

  • Refresh projection, update temporary projection name and ID to master projection name

  • Drop unsegmented replicas

  • Replicate DFS File

  • Refresh projection

  • Drop replaced or replacement projection, rename temporary projection name to original projection name

  • Update temp table segments

  • Prepare : separate

  • Move storage containers

OPERATION_STATUS VARCHAR

Specifies status of the rebalance operation, one of the followin:

  • START

  • COMPLETE

  • ABORT

IS_EXECUTING BOOLEAN TRUE: the operation is currently running.
REBALANCE_METHOD VARCHAR

The method that Vertica is using to perform the rebalance, one of the following:

  • REFRESH: New projections are created according to the new segmentation definition. Data is copied via a refresh plan from projections with the previous segmentation to the new segments. This method is used only if START_REFRESH is called, a configuration parameter is set, or K-safety changes.

  • REPLICATE: Unsegmented projection data is copied to new nodes and removed from ephemeral nodes.

  • ELASTIC_CLUSTER: The segmentation of existing segmented projections is altered to adjust to a new cluster topology and data is redistributed accordingly.

SESSION_ID VARCHAR Identifier for this session. This identifier is unique within the cluster at any point in time but can be reused when the session closes.
OPERATION_START_TIMESTAMP TIMESTAMPTZ The time that the rebalance began.
OPERATION_END_TIMESTAMP TIMESTAMPTZ The time that the rebalance ended. If the rebalance is ongoing, this value is NULL.
ELASTIC_CLUSTER_VERSION INTEGER The Elastic Cluster has a version. Each time the cluster topology changes, this version increments.
IS_LATEST BOOLEAN True if this row pertains to the most recent rebalance activity.

Privileges

Superuser