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 |
+----------+-----------------------------+---------+-------------+-------------+-------+
| x_db     | COPY PARTITION              | 13      | 127.0.0.1   | 10002       | 3     |
| x_db     | COPY PARTITION              | 2       | 127.0.0.1   | 10003       | 4     | 
| x_db     | COPY PARTITION              | 2       | 127.0.0.1   | 10004       | 4     | 
| x_db     | PROMOTE PARTITION WITH DROP | 2       | 127.0.0.1   | 10003       | 5     |
| x_db     | DROP PARTITION              | 2       | 127.0.0.1   | 10002       | 6     |
| x_db     | DROP PARTITION              | 13      | 127.0.0.1   | 10004       | 6     |
+----------+-----------------------------+---------+-------------+-------------+-------+

Last modified: July 31, 2023

Was this article helpful?