What's the current status of your Vertica cluster?

[Deleted User]

Jim Knicely authored this tip.

You can use the GET_CLUSTER_STATE_SUMMARY function to get a quick view of the current status of your Vertica cluster.

Example:

All nodes are up:

dbadmin=> SELECT get_cluster_state_summary();
                      get_cluster_state_summary
---------------------------------------------------------------------------
Cluster State: test2
UP: 4 of 4 (v_test2_node0001, v_test2_node0002, v_test2_node0003, v_test2_node0004)
(1 row)

One node is down:

dbadmin=> \! admintools -t kill_node -s v_test2_node0004
*** Terminating vertica and performing host cleanup ***
        Terminating vertica processes on host '192.168.2.203'
All signals sent successfully.

dbadmin=> SELECT get_cluster_state_summary();
                  get_cluster_state_summary
---------------------------------------------------------------------
Cluster State: test2
UNKNOWN: 1 of 4 (v_test2_node0004)
UP: 3 of 4 (v_test2_node0001, v_test2_node0002, v_test2_node0003)
(1 row)

Have Fun!