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 executions, number of disk reads, and so on).
Is there a similar tool 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 executions, number of disk reads, and so on).
Is there a similar tool for Postgresql?
Not an HTML-report, but a top-like tool for pgsql: http://ptop.projects.postgresql.org/
And another one - pgFouine.
Also take a look at what's under Database Administration on PgFoundry.