REBALANCE_OPERATIONS

Contains information on historic and ongoing rebalance operations.

Column Name Data Type Description
OBJECT_TYPE
VARCHAR

The type of the object being rebalanced. Valid types are:

  • Projection
  • DFSfile
OBJECT_ID
INT The ID of the object being rebalanced.
OBJECT_NAME
VARCHAR The name of the object being rebalanced. 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 table being rebalanced. This value is NULL for DFS files.
TABLE_SCHEMA
VARCHAR The schema of the table being rebalanced. This value is NULL for DFS files.
TRANSACTION_ID
INT The identifier for the transaction within the session.
STATEMENT_ID
INT The unique numeric ID for the currently-running statement.
NODE_NAME
VARCHAR Name of the node that is rebalancing.
OPERATION_NAME
VARCHAR

Identifies the specific rebalance operation being performed, set to one of the following:

  • Refresh projection, update temporary projection name 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 : moveout
  • Prepare : separate
  • Move storage containers
OPERATION_STATUS
VARCHAR

Returns Running or an empty string to indicate 'not running.' One of the following values:

  • START
  • COMPLETE
  • ABORT
IS_EXECUTING
BOOLEAN When TRUE, the operation is currently running.
REBALANCE_METHOD
VARCHAR

The method that Vertica is using to perform the rebalance. Valid methods are:

  • 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 only used if specifically requested (using START_REFRESH), by setting a configuration parameter, or if Elastic Cluster is disabled or if there is a change in desired k-safety.
  • 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
TIMESTAMPZ The time that the rebalance began.
OPERATION_END_TIMESTAMP
TIMESTAMPZ The time that the rebalance ended. If the rebalance is ongoing, this value is NULL.
ELASTIC_CLUSTER_VERSION
INT

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