pg_top 实时监控工具

蔚落 2022-12-24 08:55 151阅读 0赞

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

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2N0eXB5YjIwMDI_size_16_color_FFFFFF_t_70]

参考:  
https://gitlab.com/pg\_top/pg\_top

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2N0eXB5YjIwMDI_size_16_color_FFFFFF_t_70]: /images/20221120/5f5d525ee4eb4692abbe60d92be00ac9.png