REBALANCE_PROJECTION_STATUS

Maintain history on rebalance progress for relevant projections.

Maintain history on rebalance progress for relevant projections.

Column Name Data Type Description
PROJECTION_ID INTEGER Identifier of the projection to rebalance.
PROJECTION_SCHEMA VARCHAR Schema of the projection to rebalance.
PROJECTION_NAME VARCHAR Name of the projection to rebalance.
ANCHOR_TABLE_ID INTEGER Anchor table identifier of the projection to rebalance.
ANCHOR_TABLE_NAME VARCHAR Anchor table name of the projection to rebalance.
REBALANCE_METHOD VARCHAR

Method used to rebalance the projection, 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 in the following cases:

    • START_REFRESH is called

    • A configuration parameter is set.

    • 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.

DURATION_SEC INTERVAL SEC Deprecated, set to NULL.
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

See also