Horton

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

Heikki Linnakangas <heikki@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Joseph S <jks@selectacast.net>
Cc: pgsql-bugs@postgresql.org
Date: 2007-08-01T19:02:45Z
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