Re: EXPLAIN ANALYZE for bitmapAnd and bitmapOr scans always reports rows = 0

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Joseph S <jks(at)selectacast(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: EXPLAIN ANALYZE for bitmapAnd and bitmapOr scans always reports rows = 0
Date: 2007-08-01 19:02:45
Message-ID: 46B0D8D5.2010703@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Joseph S wrote:
> From this snipped you can see that the Bitmap Heap scan returns 123
> rows, but the BitmapAnd under it returns 0. I would find it useful to
> determine how many rows were thrown out by the recheck.

Yeah, it would be nice. Unfortunately there's some problems with that,
see previous discussion on that:
http://archives.postgresql.org/pgsql-bugs/2007-04/msg00029.php

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Koczan 2007-08-01 21:19:40 BUG #3504: Some listening sessions never return from writing, problems ensue
Previous Message Justin Hibbits 2007-08-01 17:42:02 BUG #3503: Benchmark scripts broken