# EXPLAIN RESTORE REDUNDANCY

The `EXPLAIN RESTORE REDUNDANCY` command returns the set of steps `RESTORE REDUNDANCY` would run.

## Syntax

```

EXPLAIN RESTORE REDUNDANCY ON db_name

```

## Remarks

* `db_name`: name of the SingleStore database.
* 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.

```sql

EXPLAIN RESTORE REDUNDANCY ON trades;

```

```output

+----------------------+---------+-------------+-------------+-------+
| 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)

```

***

Modified at: June 12, 2026

Source: [/db/v9.1/reference/sql-reference/cluster-management-commands/explain-restore-redundancy/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/explain-restore-redundancy/)

(An index of the documentation is available at /llms.txt)