This is the command pgfouine that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator
PROGRAM:
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
Use pgfouine online using onworks.net services