set effective_io_concurrency=0; set enable_indexscan=off; set enable_seqscan=off; explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 10000000 and abalance != 0;
                                                                    QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on pgbench_accounts  (cost=2125.31..217038.10 rows=99500 width=352) (actual time=6800.826..6800.826 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848069
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37158 lossy=290711
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1488.484..1488.484 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 1.083 ms
 Execution time: 6801.229 ms
(12 rows)

set effective_io_concurrency=1; set enable_indexscan=off; set enable_seqscan=off; explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 10000000 and abalance != 0;
                                                                    QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on pgbench_accounts  (cost=2125.31..217038.10 rows=99500 width=352) (actual time=14217.353..14217.353 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848069
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37158 lossy=290711
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1505.569..1505.569 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 1.154 ms
 Execution time: 14217.719 ms
(12 rows)

set effective_io_concurrency=2; set enable_indexscan=off; set enable_seqscan=off; explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 10000000 and abalance != 0;
                                                                    QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on pgbench_accounts  (cost=2125.31..217038.10 rows=99500 width=352) (actual time=9125.859..9125.859 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848069
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37158 lossy=290711
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1631.026..1631.026 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.934 ms
 Execution time: 9126.216 ms
(12 rows)

set effective_io_concurrency=4; set enable_indexscan=off; set enable_seqscan=off; explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 10000000 and abalance != 0;
                                                                    QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on pgbench_accounts  (cost=2125.31..217038.10 rows=99500 width=352) (actual time=8797.333..8797.333 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848069
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37158 lossy=290711
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1466.636..1466.636 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.975 ms
 Execution time: 8797.717 ms
(12 rows)

set effective_io_concurrency=8; set enable_indexscan=off; set enable_seqscan=off; explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 10000000 and abalance != 0;
                                                                    QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on pgbench_accounts  (cost=2125.31..217038.10 rows=99500 width=352) (actual time=8758.998..8758.998 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848069
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37158 lossy=290711
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1615.028..1615.028 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 1.038 ms
 Execution time: 8759.317 ms
(12 rows)

set effective_io_concurrency=16; set enable_indexscan=off; set enable_seqscan=off; explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 10000000 and abalance != 0;
                                                                    QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on pgbench_accounts  (cost=2125.31..217038.10 rows=99500 width=352) (actual time=8431.511..8431.511 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848069
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37158 lossy=290711
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1495.888..1495.888 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 1.413 ms
 Execution time: 8431.835 ms
(12 rows)

set effective_io_concurrency=8; set enable_indexscan=off; set enable_seqscan=off; explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 10000000 and abalance != 0;
                                                                    QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on pgbench_accounts  (cost=2125.31..217038.10 rows=99500 width=352) (actual time=9386.762..9386.762 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848069
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37158 lossy=290711
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1623.676..1623.676 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.960 ms
 Execution time: 9387.119 ms
(12 rows)

set effective_io_concurrency=4; set enable_indexscan=off; set enable_seqscan=off; explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 10000000 and abalance != 0;
                                                                    QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on pgbench_accounts  (cost=2125.31..217038.10 rows=99500 width=352) (actual time=9064.438..9064.438 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848069
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37158 lossy=290711
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1616.030..1616.030 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 1.077 ms
 Execution time: 9064.808 ms
(12 rows)

set effective_io_concurrency=2; set enable_indexscan=off; set enable_seqscan=off; explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 10000000 and abalance != 0;
                                                                    QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on pgbench_accounts  (cost=2125.31..217038.10 rows=99500 width=352) (actual time=9358.628..9358.628 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848069
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37158 lossy=290711
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1535.668..1535.668 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.918 ms
 Execution time: 9359.062 ms
(12 rows)

set effective_io_concurrency=1; set enable_indexscan=off; set enable_seqscan=off; explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 10000000 and abalance != 0;
                                                                    QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on pgbench_accounts  (cost=2125.31..217038.10 rows=99500 width=352) (actual time=16639.063..16639.063 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848069
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37158 lossy=290711
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1500.092..1500.092 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.882 ms
 Execution time: 16639.386 ms
(12 rows)

set effective_io_concurrency=0; set enable_indexscan=off; set enable_seqscan=off; explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 10000000 and abalance != 0;
                                                                    QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on pgbench_accounts  (cost=2125.31..217038.10 rows=99500 width=352) (actual time=6560.581..6560.581 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848069
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37158 lossy=290711
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1456.563..1456.563 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.853 ms
 Execution time: 6560.935 ms
(12 rows)

