REBALANCE_PROJECTION_STATUS

Maintain history on rebalance progress for relevant projections.

Column Name Data Type Description
PROJECTION_ID

INTEGER

Identifier of the projection that will be, was, or is being rebalanced.

PROJECTION_SCHEMA

VARCHAR

Schema of the projection that will be, was, or is being rebalanced.

PROJECTION_NAME

VARCHAR

Name of the projection that will be, was, or is being rebalanced.

ANCHOR_TABLE_ID

INTEGER

Anchor table identifier of the projection that will be, was, or is being rebalanced.

ANCHOR_TABLE_NAME

VARCHAR

Anchor table name of the projection that will be, was, or is being rebalanced.

REBALANCE_METHOD

VARCHAR

Method that was, is, or will be used to rebalance the projection. Possible values 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.
DURATION_SEC

INTERVAL SEC

Deprecated - populated by NULL.

Length of time (seconds) rebalance has been working on this projection, including time to separate storage, if that work is required.

SEPARATED_PERCENT

NUMERIC(5,2)

Percent of storage that has been separated for this projection.

TRANSFERRED_PERCENT

NUMERIC(5,2)

Percent of storage that has been transferred, for this projection.

SEPARATED_BYTES

INTEGER

Number of bytes, separated by the corresponding rebalance operation, for this projection.

TO_SEPARATE_BYTES

INTEGER

Number of bytes that remain to be separated by the corresponding rebalance operation for this projection.

TRANSFERRED_BYTES

INTEGER

Number of bytes transferred by the corresponding rebalance operation for this projection.

TO_TRANSFER_BYTES

INTEGER

Number of bytes that remain to be transferred by the corresponding rebalance operation for this projection.

IS_LATEST

BOOLEAN

True if this row pertains to the most recent rebalance activity, where elastic_cluster_version = (SELECT version FROM v_catalog.elastic_cluster);

ELASTIC_CLUSTER_VERSION

INTEGER

The Elastic Cluster has a version, and each time the cluster topology changes, this version is incremented. This column reflects the version to which this row of information pertains. The TO_* fields (TO_SEPARATE_* and TO_TRANSFER_*) are only valid for the current version.

To view only rows from the current, latest or upcoming rebalance operation, use:

WHERE elastic_cluster_version = (SELECT version FROM v_catalog.elastic_cluster);

Privileges

Superuser