Skip to main content

​
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
⌘I