SQL reference
- Overview
- Commands
- Overview
- ALTER CONNECTION
- ALTER DATABASE
- ALTER FUNCTION
- ALTER INDEX
- ALTER MATERIALIZED VIEW
- ALTER SCHEMA
- ALTER SINK
- ALTER SOURCE
- ALTER SYSTEM
- ALTER TABLE
- ALTER USER
- ALTER VIEW
- AS CHANGELOG
- BEGIN
- CANCEL JOBS
- COMMENT ON
- COMMIT
- CREATE AGGREGATE
- CREATE CONNECTION
- CREATE DATABASE
- CREATE FUNCTION
- CREATE INDEX
- CREATE MATERIALIZED VIEW
- CREATE SCHEMA
- CREATE SECRET
- CREATE SINK INTO
- CREATE SINK
- CREATE SOURCE
- CREATE TABLE
- CREATE USER
- CREATE VIEW
- DELETE
- DESCRIBE
- DISCARD
- DROP AGGREGATE
- DROP CONNECTION
- DROP DATABASE
- DROP FUNCTION
- DROP INDEX
- DROP MATERIALIZED VIEW
- DROP SCHEMA
- DROP SECRET
- DROP SINK
- DROP SOURCE
- DROP TABLE
- DROP USER
- DROP VIEW
- EXPLAIN
- FLUSH
- GRANT
- INSERT
- RECOVER
- REVOKE
- SELECT
- SET BACKGROUND_DDL
- SET RW_IMPLICIT_FLUSH
- SET TIME ZONE
- SET
- SHOW CLUSTER
- SHOW COLUMNS
- SHOW CONNECTIONS
- SHOW CREATE INDEX
- SHOW CREATE MATERIALIZED VIEW
- SHOW CREATE SINK
- SHOW CREATE SOURCE
- SHOW CREATE TABLE
- SHOW CREATE VIEW
- SHOW CURSORS
- SHOW DATABASES
- SHOW FUNCTIONS
- SHOW INDEXES
- SHOW INTERNAL TABLES
- SHOW JOBS
- SHOW MATERIALIZED VIEWS
- SHOW PARAMETERS
- SHOW PROCESSLIST
- SHOW SCHEMAS
- SHOW SINKS
- SHOW SOURCES
- SHOW SUBSCRIPTION CURSORS
- SHOW TABLES
- SHOW VIEWS
- START TRANSACTION
- UPDATE
- Query syntax
- Data types
- Functions and operators
- Identifiers
- System catalogs
- Psql commands
Commands
SHOW CLUSTER
Use the SHOW CLUSTER
command to display various details of your cluster, such as the cluster’s address, type, state, and starting time.
It will also indicate the number of parallel units the cluster is utilizing and whether it is currently streaming data, serving data, or unschedulable.
Syntax
SHOW CLUSTER;
Examples
SHOW CLUSTER;
------RESULT
Id | Addr | Type | State | Parallel Units | Is Streaming | Is Serving | Is Unschedulable | Started At
----+----------------+--------------------------+---------+----------------+--------------+------------+------------------+---------------------------
0 | 127.0.0.1:5690 | WORKER_TYPE_META | RUNNING | | | | | 2024-05-07 07:57:18+00:00
1 | 127.0.0.1:5688 | WORKER_TYPE_COMPUTE_NODE | RUNNING | 0, 1, 2, 3 | t | t | f | 2024-05-07 07:57:21+00:00
2 | 127.0.0.1:4566 | WORKER_TYPE_FRONTEND | RUNNING | | | | | 2024-05-07 07:57:24+00:00
3 | 127.0.0.1:6660 | WORKER_TYPE_COMPACTOR | RUNNING | | | | | 2024-05-07 07:57:24+00:00
(4 rows)
Was this page helpful?