SQL CPU time usage - Mailing list pgsql-performance

From Ruben Rubio Rey
Subject SQL CPU time usage
Date
Msg-id 446B3F6A.9070205@rentalia.com
Whole thread Raw
Responses Re: SQL CPU time usage
Re: SQL CPU time usage
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Jignesh K. Shah"
Date:
Subject: Re: Pgsql (and mysql) benchmark on T2000/Solaris and some
Next
From: "Jim C. Nasby"
Date:
Subject: Re: IMMUTABLE?