发布于 2017-01-28 00:33:18 | 87 次阅读 | 评论: 0 | 来源: 网友投递
pgBadger PostgreSQL日志分析程序
pgBadger 是一个 PostgreSQL 数据库日志分析程序，可生成详细的报表和图表，旨在替换 pgFouine 脚本。
pgBadger 9.1 发布了。该版本是一个常规维护版本，修复了一些小问题，还有一个关于错误类的分布和一些功能的增强。
当 SQLState 在 log_line_prefix 中可用时，添加错误类分布的报告（参阅 ％e 占位符）。
将 SQL Beautifier 更新至 pgFormatter v1.6 代码
改进错误消息规范化
添加 --normalized-only 选项以生成包含在带有 count 的日志中找到的所有规范化查询的文本文件
允许 %c (会话 id) 将 %p (pid) 替换为唯一会话 ID
为锁定消息添加等待到事件报告
添加 --start-monday 选项以在周一开始日历周，而不是默认的周日
下面是完整的变更内容
Add report of error class distribution when SQLState is available in the log line prefix. Thanks to jacks33 for the feature request.
Fix incremental global index on resize. Thanks to clomdd for the report.
Fix command tag log_line_prefix placeholder %i to allow space character.
Fix --exclude-line options and removing of obsolete directory when retention is enabled and --noreport is used.
Fix typo in "vacuum activity table". Thanks to Nicolas Gollet for the patch.
Fix autovacuum report. Thanks to Nicolas Gollet for the patch.
Fix author of pgbadger's logo - Damien Cazeils and English in comments. Thanks to Thibaut Madelaine for the patch.
Add information about pgbouncer log format in the -f option. Thanks to clomdd for the report.
Add --normalized-only information in documentation.
Fix broken report of date-time introduced in previous patch.
Fix duration/query association when log_duration=on and log_statement=all. Thanks to Eric Jensen for the report.
Fix normalization of messages about advisory lock. Thanks to Thibaut Madelaine for the report.
Fix report of auto_explain output. Thanks to fch77700 for the report.
Fix unwanted log format auto detection with log entry from stdin. Thanks to Jesus Adolfo Parra for the report.
Add left open parentheses to the "stop" chars of regex to look for db client in the prefix to handle the PostgreSQL client string format that includes source port. Thanks to Jon Nelson for the patch.
Fix some spelling errors. Thanks to Jon Nelson for the patch.
Allow %c (session id) to replace %p (pid) as unique session id. Thanks to Jerryliuk for the report.
Allow pgBadger to parse default log_line_prefix that will be probably used in 10.0: '%m [%p] '
Fix missing first line with interpreter call.
Fix missing Avg values in CSV report. Thanks to Yosuke Tomita for the report.
Fix error message in autodetect_format() method.
Add --start-monday option to start calendar weeks in Monday instead of default to Sunday. Thanks to Joosep Mae for the feature request.
Fix --histo-average option. Thanks to Yves Martin for the report.
Remove plural form of --ssh-option in documentation. Thanks to mark-a-s for the report.
Fix --exclude-time filter and rewrite code to skip unwanted line as well code to update the progress bar. Thanks to Michael Chesterton for the report.
Fix support to %r placeholder in prefix instead of %h.
下载地址