PostgreSQL 日志分析，pgBadger 2.0 发布

   <p><a href="/misc/goto?guid=4958347507050366794" target="_blank">pgBadger </a>是一个 PostgreSQL 数据库日志分析程序，可生成详细的报表和图表，旨在替换 pgFouine 脚本。</p>    <p>pgBadger能够报告关于SQL查询所有事情：</p>    <ul>     <li>Overall statistics.</li>     <li>The slowest queries.</li>     <li>Queries that took up the most time.</li>     <li>The most frequent queries.</li>     <li>The most frequent errors.</li>    </ul>    <p>The following reports are also available with hourly charts:</p>    <ul>     <li>Hourly queries statistics.</li>     <li>Hourly temporary file statistics.</li>     <li>Hourly checkpoints statistics.</li>     <li>Locks statistics.</li>     <li>Queries by type (select/insert/update/delete).</li>     <li>Sessions per database/user/client.</li>     <li>Connections per database/user/client.</li>    </ul>    <p><a href="/misc/goto?guid=4958347507050366794" target="_blank">pgBadger </a>2.0 发布，这是一个新的版本支持增量日志分析统计，避免对老数据进行重复计算；另外完全重写了 CSV 日志解析器。</p>    <p><img alt="PostgreSQL 日志分析，pgBadger 2.0 发布" src="https://simg.open-open.com/show/3fc668fbe19b4714321a69b068deae2a.png" width="500" height="590" /></p>