Performance report for Postgresql

Question

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?

score 2 · Accepted Answer · answered Nov 30 '09 at 10:52

2

And another one - pgFouine.

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

answered Nov 30 '09 at 10:52

Milen A. Radev

60,241
22
105
110

score 1 · Answer 2 · answered Nov 30 '09 at 07:58

1

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

answered Nov 30 '09 at 07:58

miku

181,842
47
306
310

score 1 · Answer 3 · answered May 09 '17 at 10:14

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/

Thilo · Answer 4 · 2013-04-14T00:45:36.833

0

I found another one that looks promising: pgstatspack.

Also http://www.postgrestats.com/

edited Apr 14 '13 at 00:45

answered Dec 03 '09 at 08:38

Thilo

257,207
101
511
656

Performance report for Postgresql

4 Answers4