Postgres Pro
Downloads
Home   >   mailing lists

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 CAHGQGwFdYquCPMsbpnodnKna3Fobgdz=7=KP5x8Map8WfTZf5Q@mail.gmail.com
Whole thread Raw
In response to No exact/lossy block information in EXPLAIN ANALYZE for a bitmap heap scan  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Responses Re: No exact/lossy block information in EXPLAIN ANALYZE for a bitmap heap scan  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
Tree view 
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.

Regards,

-- 
Fujii Masao

pgsql-hackers by date:

Previous
From: Christoph Martin
Date:
Subject: [PATCH] Fix search_path default value separator.
Next
From: Simon Riggs
Date:
Subject: Re: tweaking NTUP_PER_BUCKET