xenial (1) pgfouine.1.gz

Provided by: pgfouine_1.2-3ubuntu1_all bug

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.