john_oshea@xxxxxxxxxxxx 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
