What's the current status of your Vertica cluster?

in Vertica Tips
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!