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_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.

Last modified: July 31, 2023

Was this article helpful?