OceanBase 查看分布式子计划 RPC 执行数是否均衡
运行如下语句可以查看分布式计划 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$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.103.224.119 | 2517 | 514.2241 | 13.5515 |
| ET2_1 | 10.103.226.124 | 2786 | 1628.0948 | 13.2915 |
| ET2_1 | 10.103.228.177 | 3068 | 1984.0238 | 12.9029 |
| ET2_1 | 10.103.229.107 | 3216 | 538.7646 | 12.8629 |
| ET2_1 | 10.103.229.94 | 2228 | 802.8577 | 13.4138 |
| EU13_2 | 10.183.78.113 | 2000 | 805.0485 | 13.0610 |
| EU13_2 | 10.183.78.86 | 3296 | 1115.0725 | 13.2700 |
| EU13_2 | 10.183.79.56 | 2460 | 1129.4085 | 14.3293 |
| EU13_2 | 10.183.85.152 | 2533 | 891.0683 | 13.8602 |
| EU13_3 | 10.183.76.140 | 3045 | 677.6591 | 13.7209 |
| EU13_3 | 10.183.78.165 | 2202 | 821.9496 | 12.8247 |
| EU13_3 | 10.183.79.198 | 2825 | 1277.0375 | 13.3345 |
| EU13_3 | 10.183.86.65 | 2142 | 746.0808 | 13.0121 |
| EU13_3 | 11.180.113.7 | 2735 | 765.8731 | 12.4750 |
+--------+----------------+-----------+----------------------+--------------------+