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!
How to check query's load balancing?
HyeontaeJu
Vertica Customer ✭
How to check query's load balancing?
0
Answers
Please use the following query.
=> SELECT -> node_name, -> count(CASE WHEN request_type ='LOAD' THEN 1 ELSE null END) AS loads_initiated, -> count(CASE WHEN request_type ='QUERY' THEN 1 ELSE null END) AS selects_initiated -> FROM -> dc_requests_issued -> GROUP BY node_name -> ORDER BY node_name; node_name | loads_initiated | selects_initiated ---------------+-----------------+------------------- v_db_node0001 | 475 | 1182 v_db_node0002 | 0 | 890 v_db_node0003 | 0 | 894 v_db_node0004 | 0 | 547 v_db_node0005 | 0 | 552 v_db_node0006 | 0 | 547