On Fri, Jan 13, 2012 at 10:29 AM, Magnus Hagander <mag...@hagander.net> wrote: > On Fri, Jan 13, 2012 at 16:21, Robert Haas <robertmh...@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. > > Agreed. > > Would also be good to have counter sin pg_stat_* for this, since you'd > usually want to look at this kind of data over time as well. In your > plans? ;)
Not really. I don't have a clear enough idea about what that should look like, and I expect a vigorous debate over the distributed cost of another counter. But I'm happy to have someone who feels more strongly about it than I do take up the cause. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
