This is an automated email from the ASF dual-hosted git repository.
qiaojialin pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/iotdb.git
The following commit(s) were added to refs/heads/master by this push:
new 907cb53d99 Modify doc of 'Show Queries' with more accurate description
(#8989)
907cb53d99 is described below
commit 907cb53d991761e6bc1999b936f772a450a58c79
Author: Weihao Li <[email protected]>
AuthorDate: Mon Feb 6 17:39:48 2023 +0800
Modify doc of 'Show Queries' with more accurate description (#8989)
---
docs/UserGuide/Maintenance-Tools/Maintenance-Command.md | 9 +++++++--
docs/zh/UserGuide/Maintenance-Tools/Maintenance-Command.md | 9 +++++++--
2 files changed, 14 insertions(+), 4 deletions(-)
diff --git a/docs/UserGuide/Maintenance-Tools/Maintenance-Command.md
b/docs/UserGuide/Maintenance-Tools/Maintenance-Command.md
index da03e2fd66..eeb441de97 100644
--- a/docs/UserGuide/Maintenance-Tools/Maintenance-Command.md
+++ b/docs/UserGuide/Maintenance-Tools/Maintenance-Command.md
@@ -134,9 +134,9 @@ Note：
### ResultSet
Time：Start time of query，DataType is `INT64`
-QueryId：Cluster - level unique query identifier，DataType is `TEXT`
+QueryId：Cluster - level unique query identifier，DataType is `TEXT`, format is
`yyyyMMdd_HHmmss_index_dataNodeId`
DataNodeId：DataNode which do execution of query，DataType is `INT32`
-ElapsedTime：Execution time of query，`second` for unit，DataType is `FLOAT`
+ElapsedTime：Execution time of query (Imperfectly accurate)，`second` for
unit，DataType is `FLOAT`
Statement：Origin string of query，DataType is `TEXT`
```
@@ -177,6 +177,11 @@ SQL string：
SHOW QUERIES limit 5
```
+Equivalent to
+```SQL
+SHOW QUERIES ORDER BY ElapsedTime DESC limit 5
+```
+
SQL result：
```
+-----------------------------+-----------------------+----------+-----------+-----------------------------+
diff --git a/docs/zh/UserGuide/Maintenance-Tools/Maintenance-Command.md
b/docs/zh/UserGuide/Maintenance-Tools/Maintenance-Command.md
index 2cc895eba2..61759ce3f5 100644
--- a/docs/zh/UserGuide/Maintenance-Tools/Maintenance-Command.md
+++ b/docs/zh/UserGuide/Maintenance-Tools/Maintenance-Command.md
@@ -132,9 +132,9 @@ SHOW QUERIES | (QUERY PROCESSLIST)
### 结果集
Time：查询开始时间，数据类型为`INT64`
-QueryId：集群级别唯一的查询标识，数据类型为`TEXT`
+QueryId：集群级别唯一的查询标识，数据类型为`TEXT`，格式为`yyyyMMdd_HHmmss_index_dataNodeId`
DataNodeId：执行该查询的节点，数据类型为`INT32`
-ElapsedTime：查询已执行时间，以`秒`为单位，数据类型为`FLOAT`
+ElapsedTime：查询已执行时间（不完全精确），以`秒`为单位，数据类型为`FLOAT`
Statement：查询的原始语句，数据类型为`TEXT`
```
@@ -175,6 +175,11 @@ SQL 语句为：
SHOW QUERIES limit 5
```
+等价于
+```SQL
+SHOW QUERIES ORDER BY ElapsedTime DESC limit 5
+```
+
该 SQL 语句的执行结果如下：
```
+-----------------------------+-----------------------+----------+-----------+-----------------------------+
