rebalance_status

The ggrebalance.rebalance_status table records status changes that occur during a cluster rebalancing operation. The table is intended primarily for internal use, but it is also useful for troubleshooting and debugging rebalancing runs.

Aggregated information about the rebalancing process in a readable format is presented in the ggrebalance.rebalance_progress view.

Column Type Description

Column	Type	Description
state	text	The status name. Status name reflects the rebalance phase and involved action, for example, `STATE_SHRINK_TABLES_DONE` or `STATE_REBALANCE_EXECUTION_STARTED`. Many actions are represented by two statuses marking the action’s beginning and end. These names use the `_STARTED` and `_END` suffixes respectively. Statuses that include the `ROLLBACK` word (such as `STATE_SHRINK_ROLLBACK_SHRINKED_TABLES_DONE`) represent actions performed as part of a rollback, for example. Most status changes are performed automatically by `ggrebalance`. An exception is `STATE_REBALANCE_EXECUTION_AWAITING_SWITCHOVER_APPROVE_STARTED`. It indicates that `ggrebalance` is waiting for a switchover confirmation from the user unless the `--approve-swap-roles`/`-y` option is specified
state_category	text	The high-level phase of the rebalancing operation to which the status belongs. Possible values are: `SHRINK` `REBALANCE` `MAIN`
updated	timestamp with time zone	Timestamp of the status change

state

text

The status name.

Status name reflects the rebalance phase and involved action, for example, STATE_SHRINK_TABLES_DONE or STATE_REBALANCE_EXECUTION_STARTED. Many actions are represented by two statuses marking the action’s beginning and end. These names use the _STARTED and _END suffixes respectively.

Statuses that include the ROLLBACK word (such as STATE_SHRINK_ROLLBACK_SHRINKED_TABLES_DONE) represent actions performed as part of a rollback, for example.

Most status changes are performed automatically by ggrebalance. An exception is STATE_REBALANCE_EXECUTION_AWAITING_SWITCHOVER_APPROVE_STARTED. It indicates that ggrebalance is waiting for a switchover confirmation from the user unless the --approve-swap-roles/-y option is specified

state_category

text

The high-level phase of the rebalancing operation to which the status belongs. Possible values are:

SHRINK
REBALANCE
MAIN

updated

timestamp with time zone

Timestamp of the status change

ggrebalance

saved_plan