​
Overview

The SHOW NODES statement returns the current state of the cluster and is only available to the superuser.

It is not case-sensitive, so show nodes, Show Nodes, and SHOW NODES do the same thing

​
Example

To view the current cluster state, you need to execute the following command:

SHOW NODES;

Once it’s done, you’ll see a table with the information about each node in the cluster, in a following way:

     name      | election_state  | followers_count | connected_nodes_count | degradation_error 
---------------+-----------------+-----------------+-----------------------+-------------------
 n_oxla_node_1 | LEADER_FOLLOWER |               0 |                     3 | 
 n_oxla_node_3 | LEADER          |               3 |                     3 | 
 n_oxla_node_2 | LEADER_FOLLOWER |               0 |                     3 | 
(3 rows)

Each row represents the state of an individual node within the cluster, where:

  • name: name of the node
  • election_state: current state of the node (e.g. LEADER)
  • followers_count: number of nodes following the leader, which applies to the leader node
  • connected_nodes_count: total number of nodes connected, including itself
  • degradation_error: error message if the node is not working correctly, otherwise it shows NULL