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的部分。
    3.  使用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