DOKK / manpages / debian 11 / pgstat / pgstat.1.en
PGSTAT(1) User Commands PGSTAT(1)

pgstat - Gather statistical informations from PostgreSQL the vmstat way

pgstat gathers statistics from a PostgreSQL database.

pgstat [OPTIONS] [delay [count]]

include only this object
display human-readable values
do not redisplay header
stats to collect
verbose
-?|--help
show this help, then exit
output version information, then exit

database server host or socket directory
database server port number
connect as specified database user
database to connect to

The default stat is pg_stat_bgwriter, but you can change it with the -s command line option, and one of its value (STAT):

* archiver
for pg_stat_archiver
* bgwriter
for pg_stat_bgwriter
* connection
(only for > 9.1)
* database
for pg_stat_database
* table
for pg_stat_all_tables
* tableio
for pg_statio_all_tables
* index
for pg_stat_all_indexes
* function
for pg_stat_user_function
* statement
for pg_stat_statements (needs the extension)
* xlog
for xlog writes (only for > 9.2)
* tempfile
for temporary file usage
* pbpools
for pgBouncer pools statistics
* pbstats
for pgBouncer statistics

Report bugs to <guillaume@lelarge.info>.

August 2019 pgstat 1.0.1