REBALANCE_TABLE_STATUS

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
TIMESTAMPZ The time that the rebalance began.

end_timestamp

TIMESTAMPZ The time that the rebalance ended.

Privileges

Superuser

See Also