Home  /  SQL commands

SHOW CLUSTER REPLICAS

View as Markdown

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

Syntax

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 of the replica.
ready Whether all indexes, materialized views, sources, and sinks on the cluster have hydrated.
comment The comment associated with the cluster replica, if any.

Examples

SHOW CLUSTER REPLICAS;

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

SHOW CLUSTER REPLICAS WHERE cluster = 'quickstart';

    cluster    | replica |  size  | ready | comment
---------------+---------|--------|-------|--------
 quickstart    | r1      | 25cc   | t     |
Back to top ↑