Cluster information

Querying system tables to get cluster topology information.

You can query system tables to get cluster topology information. Display the IP address of peer nodes, datacenter and rack names, token values, and other information. "The Data Dictionary" article describes querying system tables in detail.

Procedure

After setting up a cluster, query the peers table.

SELECT *
FROM system.peers;

The following example output is truncated because of the large number of columns.

   peer    | data_center
-----------+-------------
 127.0.0.3 | datacenter1
 127.0.0.2 | datacenter1
                        
(2 rows)