Measuring execution time

From: vamsi krishna <vamsikrishna1902(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Measuring execution time
Date: 2010-08-10 07:46:02
Message-ID: AANLkTimkyEDXRv+i_KheownR1kr+PkLa=AebwGR66+Rc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

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" ?

Thanks
Vamsi

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2010-08-10 13:11:48 Re: Measuring execution time
Previous Message Tom Lane 2010-08-10 04:11:36 Re: BUG #5603: pg_tblspc and pg_twoface directories get deleted when starting up service

Browse pgsql-hackers by date

  From Date Subject
Next Message Yeb Havinga 2010-08-10 07:53:23 Re: Universal B-tree
Previous Message Bruce Momjian 2010-08-10 06:51:50 Re: Explicit psqlrc