Re: show Heap Fetches in EXPLAIN for index-only scans
Peter Geoghegan <peter@2ndquadrant.com>
From: Peter Geoghegan <peter@2ndquadrant.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2012-01-13T15:31:19Z
Lists: pgsql-hackers
On 13 January 2012 15:21, Robert Haas <robertmhaas@gmail.com> wrote: > I think that people who are using index-only scans are going to want > some way to find out the degree to which the scans are in fact > index-only. > > So here's a 5-line patch that adds the number of heap fetches to the > EXPLAIN ANALYZE output. This might not be all the instrumentation > we'll ever want here, but I think we at least want this much. Good idea. The fact that that information wasn't available did bother me. -- Peter Geoghegan http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services