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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Display number of heap accesses for index scans
Дата
Msg-id 14517.1509939185@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Display number of heap accesses for index scans  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: [HACKERS] Display number of heap accesses for index scans
Список pgsql-hackers
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?
        regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Custom compression methods
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] why not parallel seq scan for slow functions