[PostgreSQL/PPAS] 利用 pgBadger 來分析 Postgres log file

1.下載pgBadger,並解壓
# tar -zxvf pgbadger-3.6.tar.gz

2.安裝(optional)
# cd pgbadger-3.6
# perl Makefile.PL
# make && make install

3.執行
./pgbadger --prefix 'postgresql.conf裡面log_line_prefix的值 ' /path/to/your/pglog/*.log -o out.html

4.用browser看結果囉!!