Re: SQL CPU time usage

john_oshea@wordbank.com wrote:

> On 17 May 2006, at 16:21, Ruben Rubio Rey wrote:
>
>> I have a web page, that executes several SQLs.
>>
>> So, I would like to know witch one of those SQLs consumes more CPU.
>> For example,
>> I have SQL1 that is executed in 1.2 secs and a SQL2 that is  executed
>> in 200 ms.
>>
>> But SQL2 is executed 25 times and SQL1 is executed 1 time, so  really
>> SQL2 consumes more CPU time.
>>
>> Is there any way to know this?
>> I have think that logging all SQLs and then cheking it is a way to
>> do it ... any other idea?
>
>
> Practical Query Analysis: <http://pqa.projects.postgresql.org/> does
> exactly that (scan historic logs). Very nice indeed and more than
> worth the money (it's BSD-licensed)
>
thanks