Check out our latest eBook: "Efficient Search in Rails with Postgres". We've updated our Terms of Service and Privacy Policy, effective Jan 30, 2021.

EXPLAIN - Bitmap And

Description:

Generate a bitmap of the intersection of two physical row location bitmaps (that is, only locations that occur in both bitmaps). The bitmaps can come from Bitmap Index Scans or other BitmapOr or BitmapAnd child nodes.

Note that, due to internal implementation limitations, BitmapAnd nodes do not track the number of rows they produce. Their row count will always be listed as "Unknown" and they will not be flagged as mis-estimates.



Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →