SHOW PROCESSLIST

功能描述

查当前外部连接（或内部线程）相关信息。

注意事项

• Id字段对应pg_stat_activity视图中的sessionid
• Info字段记录的是该连接最后一次执行的SQL，这和B数据库有一些差异（B数据库显示当前执行中的SQL），但可以结合State字段查看SQL是否是在执行中，State字段为active时，对应Info字段的SQL则在执行中。

语法格式

1. SHOW [FULL] PROCESSLIST

参数说明

• FULL

``` 1. 不使用FULL选项，Info字段只展示SQL长度不超过100的部分。

1. 使用FULL选项，Info字段可完全展示长度不超过1024的SQL语句，如果SQL长度超过1024，会截断1024长度之外的部分。 ```

示例

1. --方式1
2. openGauss=# show processlist;
3. Id        |       Pid       |      QueryId      | UniqueSqlId |   User    | Host |    db    |        Command         |
4. BackendStart          |           XactStart           |  Time  | State  |                  Info
5. -----------------+-----------------+-------------------+-------------+-----------+------+----------+------------------------+---
6. ----------------------------+-------------------------------+--------+--------+----------------------------------------
7. 139653370304256 | 139653370304256 |                 0 |           0 | opengauss |      | postgres | ApplyLauncher          | 20
8. 22-06-21 16:46:19.656076+08 |                               |        |        |
9. 139653319255808 | 139653319255808 |                 0 |           0 | opengauss |      | postgres | Asp                    | 20
10. 22-06-21 16:46:19.728521+08 |                               |      1 | active |
11. 139653336483584 | 139653336483584 |                 0 |           0 | opengauss |      | postgres | PercentileJob          | 20
12. 22-06-21 16:46:19.728527+08 |                               |      8 | active |
13. 139653302175488 | 139653302175488 |                 0 |           0 | opengauss |      | postgres | statement flush thread | 20
14. 22-06-21 16:46:19.728558+08 |                               | 508507 | idle   |
15. 139653198239488 | 139653198239488 |                 0 |           0 | opengauss |      | postgres | WorkloadMonitor        | 20
16. 22-06-21 16:46:19.750133+08 |                               |        |        |
17. 139653181298432 | 139653181298432 |                 0 |           0 | opengauss |      | postgres | WLMArbiter             | 20
18. 22-06-21 16:46:19.750976+08 |                               |        |        |
19. 139653215110912 | 139653215110912 |                 0 |           0 | opengauss |      | postgres | workload               | 20
20. 22-06-21 16:46:19.754504+08 | 2022-06-21 16:46:19.769585+08 | 508507 | active | WLM fetch collect info from data nodes
21. 139653421840128 | 139653421840128 |                 0 |           0 | opengauss |      | postgres | JobScheduler           | 20
22. 22-06-27 10:00:54.754007+08 |                               |      0 | active |
23. 139653044328192 | 139653044328192 | 48976645947655327 |  1772643515 | opengauss | -1   | dolphin  | gsql                   | 20
24. 22-06-27 14:00:53.163338+08 | 2022-06-27 14:01:26.794658+08 |      0 | active | show processlist;
25. 139653027546880 | 139653027546880 | 48976645947655326 |  1775585557 | opengauss | -1   | postgres | gsql                   | 20
26. 22-06-27 14:01:03.969962+08 | 2022-06-27 14:01:19.967521+08 |      7 | active | select pg_sleep(100);
27. (10 rows)

29. --方式2
30. openGauss=# show full processlist;
31. Id        |       Pid       |      QueryId      | UniqueSqlId |   User    | Host |    db    |        Command         |
32. BackendStart          |           XactStart           |  Time  | State  |                  Info
33. -----------------+-----------------+-------------------+-------------+-----------+------+----------+------------------------+---
34. ----------------------------+-------------------------------+--------+--------+----------------------------------------
35. 139653370304256 | 139653370304256 |                 0 |           0 | opengauss |      | postgres | ApplyLauncher          | 20
36. 22-06-21 16:46:19.656076+08 |                               |        |        |
37. 139653319255808 | 139653319255808 |                 0 |           0 | opengauss |      | postgres | Asp                    | 20
38. 22-06-21 16:46:19.728521+08 |                               |      1 | active |
39. 139653336483584 | 139653336483584 |                 0 |           0 | opengauss |      | postgres | PercentileJob          | 20
40. 22-06-21 16:46:19.728527+08 |                               |      8 | active |
41. 139653302175488 | 139653302175488 |                 0 |           0 | opengauss |      | postgres | statement flush thread | 20
42. 22-06-21 16:46:19.728558+08 |                               | 508507 | idle   |
43. 139653198239488 | 139653198239488 |                 0 |           0 | opengauss |      | postgres | WorkloadMonitor        | 20
44. 22-06-21 16:46:19.750133+08 |                               |        |        |
45. 139653181298432 | 139653181298432 |                 0 |           0 | opengauss |      | postgres | WLMArbiter             | 20
46. 22-06-21 16:46:19.750976+08 |                               |        |        |
47. 139653215110912 | 139653215110912 |                 0 |           0 | opengauss |      | postgres | workload               | 20
48. 22-06-21 16:46:19.754504+08 | 2022-06-21 16:46:19.769585+08 | 508507 | active | WLM fetch collect info from data nodes
49. 139653421840128 | 139653421840128 |                 0 |           0 | opengauss |      | postgres | JobScheduler           | 20
50. 22-06-27 10:00:54.754007+08 |                               |      0 | active |
51. 139653044328192 | 139653044328192 | 48976645947655327 |  1772643515 | opengauss | -1   | dolphin  | gsql                   | 20
52. 22-06-27 14:00:53.163338+08 | 2022-06-27 14:01:26.794658+08 |      0 | active | show processlist;
53. 139653027546880 | 139653027546880 | 48976645947655326 |  1775585557 | opengauss | -1   | postgres | gsql                   | 20
54. 22-06-27 14:01:03.969962+08 | 2022-06-27 14:01:19.967521+08 |      7 | active | select pg_sleep(100);
55. (10 rows)

相关链接

N/A