PostgreSQL 日志統計工具，pgBadger 1.1 發布

pgBadger 1.1 發布了，pgBadger 是一個 PostgreSQL 數據庫日志分析程序，可生成詳細的報表和圖表，旨在替換 pgFouine 腳本。

pgBadger reports everything about your SQL queries:

• Overall statistics.
• The slowest queries.
• Queries that took up the most time.
• The most frequent queries.
• The most frequent errors.

The following reports are also available with hourly charts:

• Hourly queries statistics.
• Hourly temporary file statistics.
• Hourly checkpoints statistics.
• Locks statistics.
• Queries by type (select/insert/update/delete).
• Sessions per database/user/client.
• Connections per database/user/client.

查看示例報表：http://projects.dalibo.org/pgbadger/example.html

新版本改進記錄：

New features:

- Add possibility to get log from stdin
- Change syslog parsing regex to allow log timestamp in log_line_prefix very often forgotten when log destination is changed from stderr to syslog.
- Add documentation for the -z | --zcat command line option.
- Allow `zcat` location to be specified via `--zcat` - David E. Wheeler
- Add --disable-session,--disable-connection and disable-checkpoint command line options to remove
  their respective reports from the output   
- Add --disable-query command line option to remove queries statistics from the output
- Add --disable-hourly command line option to remove hourly statistics from the output
- Add --disable-error command line option to remove error report from the output
- Add --exclude-query option to exclude types of queries by specifying a regex
- Set thousand separator and decimal separator to be locale dependant
- Add -w option to only report errors
- Add Makefile.PL and full POD documentation to the project
- Allow multiple log files from command line
- Add simple csvlog support - Alex Hunsaker
- Hourly report for temporary files and checkpoints have moved in a separate table.
- Add hourly connections and sessions statistics.
- Add a chart about the number of connections per seconds.

Bug fix:

- Add information about log format requirement (lc_message = 'C') - Reported by Alain Benard.
- Fix for begin/end dates with single digit day using syslog - Patch by Joseph Marlin.
- Fix handle of syslog dates with single-digit day number - Patch by Denis Orlikhin.
- Fix many English syntax in error messages and documentation - Patch by Joseph Marlin.
- Fix non terminated TH html tag in checkpoint hourly table - Reported by Joseph Marlin.
- "Log file" section will now only report first and last log file parsed
- Fix empty output in hourly temporary file stats.
- Fix wrapping query that goes out of the table and makes the window scroll horizontally - Asked by Isaac Reuben.
- Fix code where != was replaced by $$CLASSSY0A$$!=$$CLASSSY0B$$ in the output. - Reported by Isaac Reuben
- Fix and review text report output.
- Fix an issue in SQL code highligh replacement.
- Complete review of the HTML output.
- Add .gitignore for swap files - patch by Vincent Picavet
- Fix wrong variable for user and database filter - patch by Vincent Picavet.
- Change default regexp for user and db to be able to detect both - patch by Vincent Picavet.
- Fix false cur_date when using syslog and allow -b and -e options to work - patch by Vincent Picavet.
- Fix some case where log line where not detected as PostgreSQL log lines.
- Added explanation for --begin and --end datetime setting. And added -v / --version - Patch by ragged.
- Fix usage information and presentation in README file.