REBALANCE_TABLE_STATUS

Maintain history on rebalance progress for relevant tables.

Maintain history on rebalance progress for relevant tables.

Column Name Data Type Description
TABLE_ID INTEGER Identifier of the table that will be, was, or is being rebalanced.
TABLE_SCHEMA VARCHAR Schema of the table that will be, was, or is being rebalanced.
TABLE_NAME VARCHAR Name of the table that will be, was, or is being rebalanced.
REBALANCE_METHOD VARCHAR

Method that will be, is, or was used to rebalance the projections of this table. Possible values are:

  • REFRESH

  • REPLICATE

  • ELASTIC_CLUSTER

DURATION_SEC INTERVAL SEC

Deprecated - populated by NULL.

Aggregate, by table_id, rebalance_method, and elastic_cluster_version, of the same in REBALANCE_PROJECTION_STATUS.

SEPARATED_PERCENT NUMERIC(5,2) Aggregate, by table_id, rebalance_method, and elastic_cluster_version, of the same in REBALANCE_PROJECTION_STATUS.
TRANSFERRED_PERCENT NUMERIC(5,2) Aggregate, by table_id, rebalance_method, and elastic_cluster_version, of the same in REBALANCE_PROJECTION_STATUS.
SEPARATED_BYTES INTEGER Aggregate, by table_id, rebalance_method, and elastic_cluster_version, of the same in REBALANCE_PROJECTION_STATUS.
TO_SEPARATE_BYTES INTEGER Aggregate, by table_id, rebalance_method, and elastic_cluster_version, of the same in REBALANCE_PROJECTION_STATUS.
TRANSFERRED_BYTES INTEGER Aggregate, by table_id, rebalance_method, and elastic_cluster_version, of the same in REBALANCE_PROJECTION_STATUS.
TO_TRANSFER_BYTES INTEGER Aggregate, by table_id, rebalance_method, and elastic_cluster_version, of the same in REBALANCE_PROJECTION_STATUS.
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;)

start_timestamp TIMESTAMPTZ The time that the rebalance began.
end_timestamp TIMESTAMPTZ The time that the rebalance ended.

Privileges

Superuser

See also