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