Re: Improve output of BitmapAnd EXPLAIN ANALYZE - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Improve output of BitmapAnd EXPLAIN ANALYZE
Date
Msg-id 20161020204221.GW13284@tamriel.snowman.net
Whole thread Raw
In response to Re: Improve output of BitmapAnd EXPLAIN ANALYZE  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Improve output of BitmapAnd EXPLAIN ANALYZE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom,

* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Jim Nasby <Jim.Nasby@BlueTreble.com> writes:
> > A customer just pinged me wondering how it was that a BitmapAnd node was
> > reporting 0 tuples when the Bitmap Heap Scan above it showed it had in
> > fact generated tuples.
>
> > While this is mentioned in the docs, I think it would be very helpful to
> > have ANALYZE spit out "N/A" instead of 0 for these nodes.
>
> That would break code that tries to parse that stuff, eg depesz.com.

I don't believe Jim was suggesting that we back-patch such a change.

Changing it in a new major release seems entirely reasonable.

Thanks!

Stephen

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Improve output of BitmapAnd EXPLAIN ANALYZE
Next
From: Tom Lane
Date:
Subject: Re: WIP: Fix invalid XML explain plans for track_io_timing