EXPLAIN RESTORE REDUNDANCY
On this page
Returns the set of steps RESTORE REDUNDANCY would run if executed.
Syntax
EXPLAIN RESTORE REDUNDANCY ON db_nameRemarks
-
db_: name of the SingleStore Helios database.name -
This command must be run on the master aggregator node.
Examples
The following query returns a set of steps that RESTORE REDUNDANCY will run if executed at the same time on trades database.
EXPLAIN RESTORE REDUNDANCY ON trades;
+----------------------+---------+-------------+-------------+-------+
| Action | Ordinal | Target_Host | Target_Port | Phase |
+----------------------+---------+-------------+-------------+-------+
| COPY PARTITION FORCE | 0 | 127.0.0.1 | 3309 | 2 |
| COPY PARTITION FORCE | 1 | 127.0.0.1 | 3309 | 2 |
| COPY PARTITION FORCE | 2 | 127.0.0.1 | 3309 | 2 |
| COPY PARTITION FORCE | 3 | 127.0.0.1 | 3309 | 2 |
| COPY PARTITION FORCE | 4 | 127.0.0.1 | 3309 | 2 |
| COPY PARTITION FORCE | 5 | 127.0.0.1 | 3309 | 2 |
| COPY PARTITION FORCE | 6 | 127.0.0.1 | 3309 | 2 |
| COPY PARTITION FORCE | 7 | 127.0.0.1 | 3309 | 2 |
+----------------------+---------+-------------+-------------+-------+
8 rows in set (0.01 sec)Last modified: November 16, 2022