---
title: "查询某段时间内执行时间排名 TOP N 的请求 | OceanBase 文档中心"
description: 查询某段时间内执行时间排名 TOP N 的请求 运行如下语句可以查询某段时间内执行时间排名 TOP N 的请求： obclient> SELECT/*+ PARALLEL(15)*/ sql_id, elapsed_time , trace_id FROM oceanbase.gv$sql_audit WHERE t…
---
切换语言

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

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

# 查询某段时间内执行时间排名 TOP N 的请求

更新时间：2023-07-18 17:26:00

运行如下语句可以查询某段时间内执行时间排名 TOP N 的请求：

```javascript
obclient> SELECT/*+ PARALLEL(15)*/ sql_id, elapsed_time , trace_id
         FROM oceanbase.gv$sql_audit
         WHERE   tenant_id = 1001
         and IS_EXECUTOR_RPC = 0
         and request_time > (time_to_usec(now()) - 10000000)
         AND request_time < time_to_usec(now())
         ORDER BY elapsed_time DESC LIMIT 10;

+----------------------------------+--------------+-------------------------------+
| sql_id                           | elapsed_time | trace_id                      |
+----------------------------------+--------------+-------------------------------+
| CFA269275E3BB270408747C01F64D837 |        87381 | YB420AB75598-0005634FBED5C5E8 |
| 1979A5B4A27D5C3DBE08F80383FD6EB6 |        83465 | YB420AB74E56-0005634B4B87353B |
| 51248E6C3BB5EF1FC4E8E79CA685723E |        82767 | YB420AB74E56-0005634B4B82E7E1 |
| 249C40E669DFCCE80E3D11446272FA11 |        79919 | YB420A67E27C-00056349549A79D3 |
| BEFAD568C3858D2C2E35F01558CBEC06 |        77210 | YB420A67E4B1-00056345B0F2E97E |
| FB1A6A8BC4125C324A38F91B3808D364 |        75870 | YB420AB74E71-00056347074261E6 |
| 0343A519C0C5BF31C68CB68F63721990 |        75666 | YB420BB47107-00056346A5A631FB |
| B140BB0C671D9B8616FB048544F3B85B |        73902 | YB420A67E56B-00056342A5A4683E |
| 4F9B1D0A3822A3E0DF69DB11ABFBE0EA |        72963 | YB420BB47107-00056346A5AAC5F5 |
| 9963E8D252E6CBA72FBA45AC5790BA11 |        72354 | YB420A67E56B-00056342A5A66089 |
+----------------------------------+--------------+-------------------------------+

```

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