Re: Measuring execution time

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: Measuring execution time
Дата
Msg-id 4C620E20.4060608@catalyst.net.nz
обсуждение исходный текст
Ответ на Measuring execution time  (vamsi krishna <vamsikrishna1902@gmail.com>)
Ответы Re: Measuring execution time  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Surprising dead_tuple_count from pgstattuple
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: Measuring execution time