Performance report for Postgresql

Oracle creates nicely HTML-formatted workload reports (AWR) that list things like instance statistics, wait events, the top ten heavy SQL statements (by number of e开发者_C百科xecutions, number of disk reads, and so on).

Is there a similar tool for Postgresql?

And another one - pgFouine.

Also take a look at what's under Database Administration on PgFoundry.

Not an HTML-report, but a top-like tool for pgsql: http://ptop.projects.postgresql.org/

The description says: "PoWA is PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graphs to help monitor and tune your PostgreSQL servers.

It is similar to Oracle AWR or SQL Server MDW."

http://dalibo.github.io/powa/

I found another one that looks promising: pgstatspack.

Also http://www.postgrestats.com/