Re: That EXPLAIN ANALYZE patch still needs work

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: That EXPLAIN ANALYZE patch still needs work
Дата
Msg-id 87y7w6gowm.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: That EXPLAIN ANALYZE patch still needs work  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: That EXPLAIN ANALYZE patch still needs work  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> I was intending to push forward with the idea of being able to get
> numbers out of a canceled EXPLAIN.  That will allow you to get some
> information even when the underlying query runs longer than you're
> willing to tolerate.  I still say that the number of queries where
> avoiding gettimeofday overhead would transform an intolerable runtime
> into a tolerable one is pretty limited.

Are we still going to subtract out the gettimeofday overhead?

I was always more excited about that than the sampling aspect. I've run into
queries where EXPLAIN ANALYZE results were deceptive due to the gettimeofday
overhead but I've never run into a query where gettimeofday overhead made
running the query under EXPLAIN ANALYZE impractical.


-- 
greg



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: ADD/DROP constraints
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ADD/DROP constraints