Re: [HACKERS] Display number of heap accesses for index scans

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: [HACKERS] Display number of heap accesses for index scans
Дата
Msg-id CAPpHfdtQT51jJn3BJSsOcgJvsJbN1ntVEPzQc80nOojqvzW+_g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Display number of heap accesses for index scans  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения
On Mon, Nov 6, 2017 at 6:33 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Peter Geoghegan <pg@bowt.ie> writes:
> Andres Freund <andres@anarazel.de> wrote:
>> The number of index lookups that failed to return anything can be a
>> critical performance factor in OLTP workloads.  Therefore it seems like
>> it'd be a good idea to extend the explain analyze output to include that
>> information.

> I certainly agree.

Doesn't the EXPLAIN (BUFFERS) output already address this?

In plain index scan EXPLAIN (ANALYZE, BUFFERS) doesn't distinguish buffers accessed in index and buffers accessed in heap

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company 

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: [HACKERS] why not parallel seq scan for slow functions
Следующее
От: Raúl Marín Rodríguez
Дата:
Сообщение: Re: [HACKERS] pow support for pgbench