pgBadger - 一个快速的PostgreSQL日志分析器

jopen 11年前

pgBadger是一个快速的PostgreSQL日志分析器,能够输出PostgreSQL日志文件的完整详细的报告。它是一个只有一个文件的Perl脚本,用于代替旧的PHP脚本 pgFouine

Features

pgBadger报告你SQL查询的一切:

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

下面的报告是分时走势图:

  • 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://www.open-open.com/lib/view/home/1358989651833