Jim Knicely authored this tip.
The GET_CLUSTER_STATE_SUMMARY function can be used to quickly view 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!
