Re: [GENERAL] How to know which queries are to be optimised?

[Rudi Starcevic <tech(at)wildcash(dot)com>]

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.