Re: Measuring execution time - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: Measuring execution time
Date
Msg-id 4C620E20.4060608@catalyst.net.nz
Whole thread Raw
In response to Measuring execution time  (vamsi krishna <vamsikrishna1902@gmail.com>)
Responses Re: Measuring execution time
List pgsql-hackers
On 10/08/10 19:46, vamsi krishna wrote:
Hello all
 
I want to measure the execution time spent running an SQL select query after the plan generation.
 
So precisely I want to put my start timer before createQueryDesc() or ExecutorStart() and end timer after freeQueryDesc() or ExecutorEnd().
 
Right now I did so in "spi.c", "explain.c", "pquery.c" but they are not the default execution cases. Can someone tell me which file holds the default call to ExecutorStart(), because I also want to see the select query result unlike in the case of "explain" ?
 


See ProcessQuery in src/backend/tcop/query.c

Cheers

Mark

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Surprising dead_tuple_count from pgstattuple
Next
From: Mark Kirkwood
Date:
Subject: Re: Measuring execution time