pg_top 实时监控工具

os: centos 7.4
db: postgresql 11.9

版本

# cat /etc/centos-release
CentOS Linux release 7.4.1708 (Core) 
#
# su - postgres
Last login: Tue Oct 22 13:56:27 CST 2019 on pts/0
$
$ psql -c "select version();"
                                                 version                                                 
---------------------------------------------------------------------------------------------------------
 PostgreSQL 11.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
(1 row)

下载安装

# yum install -y pg_top

# rpm -ql pg_top
/usr/bin/pg_top
/usr/share/doc/pg_top-3.7.0
/usr/share/doc/pg_top-3.7.0/FAQ
/usr/share/doc/pg_top-3.7.0/HISTORY
/usr/share/doc/pg_top-3.7.0/LICENSE
/usr/share/doc/pg_top-3.7.0/README
/usr/share/doc/pg_top-3.7.0/TODO
/usr/share/doc/pg_top-3.7.0/Y2K
/usr/share/man/man1/pg_top.1.gz

初步使用

# su - postgres

$ which pg_top
/bin/pg_top

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

Usage:
  pg_top [OPTION]... [NUMBER]

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
  -q, --quick-mode          modify schedule priority
                            usable only by root
  -r, --remote-mode         activate remote mode
  -s, --set-delay=SECOND    set delay between screen updates
  -T, --show-tags           show color tags
  -u, --show-uid            show UID instead of username
  -V, --version             output version information, then exit
  -x, --set-display=COUNT   set maximum number of displays
                            exit once this number is reached
  -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 

$ pg_top

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