DROP TABLE SELECT 100000 CREATE EXTENSION CREATE INDEX CREATE INDEX ANALYZE SET SET QUERY PLAN ------------------------------------------------------------------------------------------------------ Seq Scan on tbloom (cost=0.00..2137.00 rows=1 width=24) (actual time=12.228..12.228 rows=0 loops=1) Filter: ((i2 = 898732) AND (i5 = 123451)) Rows Removed by Filter: 100000 Planning Time: 0.264 ms Execution Time: 12.249 ms (5 rows) SET RESET QUERY PLAN -------------------------------------------------------------------------------------------------------------------------- Index Only Scan using btreeidx on tbloom (cost=0.42..2992.43 rows=1 width=24) (actual time=6.462..6.463 rows=0 loops=1) Index Cond: ((i2 = 898732) AND (i5 = 123451)) Heap Fetches: 0 Planning Time: 0.102 ms Execution Time: 6.484 ms (5 rows) RESET QUERY PLAN --------------------------------------------------------------------------------------------------------------------- Bitmap Heap Scan on tbloom (cost=1792.00..1796.02 rows=1 width=24) (actual time=0.438..0.438 rows=0 loops=1) Recheck Cond: ((i2 = 898732) AND (i5 = 123451)) Rows Removed by Index Recheck: 31 Heap Blocks: exact=29 -> Bitmap Index Scan on bloomidx (cost=0.00..1792.00 rows=1 width=0) (actual time=0.394..0.394 rows=31 loops=1) Index Cond: ((i2 = 898732) AND (i5 = 123451)) Planning Time: 0.070 ms Execution Time: 0.461 ms (8 rows)