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

Ulrich Wisser wrote:
>> 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