Re: Review of: explain / allow collecting row counts without timing info

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Review of: explain / allow collecting row counts without timing info
Дата
Msg-id CAMkU=1w=dMupEHM2Wtn4Ok4sG3kH_OWBAhrt2fAFonVKWfgZNQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Review of: explain / allow collecting row counts without timing info  (Tomas Vondra <tv@fuzzy.cz>)
Ответы Re: Review of: explain / allow collecting row counts without timing info  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Fri, Jan 13, 2012 at 3:07 PM, Tomas Vondra <tv@fuzzy.cz> wrote:
>
> Fixed. The default value of TIMING option did not work as intended, it
> was set to true even for plain EXPLAIN (without ANALYZE). In that case
> the EXPLAIN failed.
>

I've applied this over the "show Heap Fetches in EXPLAIN ANALYZE
output for index-only scans" patch.  It applied and built and passes
installcheck.

I have not done a full review of this, but I want to say that I want
this very much.  Not only can I get the row counts, but also the Heap
Fetches and the output of BUFFERS, without the overhead of timing.  I
haven't looked at contrib aspects of it at all.

Thank you for making this.

Cheers,

Jeff


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: show Heap Fetches in EXPLAIN for index-only scans
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Avoid FK validations for no-rewrite ALTER TABLE ALTER TYPE