How to check query's load balancing?

HyeontaeJu

How to check query's load balancing?

Hibiki

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