---
title: "查看集群 SQL 请求流量是否均衡 | OceanBase 文档中心"
description: "查看集群 SQL 请求流量是否均衡 docslug#/oceanbase-database/oceanbase-database/V4.0.0/check-whether-the-sql-request-traffic-is-balanced 运行如下语句可以查看集群 SQL 请求流量是否均衡： obclient> …"
image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.0.0 社区版

# 查看集群 SQL 请求流量是否均衡

更新时间：2026-05-19 13:04:49

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.0.0/zh-CN/500.administrator-guide/900.performance-tuning-guide/500.sql-optimization/400.sql-optimization-1/300.monitor-sql-execution-performance/400.sql-performance-analysis-example/600.check-whether-the-sql-request-traffic-is-balanced.md)  

运行如下语句可以查看集群 SQL 请求流量是否均衡：

```sql
obclient> SELECT/*+ PARALLEL(15)*/t2.zone, t1.svr_ip,  COUNT(*) AS QPS,  
      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 = 0
      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         | QPS  | avg(t1.elapsed_time) | avg(t1.queue_time) |
+--------+----------------+------+----------------------+--------------------+
| ET2_1  | 10.10.10.1 |  379 |            5067.3034 |            33.7071 |
| ET2_1  | 10.10.10.2 |  507 |            5784.1538 |            12.5878 |
| ET2_1  | 10.10.10.3 |  370 |            5958.2162 |            10.9811 |
| ET2_1  | 10.10.10.4 |  356 |            5730.9972 |            39.4185 |
| ET2_1  | 10.10.10.5  |  369 |            5851.7886 |            64.9621 |
| EU13_2 | 10.10.10.6  |  354 |            6182.6384 |            11.3107 |
| EU13_2 | 10.10.10.7   |  349 |            5881.3209 |            10.7393 |
| EU13_2 | 10.10.10.8   |  347 |            5936.0144 |            11.9049 |
| EU13_2 | 10.10.10.9  |  390 |            5988.4846 |            12.0487 |
| EU13_3 | 10.10.10.10  |  284 |            5657.2218 |            11.7993 |
| EU13_3 | 10.10.10.11  |  372 |            5360.6989 |            11.6290 |
| EU13_3 | 10.10.10.12  |  416 |            4154.2861 |            12.2524 |
| EU13_3 | 10.10.10.13   |  446 |            6487.6009 |            24.5112 |
| EU13_3 | 10.10.10.14   |  364 |            5444.4203 |            12.3462 |
+--------+----------------+------+----------------------+--------------------+
```

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线