pgBadger - 一个快速的PostgreSQL日志分析器
jopen
12年前
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.