Logged Query Analysis for Postgres [pqa.projects.postgresql.org]
This is absolutely legendary. Very simply, pqa analyses your postgres logfile (after tweaking the logging level a bit in your postgresql.conf) to produce reports on:
- The most expensive (slowest) queries
- The most frequently run queries
- The queries that took the most aggregate time
Very simple - but very beneficial when you have to optimise a large amount of code pumping the database as fast as it can.
The biggest deficiency it has is that it doesn't log which database is involved - I'll take a look at the code and the logs to see if that is possible, but it's written in ruby...
Maybe I should port it to perl, but then I'd have to maintain it...
03:08 AM, 13 Aug 2004 by Mark Aufflick Permalink