MV_REBALANCE_STATUS

This view contains information about the status of REBALANCE commands such as REBALANCE ALL DATABASES and REBALANCE PARTITIONS.

Column Name	Description
`DATABASE_NAME`	The name of the database the `REBALANCE` command is running on or within.
`ACTION`	The action being performed: either `COPY PARTITION` or `PROMOTE PARTITION`.
`ORDINAL`	The `ID` of the related partition.
`TARGET_HOST`	The target hostname or IP address of a `REBALANCE` command.
`TARGET_PORT`	The target port number of a `REBALANCE` command.
`PHASE`	The phase (group of actions occurring at the same time) that a given action is part of.
`STATUS`	The status of the `REBALANCE`. A `REBALANCE` consists of multiple commands that are run in phases. Can be one of: cancelled - the command was cancelled (can happen if a rebalance is terminated) failed - the command failed to complete running - the command is currently in process scheduled - the command is scheduled to run success - the command ran successfully Querying rebalance status during an ongoing rebalance will show some combination of success, running, and scheduled rows where the phases that completed already will show 'success', the phase that is currently ongoing will show that they are 'running', and the phases that must come next will show that they are 'scheduled'.
`RUNNING_TIME_MS`	The amount of time in milliseconds spent on a given action.

Was this article helpful?