---
title: github-fill
description: 查看集群 SQL 请求流量是否均衡 运行如下语句可以查看集群 SQL 请求流量是否均衡： obclient> SELECT /*+ PARALLEL(15)*/ t2.zone, t1.svr_ip, COUNT(*) AS QPS, AVG(t1.elapsed_time), AVG(t1.queue_time) …
---
切换语言

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

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

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

更新时间：2026-04-09 14:12:04

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.3.5/zh-CN/700.reference/1000.performance-tuning-guide/500.sql-optimization/1100.sql-performance-analysis-best-practices/600.check-whether-the-sql-request-traffic-is-balanced.md)  

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

```shell
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,
     oceanbase.DBA_OB_SERVERS t2
WHERE t1.svr_ip = t2.svr_ip
AND t1.is_executor_rpc = 0
AND t1.request_time > (time_to_usec(now()) - 1000000)
AND t1.request_time < time_to_usec(now())
GROUP BY t1.svr_ip
ORDER BY t2.zone;

```

返回结果如下：

```shell
+--------+----------------+------+----------------------+--------------------+
| 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) 咨询热线