This is an automated email from the ASF dual-hosted git repository.
HTHou pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/iotdb-docs.git
The following commit(s) were added to refs/heads/main by this push:
new 97bb3289 Update show queries columns in docs (#1180)
97bb3289 is described below
commit 97bb32897d487390e0a0d1e8421991c7f58166fc
Author: leto-bbq <[email protected]>
AuthorDate: Thu Jul 9 18:30:17 2026 +0800
Update show queries columns in docs (#1180)
---
.../Master/Table/Reference/System-Tables_apache.md | 13 ++++++++-----
.../Table/SQL-Manual/SQL-Maintenance-Statements_apache.md | 12 ++++++------
.../Table/User-Manual/Maintenance-commands_apache.md | 15 +++++++++------
.../Tree/User-Manual/Maintenance-commands_apache.md | 13 ++++++++-----
.../latest-Table/Reference/System-Tables_apache.md | 13 ++++++++-----
.../SQL-Manual/SQL-Maintenance-Statements_apache.md | 12 ++++++------
.../User-Manual/Maintenance-commands_apache.md | 15 +++++++++------
.../latest/User-Manual/Maintenance-commands_apache.md | 13 ++++++++-----
.../Master/Table/Reference/System-Tables_apache.md | 13 ++++++++-----
.../Table/SQL-Manual/SQL-Maintenance-Statements_apache.md | 12 ++++++------
.../Table/User-Manual/Maintenance-statement_apache.md | 15 +++++++++------
.../Tree/User-Manual/Maintenance-statement_apache.md | 13 ++++++++-----
.../latest-Table/Reference/System-Tables_apache.md | 13 ++++++++-----
.../SQL-Manual/SQL-Maintenance-Statements_apache.md | 12 ++++++------
.../User-Manual/Maintenance-statement_apache.md | 15 +++++++++------
.../latest/User-Manual/Maintenance-statement_apache.md | 13 ++++++++-----
16 files changed, 124 insertions(+), 88 deletions(-)
diff --git a/src/UserGuide/Master/Table/Reference/System-Tables_apache.md
b/src/UserGuide/Master/Table/Reference/System-Tables_apache.md
index 1ffc0735..1a1839e2 100644
--- a/src/UserGuide/Master/Table/Reference/System-Tables_apache.md
+++ b/src/UserGuide/Master/Table/Reference/System-Tables_apache.md
@@ -191,17 +191,20 @@ IoTDB> select * from information_schema.regions
| `elapsed_time` | FLOAT | ATTRIBUTE | Query execution duration (in
seconds) |
| `statement` | STRING | ATTRIBUTE | SQL statement of the query
|
| `user` | STRING | ATTRIBUTE | User who initiated the query
|
+| `wait_time_in_server` | FLOAT | ATTRIBUTE | Cumulative time that the
client request waits in the server for results to be returned, in seconds
(supported since V2.0.10) |
+| `client_ip` | STRING | ATTRIBUTE | IP address of the client that
initiated the query (supported since V2.0.10) |
+| `timeout` | INT64 | ATTRIBUTE | Timeout of the query, in ms
(supported since V2.0.10) |
* For regular users, the query results only display the queries executed by
themselves; for administrators, all queries are displayed.
* Query Example:
```SQL
IoTDB> select * from information_schema.queries
-+-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+
-| query_id|
start_time|datanode_id|elapsed_time|
statement|user|
-+-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+
-|20250331_023242_00011_1|2025-03-31T10:32:42.360+08:00| 1|
0.025|select * from information_schema.queries|root|
-+-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+
++-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+-------------------+---------+-------+
+| query_id|
start_time|datanode_id|elapsed_time|
statement|user|wait_time_in_server|client_ip|timeout|
++-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+-------------------+---------+-------+
+|20260601_032216_00018_1|2026-06-01T11:22:16.815+08:00| 1|
0.014|select * from information_schema.queries|root|
0.0158324|127.0.0.1| 60000|
++-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+-------------------+---------+-------+
```
### 2.5 COLUMNS
diff --git
a/src/UserGuide/Master/Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
b/src/UserGuide/Master/Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
index 8b975d66..9909c55e 100644
--- a/src/UserGuide/Master/Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
+++ b/src/UserGuide/Master/Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
@@ -459,12 +459,12 @@ showQueriesStatement
**Example:**
```SQL
-IoTDB> SHOW QUERIES WHERE elapsed_time > 30
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-| query_id|
start_time|datanode_id|elapsed_time| statement|user|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-|20250108_101015_00000_1|2025-01-08T18:10:15.935+08:00| 1|
32.283|show queries|root|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
+IoTDB> SHOW QUERIES WHERE elapsed_time > 0.003
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+| query_id|
start_time|datanode_id|elapsed_time|
statement|user|wait_time_in_server|client_ip|timeout|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+|20260601_032051_00016_1|2026-06-01T11:20:51.130+08:00| 1|
0.017|SHOW QUERIES WHERE elapsed_time > 0.003|root|
0.0190219|127.0.0.1| 60000|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
```
### 5.2 Terminate Queries
diff --git
a/src/UserGuide/Master/Table/User-Manual/Maintenance-commands_apache.md
b/src/UserGuide/Master/Table/User-Manual/Maintenance-commands_apache.md
index 2c4bd4f2..b25b0e9c 100644
--- a/src/UserGuide/Master/Table/User-Manual/Maintenance-commands_apache.md
+++ b/src/UserGuide/Master/Table/User-Manual/Maintenance-commands_apache.md
@@ -289,21 +289,24 @@ showQueriesStatement
- **elapsed_time**: Time elapsed since the query started (in seconds).
- **statement**: The SQL statement being executed.
- **user**: The user who initiated the query.
+- **wait_time_in_server**: Cumulative time that the client request waits in
the server for results to be returned, in seconds (supported since V2.0.10).
+- **client_ip**: IP address of the client that initiated the query (supported
since V2.0.10).
+- **timeout**: Timeout of the query, in ms (supported since V2.0.10).
**Example**:
```SQL
-IoTDB> SHOW QUERIES WHERE elapsed_time > 30;
+IoTDB> SHOW QUERIES WHERE elapsed_time > 0.003
```
**Result**:
```Plain
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-| query_id|
start_time|datanode_id|elapsed_time| statement|user|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-|20250108_101015_00000_1|2025-01-08T18:10:15.935+08:00| 1|
32.283|show queries|root|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+| query_id|
start_time|datanode_id|elapsed_time|
statement|user|wait_time_in_server|client_ip|timeout|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+|20260601_032051_00016_1|2026-06-01T11:20:51.130+08:00| 1|
0.017|SHOW QUERIES WHERE elapsed_time > 0.003|root|
0.0190219|127.0.0.1| 60000|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
```
diff --git
a/src/UserGuide/Master/Tree/User-Manual/Maintenance-commands_apache.md
b/src/UserGuide/Master/Tree/User-Manual/Maintenance-commands_apache.md
index dc4a4764..5dd68411 100644
--- a/src/UserGuide/Master/Tree/User-Manual/Maintenance-commands_apache.md
+++ b/src/UserGuide/Master/Tree/User-Manual/Maintenance-commands_apache.md
@@ -195,6 +195,9 @@ showQueriesStatement
- **datanodeid**: ID of the DataNode executing the query.
- **elapsedtime**: Time elapsed since the query started (in seconds).
- **statement**: The SQL statement being executed.
+- **WaitTimeInServer**: Cumulative time that the client request waits in the
server for results to be returned, in seconds (supported since V2.0.10).
+- **ClientIp**: IP address of the client that initiated the query (supported
since V2.0.10).
+- **Timeout**: Timeout of the query, in ms (supported since V2.0.10).
**Example**:
@@ -205,11 +208,11 @@ IoTDB> SHOW QUERIES WHERE elapsedtime > 0.003
**Result**:
```SQL
-+-----------------------------+-----------------------+----------+-----------+--------------------------------------+
-| Time| QueryId|DataNodeId|ElapsedTime|
Statement|
-+-----------------------------+-----------------------+----------+-----------+--------------------------------------+
-|2025-05-09T15:16:01.293+08:00|20250509_071601_00015_1| 1|
0.006|SHOW QUERIES WHERE elapsedtime > 0.003|
-+-----------------------------+-----------------------+----------+-----------+--------------------------------------+
++-----------------------------+-----------------------+----------+-----------+--------------------------------------+----------------+---------+-------+
+| Time| QueryId|DataNodeId|ElapsedTime|
Statement|WaitTimeInServer| ClientIp|Timeout|
++-----------------------------+-----------------------+----------+-----------+--------------------------------------+----------------+---------+-------+
+|2026-06-01T11:13:39.057+08:00|20260601_031339_00003_1| 1|
0.074|SHOW QUERIES WHERE elapsedtime > 0.003| 0.0736961|127.0.0.1| 60000|
++-----------------------------+-----------------------+----------+-----------+--------------------------------------+----------------+---------+-------+
```
### 1.6 Viewing Region Information
diff --git a/src/UserGuide/latest-Table/Reference/System-Tables_apache.md
b/src/UserGuide/latest-Table/Reference/System-Tables_apache.md
index 1ffc0735..1a1839e2 100644
--- a/src/UserGuide/latest-Table/Reference/System-Tables_apache.md
+++ b/src/UserGuide/latest-Table/Reference/System-Tables_apache.md
@@ -191,17 +191,20 @@ IoTDB> select * from information_schema.regions
| `elapsed_time` | FLOAT | ATTRIBUTE | Query execution duration (in
seconds) |
| `statement` | STRING | ATTRIBUTE | SQL statement of the query
|
| `user` | STRING | ATTRIBUTE | User who initiated the query
|
+| `wait_time_in_server` | FLOAT | ATTRIBUTE | Cumulative time that the
client request waits in the server for results to be returned, in seconds
(supported since V2.0.10) |
+| `client_ip` | STRING | ATTRIBUTE | IP address of the client that
initiated the query (supported since V2.0.10) |
+| `timeout` | INT64 | ATTRIBUTE | Timeout of the query, in ms
(supported since V2.0.10) |
* For regular users, the query results only display the queries executed by
themselves; for administrators, all queries are displayed.
* Query Example:
```SQL
IoTDB> select * from information_schema.queries
-+-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+
-| query_id|
start_time|datanode_id|elapsed_time|
statement|user|
-+-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+
-|20250331_023242_00011_1|2025-03-31T10:32:42.360+08:00| 1|
0.025|select * from information_schema.queries|root|
-+-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+
++-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+-------------------+---------+-------+
+| query_id|
start_time|datanode_id|elapsed_time|
statement|user|wait_time_in_server|client_ip|timeout|
++-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+-------------------+---------+-------+
+|20260601_032216_00018_1|2026-06-01T11:22:16.815+08:00| 1|
0.014|select * from information_schema.queries|root|
0.0158324|127.0.0.1| 60000|
++-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+-------------------+---------+-------+
```
### 2.5 COLUMNS
diff --git
a/src/UserGuide/latest-Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
b/src/UserGuide/latest-Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
index 8b975d66..9909c55e 100644
--- a/src/UserGuide/latest-Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
+++ b/src/UserGuide/latest-Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
@@ -459,12 +459,12 @@ showQueriesStatement
**Example:**
```SQL
-IoTDB> SHOW QUERIES WHERE elapsed_time > 30
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-| query_id|
start_time|datanode_id|elapsed_time| statement|user|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-|20250108_101015_00000_1|2025-01-08T18:10:15.935+08:00| 1|
32.283|show queries|root|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
+IoTDB> SHOW QUERIES WHERE elapsed_time > 0.003
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+| query_id|
start_time|datanode_id|elapsed_time|
statement|user|wait_time_in_server|client_ip|timeout|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+|20260601_032051_00016_1|2026-06-01T11:20:51.130+08:00| 1|
0.017|SHOW QUERIES WHERE elapsed_time > 0.003|root|
0.0190219|127.0.0.1| 60000|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
```
### 5.2 Terminate Queries
diff --git
a/src/UserGuide/latest-Table/User-Manual/Maintenance-commands_apache.md
b/src/UserGuide/latest-Table/User-Manual/Maintenance-commands_apache.md
index 6ea537ae..7f1b2e47 100644
--- a/src/UserGuide/latest-Table/User-Manual/Maintenance-commands_apache.md
+++ b/src/UserGuide/latest-Table/User-Manual/Maintenance-commands_apache.md
@@ -289,21 +289,24 @@ showQueriesStatement
- **elapsed_time**: Time elapsed since the query started (in seconds).
- **statement**: The SQL statement being executed.
- **user**: The user who initiated the query.
+- **wait_time_in_server**: Cumulative time that the client request waits in
the server for results to be returned, in seconds (supported since V2.0.10).
+- **client_ip**: IP address of the client that initiated the query (supported
since V2.0.10).
+- **timeout**: Timeout of the query, in ms (supported since V2.0.10).
**Example**:
```SQL
-IoTDB> SHOW QUERIES WHERE elapsed_time > 30;
+IoTDB> SHOW QUERIES WHERE elapsed_time > 0.003
```
**Result**:
```Plain
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-| query_id|
start_time|datanode_id|elapsed_time| statement|user|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-|20250108_101015_00000_1|2025-01-08T18:10:15.935+08:00| 1|
32.283|show queries|root|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+| query_id|
start_time|datanode_id|elapsed_time|
statement|user|wait_time_in_server|client_ip|timeout|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+|20260601_032051_00016_1|2026-06-01T11:20:51.130+08:00| 1|
0.017|SHOW QUERIES WHERE elapsed_time > 0.003|root|
0.0190219|127.0.0.1| 60000|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
```
diff --git a/src/UserGuide/latest/User-Manual/Maintenance-commands_apache.md
b/src/UserGuide/latest/User-Manual/Maintenance-commands_apache.md
index dc4a4764..5dd68411 100644
--- a/src/UserGuide/latest/User-Manual/Maintenance-commands_apache.md
+++ b/src/UserGuide/latest/User-Manual/Maintenance-commands_apache.md
@@ -195,6 +195,9 @@ showQueriesStatement
- **datanodeid**: ID of the DataNode executing the query.
- **elapsedtime**: Time elapsed since the query started (in seconds).
- **statement**: The SQL statement being executed.
+- **WaitTimeInServer**: Cumulative time that the client request waits in the
server for results to be returned, in seconds (supported since V2.0.10).
+- **ClientIp**: IP address of the client that initiated the query (supported
since V2.0.10).
+- **Timeout**: Timeout of the query, in ms (supported since V2.0.10).
**Example**:
@@ -205,11 +208,11 @@ IoTDB> SHOW QUERIES WHERE elapsedtime > 0.003
**Result**:
```SQL
-+-----------------------------+-----------------------+----------+-----------+--------------------------------------+
-| Time| QueryId|DataNodeId|ElapsedTime|
Statement|
-+-----------------------------+-----------------------+----------+-----------+--------------------------------------+
-|2025-05-09T15:16:01.293+08:00|20250509_071601_00015_1| 1|
0.006|SHOW QUERIES WHERE elapsedtime > 0.003|
-+-----------------------------+-----------------------+----------+-----------+--------------------------------------+
++-----------------------------+-----------------------+----------+-----------+--------------------------------------+----------------+---------+-------+
+| Time| QueryId|DataNodeId|ElapsedTime|
Statement|WaitTimeInServer| ClientIp|Timeout|
++-----------------------------+-----------------------+----------+-----------+--------------------------------------+----------------+---------+-------+
+|2026-06-01T11:13:39.057+08:00|20260601_031339_00003_1| 1|
0.074|SHOW QUERIES WHERE elapsedtime > 0.003| 0.0736961|127.0.0.1| 60000|
++-----------------------------+-----------------------+----------+-----------+--------------------------------------+----------------+---------+-------+
```
### 1.6 Viewing Region Information
diff --git a/src/zh/UserGuide/Master/Table/Reference/System-Tables_apache.md
b/src/zh/UserGuide/Master/Table/Reference/System-Tables_apache.md
index 158ef2c7..2822a028 100644
--- a/src/zh/UserGuide/Master/Table/Reference/System-Tables_apache.md
+++ b/src/zh/UserGuide/Master/Table/Reference/System-Tables_apache.md
@@ -191,17 +191,20 @@ IoTDB> select * from information_schema.regions
| elapsed\_time | FLOAT | ATTRIBUTE | 查询执行耗时，单位是秒 |
| statement | STRING | ATTRIBUTE | 查询sql
|
| user | STRING | ATTRIBUTE | 发起查询的用户
|
+| wait\_time\_in\_server | FLOAT | ATTRIBUTE | 客户端请求在 server
等待结果返回的累计耗时，单位 s（V2.0.10 起支持） |
+| client\_ip | STRING | ATTRIBUTE | 发起查询的客户端 ip（V2.0.10 起支持） |
+| timeout | INT64 | ATTRIBUTE | 该查询的超时时间，单位 ms（V2.0.10 起支持） |
* 普通用户查询结果仅显示自身执行的查询；管理员显示全部。
* 查询示例：
```SQL
IoTDB> select * from information_schema.queries
-+-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+
-| query_id|
start_time|datanode_id|elapsed_time|
statement|user|
-+-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+
-|20250331_023242_00011_1|2025-03-31T10:32:42.360+08:00| 1|
0.025|select * from information_schema.queries|root|
-+-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+
++-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+-------------------+---------+-------+
+| query_id|
start_time|datanode_id|elapsed_time|
statement|user|wait_time_in_server|client_ip|timeout|
++-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+-------------------+---------+-------+
+|20260601_032216_00018_1|2026-06-01T11:22:16.815+08:00| 1|
0.014|select * from information_schema.queries|root|
0.0158324|127.0.0.1| 60000|
++-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+-------------------+---------+-------+
```
### 2.5 COLUMNS 表
diff --git
a/src/zh/UserGuide/Master/Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
b/src/zh/UserGuide/Master/Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
index 4793ddd1..c38314a4 100644
---
a/src/zh/UserGuide/Master/Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
+++
b/src/zh/UserGuide/Master/Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
@@ -458,12 +458,12 @@ showQueriesStatement
**示例：**
```SQL
-IoTDB> SHOW QUERIES WHERE elapsed_time > 30
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-| query_id|
start_time|datanode_id|elapsed_time| statement|user|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-|20250108_101015_00000_1|2025-01-08T18:10:15.935+08:00| 1|
32.283|show queries|root|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
+IoTDB> SHOW QUERIES WHERE elapsed_time > 0.003
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+| query_id|
start_time|datanode_id|elapsed_time|
statement|user|wait_time_in_server|client_ip|timeout|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+|20260601_032051_00016_1|2026-06-01T11:20:51.130+08:00| 1|
0.017|SHOW QUERIES WHERE elapsed_time > 0.003|root|
0.0190219|127.0.0.1| 60000|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
```
### 5.2 主动终止查询
diff --git
a/src/zh/UserGuide/Master/Table/User-Manual/Maintenance-statement_apache.md
b/src/zh/UserGuide/Master/Table/User-Manual/Maintenance-statement_apache.md
index 6f400527..4d66b27f 100644
--- a/src/zh/UserGuide/Master/Table/User-Manual/Maintenance-statement_apache.md
+++ b/src/zh/UserGuide/Master/Table/User-Manual/Maintenance-statement_apache.md
@@ -289,21 +289,24 @@ showQueriesStatement
- **elapsed_time**：查询的执行耗时，单位是秒
- **statement**：查询的 SQL 语句
- **user**：发起查询的用户
+ - **wait_time_in_server**：客户端请求在 server 等待结果返回的累计耗时，单位 s（V2.0.10 起支持）
+ - **client_ip**：发起查询的客户端 ip（V2.0.10 起支持）
+ - **timeout**：该查询的超时时间，单位 ms（V2.0.10 起支持）
#### 示例：
```SQL
-IoTDB> SHOW QUERIES WHERE elapsed_time > 30
+IoTDB> SHOW QUERIES WHERE elapsed_time > 0.003
```
执行结果如下：
```SQL
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-| query_id|
start_time|datanode_id|elapsed_time| statement|user|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-|20250108_101015_00000_1|2025-01-08T18:10:15.935+08:00| 1|
32.283|show queries|root|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+| query_id|
start_time|datanode_id|elapsed_time|
statement|user|wait_time_in_server|client_ip|timeout|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+|20260601_032051_00016_1|2026-06-01T11:20:51.130+08:00| 1|
0.017|SHOW QUERIES WHERE elapsed_time > 0.003|root|
0.0190219|127.0.0.1| 60000|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
```
### 1.9 查看分区信息
diff --git
a/src/zh/UserGuide/Master/Tree/User-Manual/Maintenance-statement_apache.md
b/src/zh/UserGuide/Master/Tree/User-Manual/Maintenance-statement_apache.md
index ac80d3f3..1ab88572 100644
--- a/src/zh/UserGuide/Master/Tree/User-Manual/Maintenance-statement_apache.md
+++ b/src/zh/UserGuide/Master/Tree/User-Manual/Maintenance-statement_apache.md
@@ -194,6 +194,9 @@ showQueriesStatement
- **datanodeid**：发起查询语句的 DataNode 的ID
- **elapsedtime**：查询的执行耗时，单位是秒
- **statement**：查询的 SQL 语句
+ - **WaitTimeInServer**：客户端请求在 server 等待结果返回的累计耗时，单位 s（V2.0.10 起支持）
+ - **ClientIp**：发起查询的客户端 ip（V2.0.10 起支持）
+ - **Timeout**：该查询的超时时间，单位 ms（V2.0.10 起支持）
#### 示例：
@@ -205,11 +208,11 @@ IoTDB> SHOW QUERIES WHERE elapsedtime > 0.003
执行结果如下：
```SQL
-+-----------------------------+-----------------------+----------+-----------+--------------------------------------+
-| Time| QueryId|DataNodeId|ElapsedTime|
Statement|
-+-----------------------------+-----------------------+----------+-----------+--------------------------------------+
-|2025-05-09T15:16:01.293+08:00|20250509_071601_00015_1| 1|
0.006|SHOW QUERIES WHERE elapsedtime > 0.003|
-+-----------------------------+-----------------------+----------+-----------+--------------------------------------+
++-----------------------------+-----------------------+----------+-----------+--------------------------------------+----------------+---------+-------+
+| Time| QueryId|DataNodeId|ElapsedTime|
Statement|WaitTimeInServer| ClientIp|Timeout|
++-----------------------------+-----------------------+----------+-----------+--------------------------------------+----------------+---------+-------+
+|2026-06-01T11:13:39.057+08:00|20260601_031339_00003_1| 1|
0.074|SHOW QUERIES WHERE elapsedtime > 0.003| 0.0736961|127.0.0.1| 60000|
++-----------------------------+-----------------------+----------+-----------+--------------------------------------+----------------+---------+-------+
```
diff --git a/src/zh/UserGuide/latest-Table/Reference/System-Tables_apache.md
b/src/zh/UserGuide/latest-Table/Reference/System-Tables_apache.md
index 158ef2c7..2822a028 100644
--- a/src/zh/UserGuide/latest-Table/Reference/System-Tables_apache.md
+++ b/src/zh/UserGuide/latest-Table/Reference/System-Tables_apache.md
@@ -191,17 +191,20 @@ IoTDB> select * from information_schema.regions
| elapsed\_time | FLOAT | ATTRIBUTE | 查询执行耗时，单位是秒 |
| statement | STRING | ATTRIBUTE | 查询sql
|
| user | STRING | ATTRIBUTE | 发起查询的用户
|
+| wait\_time\_in\_server | FLOAT | ATTRIBUTE | 客户端请求在 server
等待结果返回的累计耗时，单位 s（V2.0.10 起支持） |
+| client\_ip | STRING | ATTRIBUTE | 发起查询的客户端 ip（V2.0.10 起支持） |
+| timeout | INT64 | ATTRIBUTE | 该查询的超时时间，单位 ms（V2.0.10 起支持） |
* 普通用户查询结果仅显示自身执行的查询；管理员显示全部。
* 查询示例：
```SQL
IoTDB> select * from information_schema.queries
-+-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+
-| query_id|
start_time|datanode_id|elapsed_time|
statement|user|
-+-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+
-|20250331_023242_00011_1|2025-03-31T10:32:42.360+08:00| 1|
0.025|select * from information_schema.queries|root|
-+-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+
++-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+-------------------+---------+-------+
+| query_id|
start_time|datanode_id|elapsed_time|
statement|user|wait_time_in_server|client_ip|timeout|
++-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+-------------------+---------+-------+
+|20260601_032216_00018_1|2026-06-01T11:22:16.815+08:00| 1|
0.014|select * from information_schema.queries|root|
0.0158324|127.0.0.1| 60000|
++-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+-------------------+---------+-------+
```
### 2.5 COLUMNS 表
diff --git
a/src/zh/UserGuide/latest-Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
b/src/zh/UserGuide/latest-Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
index 4793ddd1..c38314a4 100644
---
a/src/zh/UserGuide/latest-Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
+++
b/src/zh/UserGuide/latest-Table/SQL-Manual/SQL-Maintenance-Statements_apache.md
@@ -458,12 +458,12 @@ showQueriesStatement
**示例：**
```SQL
-IoTDB> SHOW QUERIES WHERE elapsed_time > 30
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-| query_id|
start_time|datanode_id|elapsed_time| statement|user|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-|20250108_101015_00000_1|2025-01-08T18:10:15.935+08:00| 1|
32.283|show queries|root|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
+IoTDB> SHOW QUERIES WHERE elapsed_time > 0.003
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+| query_id|
start_time|datanode_id|elapsed_time|
statement|user|wait_time_in_server|client_ip|timeout|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+|20260601_032051_00016_1|2026-06-01T11:20:51.130+08:00| 1|
0.017|SHOW QUERIES WHERE elapsed_time > 0.003|root|
0.0190219|127.0.0.1| 60000|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
```
### 5.2 主动终止查询
diff --git
a/src/zh/UserGuide/latest-Table/User-Manual/Maintenance-statement_apache.md
b/src/zh/UserGuide/latest-Table/User-Manual/Maintenance-statement_apache.md
index 5cefc483..0af98804 100644
--- a/src/zh/UserGuide/latest-Table/User-Manual/Maintenance-statement_apache.md
+++ b/src/zh/UserGuide/latest-Table/User-Manual/Maintenance-statement_apache.md
@@ -289,21 +289,24 @@ showQueriesStatement
- **elapsed_time**：查询的执行耗时，单位是秒
- **statement**：查询的 SQL 语句
- **user**：发起查询的用户
+ - **wait_time_in_server**：客户端请求在 server 等待结果返回的累计耗时，单位 s（V2.0.10 起支持）
+ - **client_ip**：发起查询的客户端 ip（V2.0.10 起支持）
+ - **timeout**：该查询的超时时间，单位 ms（V2.0.10 起支持）
#### 示例：
```SQL
-IoTDB> SHOW QUERIES WHERE elapsed_time > 30
+IoTDB> SHOW QUERIES WHERE elapsed_time > 0.003
```
执行结果如下：
```SQL
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-| query_id|
start_time|datanode_id|elapsed_time| statement|user|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
-|20250108_101015_00000_1|2025-01-08T18:10:15.935+08:00| 1|
32.283|show queries|root|
-+-----------------------+-----------------------------+-----------+------------+------------+----+
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+| query_id|
start_time|datanode_id|elapsed_time|
statement|user|wait_time_in_server|client_ip|timeout|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
+|20260601_032051_00016_1|2026-06-01T11:20:51.130+08:00| 1|
0.017|SHOW QUERIES WHERE elapsed_time > 0.003|root|
0.0190219|127.0.0.1| 60000|
++-----------------------+-----------------------------+-----------+------------+---------------------------------------+----+-------------------+---------+-------+
```
### 1.9 查看分区信息
diff --git
a/src/zh/UserGuide/latest/User-Manual/Maintenance-statement_apache.md
b/src/zh/UserGuide/latest/User-Manual/Maintenance-statement_apache.md
index ac80d3f3..1ab88572 100644
--- a/src/zh/UserGuide/latest/User-Manual/Maintenance-statement_apache.md
+++ b/src/zh/UserGuide/latest/User-Manual/Maintenance-statement_apache.md
@@ -194,6 +194,9 @@ showQueriesStatement
- **datanodeid**：发起查询语句的 DataNode 的ID
- **elapsedtime**：查询的执行耗时，单位是秒
- **statement**：查询的 SQL 语句
+ - **WaitTimeInServer**：客户端请求在 server 等待结果返回的累计耗时，单位 s（V2.0.10 起支持）
+ - **ClientIp**：发起查询的客户端 ip（V2.0.10 起支持）
+ - **Timeout**：该查询的超时时间，单位 ms（V2.0.10 起支持）
#### 示例：
@@ -205,11 +208,11 @@ IoTDB> SHOW QUERIES WHERE elapsedtime > 0.003
执行结果如下：
```SQL
-+-----------------------------+-----------------------+----------+-----------+--------------------------------------+
-| Time| QueryId|DataNodeId|ElapsedTime|
Statement|
-+-----------------------------+-----------------------+----------+-----------+--------------------------------------+
-|2025-05-09T15:16:01.293+08:00|20250509_071601_00015_1| 1|
0.006|SHOW QUERIES WHERE elapsedtime > 0.003|
-+-----------------------------+-----------------------+----------+-----------+--------------------------------------+
++-----------------------------+-----------------------+----------+-----------+--------------------------------------+----------------+---------+-------+
+| Time| QueryId|DataNodeId|ElapsedTime|
Statement|WaitTimeInServer| ClientIp|Timeout|
++-----------------------------+-----------------------+----------+-----------+--------------------------------------+----------------+---------+-------+
+|2026-06-01T11:13:39.057+08:00|20260601_031339_00003_1| 1|
0.074|SHOW QUERIES WHERE elapsedtime > 0.003| 0.0736961|127.0.0.1| 60000|
++-----------------------------+-----------------------+----------+-----------+--------------------------------------+----------------+---------+-------+
```
