views:

119

answers:

3

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?

+1  A: 

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

The MYYN
+2  A: 

And another one - pgFouine.

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

Milen A. Radev
A: 

I found another one that looks promising: pgstatspack

Thilo