Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Display number of heap accesses for index scans - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Display number of heap accesses for index scans
Date
Msg-id 14517.1509939185@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Display number of heap accesses for index scans  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: [HACKERS] Display number of heap accesses for index scans  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Custom compression methods
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] why not parallel seq scan for slow functions