PostgreSQL 日志统计工具，pgBadger 1.1 发布

   <p><a href="/misc/goto?guid=4958347507050366794" target="_blank">pgBadger </a>1.1 发布了，pgBadger 是一个 PostgreSQL 数据库日志分析程序，可生成详细的报表和图表，旨在替换 pgFouine 脚本。</p>    <p>pgBadger reports everything about your SQL queries:</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>查看示例报表：http://projects.dalibo.org/pgbadger/example.html</p>    <p><img alt="PostgreSQL 日志统计工具，pgBadger 1.1 发布" src="https://simg.open-open.com/show/3fc668fbe19b4714321a69b068deae2a.png" width="500" height="590" /></p>    <p>新版本改进记录：</p>    <p><strong>New features:</strong><br /> <br /> - Add possibility to get log from stdin<br /> - Change syslog parsing regex to allow log timestamp in log_line_prefix very often forgotten when log destination is changed from stderr to syslog.<br /> - Add documentation for the -z | --zcat command line option.<br /> - Allow `zcat` location to be specified via `--zcat` - David E. Wheeler<br /> - Add --disable-session,--disable-connection and disable-checkpoint command line options to remove<br />   their respective reports from the output    <br /> - Add --disable-query command line option to remove queries statistics from the output<br /> - Add --disable-hourly command line option to remove hourly statistics from the output<br /> - Add --disable-error command line option to remove error report from the output<br /> - Add --exclude-query option to exclude types of queries by specifying a regex<br /> - Set thousand separator and decimal separator to be locale dependant<br /> - Add -w option to only report errors<br /> - Add Makefile.PL and full POD documentation to the project<br /> - Allow multiple log files from command line<br /> - Add simple csvlog support - Alex Hunsaker<br /> - Hourly report for temporary files and checkpoints have moved in a separate table.<br /> - Add hourly connections and sessions statistics.<br /> - Add a chart about the number of connections per seconds.<br /> <br /> <strong>Bug fix:</strong><br /> <br /> - Add information about log format requirement (lc_message = 'C') - Reported by Alain Benard.<br /> - Fix for begin/end dates with single digit day using syslog - Patch by Joseph Marlin.<br /> - Fix handle of syslog dates with single-digit day number - Patch by Denis Orlikhin.<br /> - Fix many English syntax in error messages and documentation - Patch by Joseph Marlin.<br /> - Fix non terminated TH html tag in checkpoint hourly table - Reported by Joseph Marlin.<br /> - "Log file" section will now only report first and last log file parsed<br /> - Fix empty output in hourly temporary file stats.<br /> - Fix wrapping query that goes out of the table and makes the window scroll horizontally - Asked by Isaac Reuben.<br /> - Fix code where != was replaced by $$CLASSSY0A$$!=$$CLASSSY0B$$ in the output. - Reported by Isaac Reuben<br /> - Fix and review text report output.<br /> - Fix an issue in SQL code highligh replacement.<br /> - Complete review of the HTML output. <br /> - Add .gitignore for swap files - patch by Vincent Picavet<br /> - Fix wrong variable for user and database filter - patch by Vincent Picavet.<br /> - Change default regexp for user and db to be able to detect both - patch by Vincent Picavet.<br /> - Fix false cur_date when using syslog and allow -b and -e options to work - patch by Vincent Picavet.<br /> - Fix some case where log line where not detected as PostgreSQL log lines.<br /> - Added explanation for --begin and --end datetime setting. And added -v / --version - Patch by ragged.<br /> - Fix usage information and presentation in README file.</p>