.\" DO NOT MODIFY THIS FILE!  It was generated by help2man 1.47.6.
.TH PGSTAT "1" "September 2018" "pgstat 1.0.1" "User Commands"
.SH NAME
pgstat \- Gather statistical informations from PostgreSQL the vmstat way
.SH DESCRIPTION
pgstat gathers statistics from a PostgreSQL database.
.SS "Usage:"
.IP
pgstat [OPTIONS] [delay [count]]
.SS "General options:"
.TP
\fB\-f\fR FILTER
include only this object
.TP
\fB\-H\fR
display human\-readable values
.TP
\fB\-n\fR
do not redisplay header
.TP
\fB\-s\fR STAT
stats to collect
.TP
\fB\-v\fR
verbose
.TP
\-?|\-\-help
show this help, then exit
.TP
\fB\-V\fR|\-\-version
output version information, then exit
.SS "Connection options:"
.TP
\fB\-h\fR HOSTNAME
database server host or socket directory
.TP
\fB\-p\fR PORT
database server port number
.TP
\fB\-U\fR USER
connect as specified database user
.TP
\fB\-d\fR DBNAME
database to connect to
.PP
The default stat is pg_stat_bgwriter, but you can change it with the \fB\-s\fR command line option,
and one of its value (STAT):
.TP
* archiver
for pg_stat_archiver
.TP
* bgwriter
for pg_stat_bgwriter
.TP
* connection
(only for > 9.1)
.TP
* database
for pg_stat_database
.TP
* table
for pg_stat_all_tables
.TP
* tableio
for pg_statio_all_tables
.TP
* index
for pg_stat_all_indexes
.TP
* function
for pg_stat_user_function
.TP
* statement
for pg_stat_statements (needs the extension)
.TP
* xlog
for xlog writes (only for > 9.2)
.TP
* tempfile
for temporary file usage
.TP
* pbpools
for pgBouncer pools statistics
.TP
* pbstats
for pgBouncer statistics
.SH "REPORTING BUGS"
Report bugs to <guillaume@lelarge.info>.