Re: No exact/lossy block information in EXPLAIN ANALYZE for a bitmap heap scan - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: No exact/lossy block information in EXPLAIN ANALYZE for a bitmap heap scan
Date
Msg-id CAHGQGwFH8JFvGgzaNLYVqov25Je3048wwmJ5XhMLyRugcRjeyw@mail.gmail.com
Whole thread Raw
In response to Re: No exact/lossy block information in EXPLAIN ANALYZE for a bitmap heap scan  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: No exact/lossy block information in EXPLAIN ANALYZE for a bitmap heap scan  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
List pgsql-hackers
On Fri, Jul 11, 2014 at 7:21 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
> On Fri, Jul 11, 2014 at 5:45 PM, Etsuro Fujita
> <fujita.etsuro@lab.ntt.co.jp> wrote:
>> I've noticed that EXPLAIN ANALYZE shows no information on exact/lossy
>> blocks for a bitmap heap scan when both the numbers of exact/lossy pages
>> retrieved by the node are zero.  Such an example is shown below.  I
>> think it would be better to suppress the 'Heap Blocks' line in that
>> case, based on the same idea of the 'Buffers' line.  Patch attached.
>
> The patch looks good to me. Barring any objection, I will commit this both
> in HEAD and 9.4.

Committed!

Regards,



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: issue log message to suggest VACUUM FULL if a table is nearly empty
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: Re: issue log message to suggest VACUUM FULL if a table is nearly empty