SHOW QUERIES

SHOW QUERIES语句可以查看当前Session中正在执行的查询请求信息。

Note

如果需要终止查询，请参见终止查询。

注意事项

  • SHOW QUERIES从本地缓存获取当前Session中查询的状态，几乎没有延迟。

  • SHOW ALL QUERIES从Meta服务获取所有Session中的查询信息。这些信息会根据参数session_reclaim_interval_secs定义的周期同步到Meta服务，因此在客户端获取到的信息可能属于上个同步周期。

语法

  1. SHOW [ALL] QUERIES;

示例

  1. nebula> SHOW QUERIES;
  2. +------------------+-----------------+--------+----------------------+----------------------------+----------------+-----------+-----------------+
  3. | SessionID        | ExecutionPlanID | User   | Host                 | StartTime                  | DurationInUSec | Status    | Query           |
  4. +------------------+-----------------+--------+----------------------+----------------------------+----------------+-----------+-----------------+
  5. | 1625463842921750 | 46              | "root" | ""192.168.x.x":9669" | 2021-07-05T05:44:19.502903 | 0              | "RUNNING" | "SHOW QUERIES;" |
  6. +------------------+-----------------+--------+----------------------+----------------------------+----------------+-----------+-----------------+
  8. nebula> SHOW ALL QUERIES;
  9. +------------------+-----------------+---------+----------------------+----------------------------+----------------+-----------+---------------------------------------------------------+
  10. | SessionID        | ExecutionPlanID | User    | Host                 | StartTime                  | DurationInUSec | Status    | Query                                                   |
  11. +------------------+-----------------+---------+----------------------+----------------------------+----------------+-----------+---------------------------------------------------------+
  12. | 1625456037718757 | 54              | "user1" | ""192.168.x.x":9669" | 2021-07-05T05:51:08.691318 | 1504502        | "RUNNING" | "MATCH p=(v:player)-[*1..4]-(v2) RETURN v2 AS Friends;" |
  13. +------------------+-----------------+---------+----------------------+----------------------------+----------------+-----------+---------------------------------------------------------+
  15. # 返回耗时TOP 10的查询。
  16. nebula> SHOW ALL QUERIES | ORDER BY $-.DurationInUSec DESC | LIMIT 10;
  17. +------------------+-----------------+---------+----------------------+----------------------------+----------------+-----------+-------------------------------------------------------+
  18. | SessionID        | ExecutionPlanID | User    | Host                 | StartTime                  | DurationInUSec | Status    | Query                                                 |
  19. +------------------+-----------------+---------+----------------------+----------------------------+----------------+-----------+-------------------------------------------------------+
  20. | 1625471375320831 | 98              | "user2" | ""192.168.x.x":9669" | 2021-07-05T07:50:24.461779 | 2608176        | "RUNNING" | "MATCH (v:player)-[*1..4]-(v2) RETURN v2 AS Friends;" |
  21. | 1625456037718757 | 99              | "user1" | ""192.168.x.x":9669" | 2021-07-05T07:50:24.910616 | 2159333        | "RUNNING" | "MATCH (v:player)-[*1..4]-(v2) RETURN v2 AS Friends;" |
  22. +------------------+-----------------+---------+----------------------+----------------------------+----------------+-----------+-------------------------------------------------------+

参数说明如下。

参数说明
SessionID会话ID。
ExecutionPlanID执行计划ID。
User执行查询的用户名。
Host用户连接的服务器地址和端口。
StartTime执行查询的开始时间。
DurationInUSec执行查询的持续时长。单位：微秒。
Status查询的当前状态。
Query查询语句。

最后更新: October 27, 2021