SHOW CLUSTER REPLICAS

NOTE! For improved performance, execute this command in the mz_introspection cluster. To switch clusters, use SET CLUSTER = mz_introspection;.

SHOW CLUSTER REPLICAS lists the replicas for each cluster configured in Materialize. A cluster named default with a single replica named r1 will exist in every environment; this cluster can be dropped at any time.

Syntax

SHOW CLUSTER REPLICAS LIKE pattern WHERE expr

Examples

SHOW CLUSTER REPLICAS;
    cluster    | replica |  size  | ready |
---------------+---------|--------|-------|
 auction_house | bigger  | xlarge | t     |
 default       | r1      | xsmall | t     |
SHOW CLUSTER REPLICAS WHERE cluster='default';
    cluster    | replica |  size  | ready|
---------------+---------|--------|-------
 default       | r1      | xsmall | t    |
Back to top ↑