Hi,
But is there a tool that could compile a summary out of the log? The log grows awefully big after a short time.
There's also pg_analyzer to check out.
http://www.samse.fr/GPL/pg_analyzer/
Some of it's features are: written in Perl and produces HTML output.
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/
Cheers, Rudi.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org