parse postgres log, check report, optimize queries.
Enterprise Postgres Query Analyser
an enterprise solution
pqa vs epqa
While comparing with pqa, it completes its job much earlier with less effort. It parses gzip logs without uncompressing and storing in disk.
Both gives similar kind of report.