Re: SQL CPU time usage

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)

--
John O'Shea
Wordbank Limited
33 Charlotte Street, London W1T 1RR
Direct line: +44 (0) 20 7903 8829
Fax: +44 (0) 20 7903 8888
<http://www.wordbank.com/>




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux