Vertica Quick Tip: Summary of Cluster State

Posted March 29, 2018 by Soniya Shah, Information Developer

Shot of two businesswomen using a digital tablet together during a collaboration at work
This blog post was authored by Jim Knicely. 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!