背景
PostgreSQL 的统计信息、实时会话信息、操作系统状态信息等汇总,统计,展示。
https://www.postgresql.org/docs/devel/static/monitoring-stats.html
1 pgcenter
https://github.com/lesovsky/pgcenter
Command-line admin tool for observing and troubleshooting Postgres.
wget https://github.com/lesovsky/pgcenter/releases/download/v0.5.0/pgcenter.linux-amd64.tar.gz
pgCenter is a command line admin tool for PostgreSQL.
Usage:
pgcenter [flags]
pgcenter [command] [command-flags] [args]
Available commands:
config configures Postgres to work with pgcenter
record record stats to file
report make report based on previously saved statistics
top top-like stats viewer
Flags:
-?, --help show this help and exit
--version show version information and exit
Use "pgcenter [command] --help" for more information about a command.
Report bugs to https://github.com/lesovsky/pgcenter/issues
./pgcenter -p 1921 top
2 pg_top
https://git.postgresql.org/gitweb/?p=pg_top.git;a=shortlog;h=refs/heads/master
pg_top
Version 3.7.0
Mark Wong
and a cast of ... a few
pg_top is 'top' for PostgreSQL. It is derived from Unix Top. Similar to top,
pg_top allows you to monitor PostgreSQL processes. It also allows you to:
* View currently running SQL statement of a process.
* View query plan of a currently running SELECT statement.
* View locks held by a process.
* View user table statistics.
* View user index statistics.
CAVEAT: version 3 of pg_top has internal commands that kill and renice
- Although I have taken steps to insure that pg_top makes
- checks with these commands, I cannot guarantee that these
internal commands are totally secure. IF YOU INSTALL pg_top SET-USER-ID
TO ROOT, YOU DO SO AT YOUR OWN RISK! I realize that some operating
systems will require pg_top to run setuid root, and I will do everything
I can to make sure that pg_top is a secure setuid program.
To compile and install "pg_top", read the file "INSTALL" and follow the
directions and advice contained therein.
If you make any kind of change to "pg_top" that you feel would be
beneficial to others who use this program, or if you find and fix a bug,
please send the change to the pg_top mailing list.
In order to monitor a remote database, the pg_proctab extension needs to be
created on the database to be monitored. Any operating system that pg_proctab
supports can be monitored remotely on any operating system. See details for
pg_protab here:
http://pgxn.org/dist/pg_proctab/
Be sure to read the FAQ enclosed with the distrubution. It contains
answers to the most commonly asked questions about the configuration,
installation, and operation of pg_top.
AVAILABILITY
Project home page:
http://ptop.projects.postgresql.org/
If you have git, you can download the source code:
git clone git://git.postgresql.org/git/pg_top.git
GRATITUDE
Selena Deckelmann & Gabrielle Roth, and the beer & free wi-fi at County Cork
pub in Portland, OR, USA.
LICENSE
pg_top is distributed free of charge under the same terms as the BSD
- For an official statement, please refer to the file "LICENSE"
- should be included with the source distribution.
AUTHOR
Mark Wong
yum install -y cmake3
su - postgres
https://git.postgresql.org/gitweb/?p=pg_top.git;a=shortlog;h=refs/heads/master
tar -zxvf pg_top-72088ce.tar.gz
cd pg_top-72088ce
alias cmake=cmake3
cmake -DDESTDIR=/var/lib/pgsql/pg_top
make install
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
参考
https://git.postgresql.org/gitweb/?p=pg_top.git;a=shortlog;h=refs/heads/master
https://github.com/lesovsky/pgcenter
man pg_top/share/man/man1/pg_top.1
https://www.postgresql.org/docs/devel/static/monitoring-stats.html
转自阿里云德哥