Plan master: ------------ Finalize Aggregate (actual time=875.382..886.935 rows=1.00 loops=1) Buffers: shared hit=144 read=1001172 -> Gather (actual time=868.104..886.929 rows=8.00 loops=1) Workers Planned: 7 Workers Launched: 7 Buffers: shared hit=144 read=1001172 -> Partial Aggregate (actual time=865.977..865.978 rows=1.00 loops=8) Buffers: shared hit=144 read=1001172 -> Parallel Bitmap Heap Scan on test (actual time=342.064..861.735 rows=124846.50 loops=8) Recheck Cond: (col1 < 1000000) Heap Blocks: exact=127142 Buffers: shared hit=144 read=1001172 Worker 0: Heap Blocks: exact=122278 Worker 1: Heap Blocks: exact=124066 Worker 2: Heap Blocks: exact=126007 Worker 3: Heap Blocks: exact=122601 Worker 4: Heap Blocks: exact=127794 Worker 5: Heap Blocks: exact=124895 Worker 6: Heap Blocks: exact=123989 -> Bitmap Index Scan on test_col1_idx (actual time=144.824..144.824 rows=998772.00 loops=1) Index Cond: (col1 < 1000000) Index Searches: 1 Buffers: shared read=2397 Plan patched: ------------- Finalize Aggregate (actual time=800.958..811.642 rows=1.00 loops=1) Buffers: shared hit=144 read=1001172 -> Gather (actual time=798.645..811.636 rows=8.00 loops=1) Workers Planned: 7 Workers Launched: 7 Buffers: shared hit=144 read=1001172 -> Partial Aggregate (actual time=796.264..796.264 rows=1.00 loops=8) Buffers: shared hit=144 read=1001172 -> Parallel Bitmap Heap Scan on test (actual time=289.284..792.197 rows=124846.50 loops=8) Recheck Cond: (col1 < 1000000) Heap Blocks: exact=123881 Buffers: shared hit=144 read=1001172 Worker 0: Heap Blocks: exact=122751 Worker 1: Heap Blocks: exact=125432 Worker 2: Heap Blocks: exact=122463 Worker 3: Heap Blocks: exact=126538 Worker 4: Heap Blocks: exact=127470 Worker 5: Heap Blocks: exact=124592 Worker 6: Heap Blocks: exact=125645 -> Bitmap Index Scan on test_col1_idx (actual time=142.290..142.290 rows=998772.00 loops=1) Index Cond: (col1 < 1000000) Index Searches: 1 Buffers: shared read=2397 Planning Time: 0.090 ms Execution Time: 811.669 ms