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 |