PostgreSQL 日志分析，pgBadger 2.0 發布

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

pgBadger能夠報告關于SQL查詢所有事情：

• 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.

pgBadger 2.0 發布，這是一個新的版本支持增量日志分析統計，避免對老數據進行重復計算；另外完全重寫了 CSV 日志解析器。