# Identifying Orphaned Partitions

To easily determine if your cluster has any orphaned partitions, run:

```sql
EXPLAIN REBALANCE PARTITIONS ON <database name>;

```

If there are any unbalanced partitions, a non-empty result set will be returned. If this is the case, run `SHOW CLUSTER STATUS` and [SHOW PARTITIONS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-partitions.md) to see the details of your partitions:

Example:

```sql
SHOW CLUSTER STATUS;

```

```output

| Host      | Port  | Database | Role      | State       | Position | Details |
+-----------+-------+----------+-----------+-------------+----------+---------+
| 127.0.0.1 | 10001 | x_test   | Reference | replicating | 0:57     |         |
| 127.0.0.1 | 10001 | x_test_0 | Master    | online      | 0:10     |         |
| 127.0.0.1 | 10001 | x_test_1 | Replica   | replicating | 0:10     |         |
| 127.0.0.1 | 10002 | x_test   | Reference | replicating | 0:57     |         |
| 127.0.0.1 | 10002 | x_test_0 | Replica   | replicating | 0:10     |         |
| 127.0.0.1 | 10002 | x_test_1 | Orphan    | online      | 0:10     |         |

```

```sql
SHOW PARTITIONS;

```

```output

+---------+-----------+-------+---------+--------+
| Ordinal | Host      | Port  | Role    | Locked |
+---------+-----------+-------+---------+--------+
| 0       | 127.0.0.1 | 10001 | Master  | 0      |
| 0       | 127.0.0.1 | 10002 | Replica | 0      |
| 1       | 127.0.0.1 | 10001 | Replica | 0      |
+---------+-----------+-------+---------+--------+

```

***

Modified at: April 27, 2023

Source: [/db/v9.1/reference/troubleshooting-reference/understanding-orphaned-partitions/identifying-orphaned-partitions/](https://docs.singlestore.com/db/v9.1/reference/troubleshooting-reference/understanding-orphaned-partitions/identifying-orphaned-partitions/)

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