ContextQMD
Back to Materialize

SHOW CLUSTER REPLICAS

doc/user/content/sql/show-cluster-replicas.md

1231.0 KB
Original Source

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

Syntax

sql
SHOW CLUSTER REPLICAS
[LIKE <pattern> | WHERE <condition(s)>]
;
Syntax elementDescription
LIKE <pattern>If specified, only show clusters that match the pattern.
WHERE <condition(s)>If specified, only show clusters that match the condition(s).

Examples

mzsql
SHOW CLUSTER REPLICAS;
nofmt
    cluster    | replica |  size  | ready |
---------------+---------|--------|-------|
 auction_house | bigger  | 1600cc | t     |
 quickstart    | r1      | 25cc   | t     |
mzsql
SHOW CLUSTER REPLICAS WHERE cluster = 'quickstart';
nofmt
    cluster    | replica |  size  | ready|
---------------+---------|--------|-------
 quickstart    | r1      | 25cc   | t    |