PostgreSQL 日志分析工具,pgBadger 7.0 发布
jopen 10年前
pgBadger 是一个 PostgreSQL 数据库日志分析程序,可生成详细的报表和图表,旨在替换 pgFouine 脚本。
pgBadger 7.0 发布了,该版本包含更多有用的报表和特性,支持 auto_explain 扩展,新的报表包括:
-
Events (panic, fatal, error and warning) distribution per 5 minutes.
-
每个应用详情 (total duration and times executed) for each query reported in Top Queries. The details are visible from a button called "App(s) involved".
-
每个用户的累积查询时间
关于在第二个集群中被取消查询的报表:
-
Number of cancelled queries (graph)
-
Queries generating the most cancellation (N)
-
Queries most cancelled.
完整列表请看 https://github.com/dalibo/pgbadger/blob/master/ChangeLog
查看示例报表:http://projects.dalibo.org/pgbadger/example.html
来自:http://www.oschina.net/news/62394/pgbadger-7-0-postgresql-log-analyzer