# SHOW CLUSTER REPLICAS
`SHOW CLUSTER REPLICAS` lists the replicas for each cluster configured in Materialize.

> For the complete documentation index, see [llms.txt](https://preview.materialize.com/materialize/40269/llms.txt).


`SHOW CLUSTER REPLICAS` lists the [replicas](https://preview.materialize.com/materialize/40269/markdown-docs/sql/create-cluster/index.md#replication-factor) for each
cluster configured in Materialize.

## Syntax

```sql
SHOW CLUSTER REPLICAS
[LIKE <pattern> | WHERE <condition(s)>]
;
```

Syntax element                | Description
------------------------------|------------
**LIKE** \<pattern\>          | If specified, only show clusters that match the pattern.
**WHERE** <condition(s)>      | If specified, only show clusters that match the condition(s).

## Output

Column       | Description
-------------|------------
**cluster**  | The name of the cluster.
**replica**  | The name of the replica.
**size**     | The [size](https://preview.materialize.com/materialize/40269/markdown-docs/sql/create-cluster/index.md#available-sizes) of the replica.
**ready**    | Whether all indexes, materialized views, sources, and sinks on the cluster have hydrated.
**comment**  | The [comment](https://preview.materialize.com/materialize/40269/markdown-docs/sql/comment-on/index.md) associated with the cluster replica, if any.

## Examples

```mzsql
SHOW CLUSTER REPLICAS;
```

```nofmt
    cluster    | replica |  size  | ready | comment
---------------+---------|--------|-------|--------
 auction_house | bigger  | 1600cc | t     |
 quickstart    | r1      | 25cc   | t     |
```

```mzsql
SHOW CLUSTER REPLICAS WHERE cluster = 'quickstart';
```

```nofmt
    cluster    | replica |  size  | ready | comment
---------------+---------|--------|-------|--------
 quickstart    | r1      | 25cc   | t     |
```


## Related pages

- [`CREATE CLUSTER REPLICA`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/create-cluster-replica/index.md)
- [`DROP CLUSTER REPLICA`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-cluster-replica/index.md)