linux 编程 云计算 微软 Firefox google wordpress 程序员 java 开源 php Android Windows nginx mysql shell Ubuntu Python centos apache

PostgreSQL 日誌分析,pgBadger 2.0 發布

 

pgBadger 是一個 PostgreSQL 數據庫日誌分析程序,可生成詳細的報表和圖表,旨在替換 pgFouine 腳本。

pgBadger能夠報告關於SQL查詢所有事情:

Overall statistics.
The slowest queries.
Queries that took up the most time.
The most frequent queries.
The most frequent errors.
The following reports are also available with hourly charts:

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.
pgBadger 2.0 發布,這是一個新的版本支持增量日誌分析統計,避免對老數據進行重復計算;另外完全重寫了 CSV 日誌解析器。

PostgreSQL 日志分析,pgBadger 2.0 发布

 

延伸阅读

    评论