---
title: "查询 SQL 流量分布情况及 QPS | OceanBase 文档中心"
description: "查询 SQL 流量分布情况及 QPS docslug#/oceanbase-database/oceanbase-database/V4.0.0/query-sql-traffic-and-query-the-qps 运行如下语句可以查询 SQL 流量分布情况及 QPS： obclient> SELECT/*+ PA…"
---
切换语言

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

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

# 查询 SQL 流量分布情况及 QPS

更新时间：2026-06-18 09:35:43

[编辑](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/500.query-sql-traffic-and-query-the-qps.md)  

运行如下语句可以查询 SQL 流量分布情况及 QPS：

```sql
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 tenant_id = 1001
AND SQL_ID = 'BF7AA13A28DF50BA5C33FF19F1DBD8A9'
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;

```

 上一篇 下一篇 ![有帮助](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) 咨询热线