You can log queries that run for at least a specified amount of time. This will be useful in finding what the long running queries are. You can then use explain analyse to see why they are long running.
But is there a tool that could compile a summary out of the log? The log grows awefully big after a short time.
You might want to look at the "Practical Query Analyser" - haven't used it myself yet, but it seems a sensible idea.
http://pqa.projects.postgresql.org/
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
