On Mon, Nov 6, 2017 at 6:33 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Peter Geoghegan <p...@bowt.ie> writes: > > Andres Freund <and...@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
