
Example:
[dbadmin@SE-Sandbox-26-node1 ~]$ vsql -c "SELECT version();"
version
------------------------------------
Vertica Analytic Database v9.2.1-4https://www.vertica.com/wp-admin/post.php?post=999145387&action=edit#edit_timestamp
(1 row)
dbadmin=> SELECT DISTINCT component, description FROM data_collector WHERE table_name = 'dc_load_balance_operations';
component | description
-----------------------+-----------------------------------------------
LoadBalanceOperations | History of connection load balance operations
(1 row)
dbadmin=> SELECT clear_data_collector('LoadBalanceOperations');
clear_data_collector
----------------------
CLEAR
(1 row)
[dbadmin@SE-Sandbox-26-node1 ~]$ vsql -c "SELECT node_name, node_address FROM nodes;"
node_name | node_address
--------------------+---------------
v_test_db_node0001 | 172.16.61.176
v_test_db_node0002 | 172.16.61.177
v_test_db_node0003 | 172.16.61.178
(3 rows)
dbadmin=> \! vsql -Cc "SELECT local_node_name();"
local_node_name
--------------------
v_test_db_node0001
(1 row)
dbadmin=> \! vsql -Cc "SELECT local_node_name();"
local_node_name
--------------------
v_test_db_node0002
(1 row)
dbadmin=> \! vsql -Cc "SELECT local_node_name();"
local_node_name
--------------------
v_test_db_node0003
(1 row)
[dbadmin@SE-Sandbox-26-node1 ~]$ vsql -c "SELECT node_name, client_remote_address, status FROM dc_load_balance_operations ORDER BY time;"
node_name | client_remote_address | status
--------------------+-----------------------+----------------------------------------------------------------
v_test_db_node0001 | ::1 | Success. Load balance redirect to: [172.16.61.176] port [5433]
v_test_db_node0001 | ::1 | Success. Load balance redirect to: [172.16.61.177] port [5433]
v_test_db_node0001 | ::1 | Success. Load balance redirect to: [172.16.61.178] port [5433]
(3 rows)
Helpful Links:https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/ManagingClientConnections/LoadBalancing/ConnectionLoadBalancing.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/RetainingMonitoringInformation.htm
Have fun!