.\" DO NOT MODIFY THIS FILE!  It was generated by help2man 1.36.
.TH pgfouine "1" "August 2006" "pgfouine " "User Commands"
.SH NAME
pgfouine \- PostgreSQL log analyzer
.SH SYNOPSIS
.B pgfouine
\fI-file <file> \fR[\fI-top <n>\fR] [\fI-format <format>\fR] [\fI-logtype <logtype>\fR] [\fI-report \fR[\fIoutputfile=\fR]\fI<block1,block2>\fR]
.SH DESCRIPTION
.TP
\fB\-file\fR <file>
log file to analyze
.TP
\-
read the log from stdin instead of \fB\-file\fR
.TP
\fB\-top\fR <n>
number of queries in lists. Default is 20.
.TP
\fB\-format\fR <format>
output format: html, html\-with\-graphs or text. Default is html.
.TP
\fB\-logtype\fR <logtype>
log type: syslog or stderr. Default is syslog.
for stderr, you have to use the following log_line_prefix: '%t [%p]: [%l\-1] '
.TP
\fB\-report\fR [outputfile=]<block1,block2>
list of report blocks separated by a comma
report blocks can be: overall, hourly, bytype, slowest, n\-mosttime,
n\-mostfrequent, n\-slowestaverage, history, n\-mostfrequenterrors,
tsung
.IP
You can add several \fB\-report\fR options if you want to generate
several reports at once
.TP
\fB\-examples\fR <n>
maximum number of examples for a normalized query
.TP
\fB\-onlyselect\fR
ignore all queries but SELECT
.TP
\fB\-from\fR "<date>"
ignore lines logged before this date (uses strtotime)
.TP
\fB\-to\fR "<date>"
ignore lines logged after this date (uses strtotime)
.TP
\fB\-database\fR <database>
consider only queries on this database
.TP
\fB\-user\fR <user>
consider only queries executed by this user
.TP
\fB\-title\fR <title>
define the title of the reports
.TP
\fB\-syslogident\fR <ident>
PostgreSQL syslog identity. Default is postgres.
.TP
\fB\-memorylimit\fR <n>
PHP memory limit in MB. Default is 128.
.TP
\fB\-debug\fR
debug mode
.TP
\fB\-profile\fR
profile mode
.TP
\fB\-help\fR
this help
.SH "AUTHOR"
.I pgfouine
was written by Guillaume Smet <guillaume-pg at smet dot org>.
.TP
This manpage was written by Clement Stenac <zorglub at debian dot org> for the Debian project, but may be used by others.