SELECT 10000000 CREATE INDEX CREATE INDEX QUERY PLAN ----------------------------------------------------------------------------------------------------------------------------- Bitmap Heap Scan on tbloom (cost=178436.06..179392.83 rows=250 width=24) (actual time=98.114..98.114 rows=0 loops=1) Recheck Cond: ((i2 = 898732) AND (i5 = 123451)) Rows Removed by Index Recheck: 2375 Heap Blocks: exact=2317 -> Bitmap Index Scan on bloomidx (cost=0.00..178436.00 rows=250 width=0) (actual time=86.796..86.797 rows=2375 loops=1) Index Cond: ((i2 = 898732) AND (i5 = 123451)) Planning time: 0.326 ms Execution time: 98.156 ms (8 rows) ANALYZE QUERY PLAN --------------------------------------------------------------------------------------------------------------------------- Bitmap Heap Scan on tbloom (cost=178434.71..178438.73 rows=1 width=24) (actual time=104.982..104.982 rows=0 loops=1) Recheck Cond: ((i2 = 898732) AND (i5 = 123451)) Rows Removed by Index Recheck: 2375 Heap Blocks: exact=2317 -> Bitmap Index Scan on bloomidx (cost=0.00..178434.71 rows=1 width=0) (actual time=93.657..93.657 rows=2375 loops=1) Index Cond: ((i2 = 898732) AND (i5 = 123451)) Planning time: 0.215 ms Execution time: 105.018 ms (8 rows)