Linux中提供了watch用于每隔n秒查看命令的输出，与PG的客户端工具结合起来可以监控数据库的活动信息。
实际上PG客户端也提供了watch工具每隔n秒监控命令的输出。
OS watch
[gauss2@k8s-master ~]$ gsql -r -d postgres -c "select version();"
version
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 9.2.4 (openGauss 2.0.0 build 4b6ee85b) compiled at 2021-05-13 18:07:53 commit 0 last mr debug on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit
(1 row)
[gauss2@k8s-master ~]$ watch -n 0.5 'gsql -r -d postgres -c "select datname,pid,sessionid,query from pg_stat_activity;"'
#命令输出
Every 0.5s: gsql -r -d postgres -c "select datname,pid,sessionid,query from pg_stat_activity;" Fri Sep 17 14:57:31 2021
datname | pid | sessionid | query
----------+-----------------+-----------------+-----------------------------------------------------------
postgres | 139668357572352 | 320 | select datname,pid,sessionid,query from pg_stat_activity;
postgres | 139663247058688 | 139663247058688 |
postgres | 139663098095360 | 139663098095360 |
postgres | 139663114876672 | 139663114876672 |
postgres | 139663131657984 | 139663131657984 | WLM fetch collect info from data nodes
postgres | 139663230277376 | 139663230277376 |
postgres | 139663213496064 | 139663213496064 |
postgres | 139663263840000 | 139663263840000 |
postgres | 139663297402624 | 139663297402624 |
(9 rows)
PG 13 watch
testdb=# select datname,pid,query from pg_stat_activity;\watch 5
datname | pid | query
---------+------+-------------------------------------------------
| 2209 |
| 2211 |
testdb | 2214 | select datname,pid,query from pg_stat_activity;
| 2207 |
| 2206 |
| 2208 |
(6 rows)
Fri 17 Sep 2021 02:59:13 PM CST (every 5s)
datname | pid | query
---------+------+-------------------------------------------------
| 2209 |
| 2211 |
testdb | 2214 | select datname,pid,query from pg_stat_activity;
| 2207 |
| 2206 |
| 2208 |
(6 rows)
......