Skip site navigation (1) Skip section navigation (2)

Re: show Heap Fetches in EXPLAIN for index-only scans

From: Peter Geoghegan <peter(at)2ndquadrant(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: show Heap Fetches in EXPLAIN for index-only scans
Date: 2012-01-13 15:31:19
Message-ID: CAEYLb_Uy1dnSWA9g+SH7CAzN5g=Mx63WzL9pS50iGh1S+AjG6Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 13 January 2012 15:21, Robert Haas <robertmhaas(at)gmail(dot)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

In response to

pgsql-hackers by date

Next:From: Robert HaasDate: 2012-01-13 15:31:42
Subject: Re: show Heap Fetches in EXPLAIN for index-only scans
Previous:From: Jim NasbyDate: 2012-01-13 15:31:13
Subject: Re: Disabled features on Hot Standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group