EXPLAIN REBALANCE PARTITIONS
Returns the set of steps that REBALANCE PARTITIONS would run if you executed it now.
Syntax
EXPLAIN REBALANCE PARTITIONS ON db_name
Remarks
db_name
- name of a SingleStore DB database.
Example
EXPLAIN REBALANCE PARTITIONS ON memsql_demo; +-----------------------------+---------+-------------+-------------+-------+-----------------------------+ | Action | Ordinal | Target_Host | Target_Port | Phase | Estimated_Time_Remaining_Ms | +-----------------------------+---------+-------------+-------------+-------+-----------------------------+ | COPY PARTITION | 13 | 127.0.0.1 | 10002 | 3 | 7821 | | COPY PARTITION | 2 | 127.0.0.1 | 10003 | 4 | 7821 | | COPY PARTITION | 2 | 127.0.0.1 | 10004 | 4 | 7821 | | PROMOTE PARTITION WITH DROP | 2 | 127.0.0.1 | 10003 | 5 | 1351 | | DROP PARTITION | 2 | 127.0.0.1 | 10002 | 6 | 1002 | | 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.