os: centos 7.9.2009
db: postgresql 14.7

安装依赖包

sudo yum install libbsd libbsd-devel

下载安装

su - pgsql

wget https://gitlab.com/pg_top/pg_top/-/archive/main/pg_top-main.tar.gz


tar -zxvf ./pg_top-main.tar.gz


cd pg_top-main


cmake -DCMAKE_INSTALL_PREFIX=/data/pgsql/14 CMakeLists.txt


make install

$ pg_top --help
pg_top monitors a PostgreSQL database cluster.

Usage:
  pg_top [OPTION]... [COUNT]

General options:
  -b, --batch               use batch mode
  -c, --show-command        display command name of each process
  -C, --color-mode          turn off color mode
  -i, --interactive         use interactive mode
  -I, --hide-idle           hide idle processes
  -n, --non-interactive     use non-interactive mode
  -o, --order-field=FIELD   select sort order
  -r, --remote-mode         activate remote mode
  -R                        display replication stats
  -s, --set-delay=SECOND    set delay between screen updates
  -T, --show-tags           show color tags
  -V, --version             output version information, then exit
  -x, --set-display=COUNT   set maximum number of displays
                            exit once this number is reached
  -X                        display i/o stats
  -z, --show-username=NAME  display only processes owned by given
                            username
  -?, --help                show this help, then exit

Connection options:
  -d, --dbname=DBNAME       database to connect to
  -h, --host=HOSTNAME       database server host or socket directory
  -p, --port=PORT           database server port
  -U, --username=USERNAME   user name to connect as
  -W, --password            force password prompt, and persistent connection

参考
https://gitlab.com/pg_top/pg_top