EXPLAIN REBALANCE ALL DATABASES
On this page
Returns the set of steps that REBALANCE ALL DATABASES
would run if you executed it now.
Syntax
EXPLAIN REBALANCE ALL DATABASES;
Example
EXPLAIN REBALANCE ALL DATABASES;
+----------+-----------------------------+---------+-------------+-------------+-------+-----------------------------+
| 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_
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_COPY PARTITION
on partitions test:1
and test:3
in parallel.Estimated_
is the estimated total time (in milliseconds) that each low-level command will take to complete.
Last modified: July 31, 2023