Re: [HACKERS] No exact/lossy block information in EXPLAIN ANALYZE for a bitmap heap scan

2014-07-14 Thread Etsuro Fujita
(2014/07/14 21:01), Fujii Masao wrote: On Fri, Jul 11, 2014 at 7:21 PM, Fujii Masao wrote: On Fri, Jul 11, 2014 at 5:45 PM, Etsuro Fujita 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 retri

Re: [HACKERS] No exact/lossy block information in EXPLAIN ANALYZE for a bitmap heap scan

2014-07-14 Thread Fujii Masao
On Fri, Jul 11, 2014 at 7:21 PM, Fujii Masao wrote: > On Fri, Jul 11, 2014 at 5:45 PM, Etsuro Fujita > 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. Su

Re: [HACKERS] No exact/lossy block information in EXPLAIN ANALYZE for a bitmap heap scan

2014-07-11 Thread Fujii Masao
On Fri, Jul 11, 2014 at 5:45 PM, Etsuro Fujita 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

[HACKERS] No exact/lossy block information in EXPLAIN ANALYZE for a bitmap heap scan

2014-07-11 Thread Etsuro Fujita
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 s