table of contents
other versions
- bullseye 1.0.1-1+b1
- testing 1.2.0-1
- unstable 1.2.0-1
- experimental 1.2.0-2
PGSTAT(1) | User Commands | PGSTAT(1) |
NAME¶
pgstat - Gather statistical informations from PostgreSQL the vmstat way
DESCRIPTION¶
pgstat gathers statistics from a PostgreSQL database.
Usage:¶
- pgstat [OPTIONS] [delay [count]]
General options:¶
Connection options:¶
- -h HOSTNAME
- database server host or socket directory
- -p PORT
- database server port number
- -U USER
- connect as specified database user
- -d DBNAME
- 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
REPORTING BUGS¶
Report bugs to <guillaume@lelarge.info>.
August 2019 | pgstat 1.0.1 |