Postgres Pro
Downloads
Home   >   mailing lists

Re: Review of: explain / allow collecting row counts without timing info - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Review of: explain / allow collecting row counts without timing info
Date
Msg-id CAMkU=1w=dMupEHM2Wtn4Ok4sG3kH_OWBAhrt2fAFonVKWfgZNQ@mail.gmail.com
Whole thread Raw
In response to Re: Review of: explain / allow collecting row counts without timing info  (Tomas Vondra <tv@fuzzy.cz>)
Responses Re: Review of: explain / allow collecting row counts without timing info  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
On Fri, Jan 13, 2012 at 3:07 PM, Tomas Vondra <tv@fuzzy.cz> wrote:
>
> Fixed. The default value of TIMING option did not work as intended, it
> was set to true even for plain EXPLAIN (without ANALYZE). In that case
> the EXPLAIN failed.
>

I've applied this over the "show Heap Fetches in EXPLAIN ANALYZE
output for index-only scans" patch.  It applied and built and passes
installcheck.

I have not done a full review of this, but I want to say that I want
this very much.  Not only can I get the row counts, but also the Heap
Fetches and the output of BUFFERS, without the overhead of timing.  I
haven't looked at contrib aspects of it at all.

Thank you for making this.

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: show Heap Fetches in EXPLAIN for index-only scans
Next
From: Jeff Janes
Date:
Subject: Re: Avoid FK validations for no-rewrite ALTER TABLE ALTER TYPE