---
title: "查看集群 SQL 请求流量是否均衡 | OceanBase 文档中心"
description: 查看集群 SQL 请求流量是否均衡 运行如下语句可以查看集群 SQL 请求流量是否均衡： obclient> SELECT/*+ PARALLEL(15)*/t2.zone, t1.svr_ip, COUNT(*) AS QPS, AVG(t1.elapsed_time), AVG(t1.queue_time) FR…
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 3.2.4 企业版 LTS

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

更新时间：2026-06-11 12:55:39

运行如下语句可以查看集群 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$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.x.x.x       |  379 |            5067.3034 |            33.7071 |
| ET2_1  | 10.x.x.x       |  507 |            5784.1538 |            12.5878 |
| ET2_1  | 10.x.x.x       |  370 |            5958.2162 |            10.9811 |
| ET2_1  | 10.x.x.x       |  356 |            5730.9972 |            39.4185 |
| ET2_1  | 10.x.x.x       |  369 |            5851.7886 |            64.9621 |
| EU13_2 | 10.x.x.x       |  354 |            6182.6384 |            11.3107 |
| EU13_2 | 10.x.x.x       |  349 |            5881.3209 |            10.7393 |
| EU13_2 | 10.x.x.x       |  347 |            5936.0144 |            11.9049 |
| EU13_2 | 10.x.x.x       |  390 |            5988.4846 |            12.0487 |
| EU13_3 | 10.x.x.x       |  284 |            5657.2218 |            11.7993 |
| EU13_3 | 10.x.x.x       |  372 |            5360.6989 |            11.6290 |
| EU13_3 | 10.x.x.x       |  416 |            4154.2861 |            12.2524 |
| EU13_3 | 10.x.x.x       |  446 |            6487.6009 |            24.5112 |
| EU13_3 | 10.x.x.x       |  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) 咨询热线