Re: show Heap Fetches in EXPLAIN for index-only scans

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: show Heap Fetches in EXPLAIN for index-only scans
Дата
Msg-id CAEYLb_Uy1dnSWA9g+SH7CAzN5g=Mx63WzL9pS50iGh1S+AjG6Q@mail.gmail.com
обсуждение исходный текст
Ответ на show Heap Fetches in EXPLAIN for index-only scans  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 13 January 2012 15:21, Robert Haas <robertmhaas@gmail.com> wrote:
> I think that people who are using index-only scans are going to want
> some way to find out the degree to which the scans are in fact
> index-only.
>
> So here's a 5-line patch that adds the number of heap fetches to the
> EXPLAIN ANALYZE output.  This might not be all the instrumentation
> we'll ever want here, but I think we at least want this much.

Good idea. The fact that that information wasn't available did bother me.

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services


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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Disabled features on Hot Standby
Следующее
От: Robert Haas
Дата:
Сообщение: Re: show Heap Fetches in EXPLAIN for index-only scans