Re: So why is EXPLAIN printing only *plan* time?

Поиск
Список
Период
Сортировка
От David G Johnston
Тема Re: So why is EXPLAIN printing only *plan* time?
Дата
Msg-id 1398631734166-5801674.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: So why is EXPLAIN printing only *plan* time?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane-2 wrote
> Or we could add them into
> just the first planning-time printout, though that might also be
> misleading.

If you are going to show a number for these steps, which seems like a good
idea, then this seems like a reasonable option in the face of this
situation.

Basically two options:
1. Query overhead timing detailed separately
2. Query overhead included with first plans' planning time

An explain option: (OVERHEAD '[off?|detail|first]') would then give the user
the ability to choose between the two (not sure if off is worthwhile but
worth at least rejecting explicitly).

David J.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/So-why-is-EXPLAIN-printing-only-plan-time-tp5801663p5801674.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: includedir_internal headers are not self-contained
Следующее
От: Tom Lane
Дата:
Сообщение: Re: includedir_internal headers are not self-contained