# EXPLAIN REBALANCE ALL DATABASES

The `EXPLAIN REBALANCE ALL DATABASES` command returns the set of steps that `REBALANCE ALL DATABASES` would run if you run it at that time.

## Syntax

```sql
EXPLAIN REBALANCE ALL DATABASES;

```

## Example

```sql
EXPLAIN REBALANCE ALL DATABASES;

```

```output

+----------+-----------------------------+---------+-------------+-------------+-------+-----------------------------+
| Database | Action                      | Ordinal | Target_Host | Target_Port | Phase | Estimated_Time_Remaining_Ms |
+----------+-----------------------------+---------+-------------+-------------+-------+-----------------------------+
| x_db     | COPY PARTITION              | 13      | 127.0.0.1   | 10002       | 3     | 7821                        |
| x_db     | COPY PARTITION              | 2       | 127.0.0.1   | 10003       | 4     | 7821                        |
| x_db     | COPY PARTITION              | 2       | 127.0.0.1   | 10004       | 4     | 7821                        |
| x_db     | PROMOTE PARTITION WITH DROP | 2       | 127.0.0.1   | 10003       | 5     | 1351                        |
| x_db     | DROP PARTITION              | 2       | 127.0.0.1   | 10002       | 6     | 1002                        |
| x_db     | DROP PARTITION              | 13      | 127.0.0.1   | 10004       | 6     | 1002                        |
+----------+-----------------------------+---------+-------------+-------------+-------+-----------------------------+
```

**Note**: The `Estimated_Time_Remaining_Ms` is the estimated total time (in milliseconds) that each low-level command will take to complete.

The *Ordinal* is the target partition’s ordinal, and the *Target\_Host* and *Target\_Port* correspond to the destination leaf. Any two operations in the same *Phase* can be run in parallel and phases are run in order. For example, the aggregator can run `COPY PARTITION` on partitions `test:1` and `test:3` in parallel. The exact meaning of what each phase means is arbitrary and depends on the particular rebalance operation. The `Estimated_Time_Remaining_Ms` is the estimated total time (in milliseconds) that each low-level command will take to complete.

***

Modified at: June 12, 2026

Source: [/db/v9.1/reference/sql-reference/cluster-management-commands/explain-rebalance-all-databases/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/explain-rebalance-all-databases/)

(An index of the documentation is available at /llms.txt)