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