The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

What's the current status of your Vertica cluster?

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!

Sign In or Register to comment.