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

PostgreSQL 日志分析工具,pgBadger 7.0 发布,

来自:http://www.oschina.net/news/62394/pgbadger-7-0-postgresql-log-analyzer