查看分布式子计划 RPC 执行数是否均衡

obclient> SELECT/*+ PARALLEL(15)*/t2.zone, t1.svr_ip,  COUNT(*) AS RPC_COUNT, 
        AVG(t1.elapsed_time),AVG(t1.queue_time)  
        FROM oceanbase.GV$OB_SQL_AUDIT t1, __all_server t2  
        WHERE t1.svr_ip = t2.svr_ip AND IS_EXECUTOR_RPC = 1    
        AND tenant_id = 1001
        AND request_time > (time_to_usec(now()) - 1000000)    
        AND request_time < time_to_usec(now()) 
        GROUP BY t1.svr_ip ORDER BY t2.zone;

+--------+----------------+-----------+----------------------+--------------------+
| zone   | svr_ip         | RPC_COUNT | avg(t1.elapsed_time) | avg(t1.queue_time) |
+--------+----------------+-----------+----------------------+--------------------+
| ET2_1  | 10.1.1.1 |      2517 |             514.2241 |            13.5515 |
| ET2_1  | 10.1.1.2 |      2786 |            1628.0948 |            13.2915 |
| ET2_1  | 10.1.1.3 |      3068 |            1984.0238 |            12.9029 |
| ET2_1  | 10.1.1.4 |      3216 |             538.7646 |            12.8629 |
| ET2_1  | 10.1.1.5  |      2228 |             802.8577 |            13.4138 |
| EU13_2 | 10.1.1.6  |      2000 |             805.0485 |            13.0610 |
| EU13_2 | 10.1.1.7   |      3296 |            1115.0725 |            13.2700 |
| EU13_2 | 10.1.1.8  |      2460 |            1129.4085 |            14.3293 |
| EU13_2 | 10.1.1.9 |      2533 |             891.0683 |            13.8602 |
| EU13_3 | 10.1.1.10  |      3045 |             677.6591 |            13.7209 |
| EU13_3 | 10.1.1.11  |      2202 |             821.9496 |            12.8247 |
| EU13_3 | 10.1.1.12  |      2825 |            1277.0375 |            13.3345 |
| EU13_3 | 10.1.1.12  |      2142 |             746.0808 |            13.0121 |
| EU13_3 | 10.1.1.14   |      2735 |             765.8731 |            12.4750 |
+--------+----------------+-----------+----------------------+--------------------+