SQL CPU time usage

Ruben Rubio Rey <ruben@xxxxxxxxxxxx> · Wed, 17 May 2006 17:21:14 +0200

Hi,

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?

Thanks in advance