View the History of Connection Load Balance Operations

Jim_Knicely

The Data Collector table DC_LOAD_BALANCE_OPERATIONS tracks the history of connection load balance operations.

Example:

[dbadmin@SE-Sandbox-26-node1 ~]$ vsql -c "SELECT version();"
              version
------------------------------------
Vertica Analytic Database v9.2.1-4
(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/9.2.x/HTML/Content/Authoring/AdministratorsGuide/ManagingClientConnections/LoadBalancing/ConnectionLoadBalancing.htm
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/RetainingMonitoringInformation.htm

Have fun!