NAME

       pgfouine - PostgreSQL log analyzer

SYNOPSIS

       pgfouine  -file  <file>  [-top  <n>]  [-format  <format>]  [-logtype  <logtype>]  [-report
       [outputfile=]<block1,block2>]

DESCRIPTION

       -file <file>
              log file to analyze

       -      read the log from stdin instead of -file

       -top <n>
              number of queries in lists. Default is 20.

       -format <format>
              output format: html, html-with-graphs or text. Default is html.

       -logtype <logtype>
              log type: syslog or stderr. Default is syslog.  for stderr, you  have  to  use  the
              following log_line_prefix: '%t [%p]: [%l-1] '

       -report [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

              You can add several -report options if you want to generate several reports at once

       -examples <n>
              maximum number of examples for a normalized query

       -onlyselect
              ignore all queries but SELECT

       -from "<date>"
              ignore lines logged before this date (uses strtotime)

       -to "<date>"
              ignore lines logged after this date (uses strtotime)

       -database <database>
              consider only queries on this database

       -user <user>
              consider only queries executed by this user

       -title <title>
              define the title of the reports

       -syslogident <ident>
              PostgreSQL syslog identity. Default is postgres.

       -memorylimit <n>
              PHP memory limit in MB. Default is 128.

       -debug debug mode

       -profile
              profile mode

       -help  this help

AUTHOR

       pgfouine was written by Guillaume Smet <guillaume-pg at smet dot org>.

       This  manpage  was  written  by  Clement Stenac <zorglub at debian dot org> for the Debian
       project, but may be used by others.