Re: Where does the time go?

Поиск
Список
Период
Сортировка
Искать
От
Simon Riggs
Тема
Re: Where does the time go?
Дата
Msg-id
1143283930.24487.972.camel@localhost.localdomain
Ответ на
Re: Where does the time go? (Tom Lane)
Список
Дерево обсуждения
Where does the time go? "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Where does the time go? Tom Lane <tgl@sss.pgh.pa.us>
Re: Where does the time go? Simon Riggs <simon@2ndquadrant.com>
Re: Where does the time go? Tom Lane <tgl@sss.pgh.pa.us>
Re: Where does the time go? Martijn van Oosterhout <kleptog@svana.org>
Re: Where does the time go? Simon Riggs <simon@2ndquadrant.com>
Re: Where does the time go? Martijn van Oosterhout <kleptog@svana.org>
Re: Where does the time go? Martijn van Oosterhout <kleptog@svana.org>
Re: Where does the time go? "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Where does the time go? Tom Lane <tgl@sss.pgh.pa.us>
Re: Where does the time go? "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Where does the time go? Martijn van Oosterhout <kleptog@svana.org>
Re: Where does the time go? "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Where does the time go? Tom Lane <tgl@sss.pgh.pa.us> 
On Wed, 2006-03-22 at 21:59 -0500, Tom Lane wrote:

> I'm betting that a
> big part of your issue is that the EXPLAIN ANALYZE instrumentation
> overhead is (1) significant

I would like to implement an additional mode for EXPLAIN ANALYZE that
does no timing instrumentation at all. Most of the time just looking for
differences between estimated and actual row counts is all you need.

For long queries, the additional time can make the execution infeasible,
yet frequently they are the ones you want to see the output for.

EXPLAIN ANALYZE NOTIMING sounds a little dry, any ideas?

Best Regards, Simon Riggs
В списке pgsql-hackers по дате отправления
Предыдущее
От: Joel Miller
Дата:
Сообщение: Re: [SUGGESTION] CVSync
Следующее
От: Simon Riggs
Дата:
FAQ