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=7014.995..7014.995 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=1608.555..1608.555 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.877 ms
 Execution time: 7015.371 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=14520.112..14520.112 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=1568.366..1568.366 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.940 ms
 Execution time: 14520.446 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=9223.220..9223.220 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=1594.750..1594.750 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.956 ms
 Execution time: 9223.536 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=8530.276..8530.276 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=1565.581..1565.581 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.957 ms
 Execution time: 8530.593 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=9285.168..9285.168 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=1481.572..1481.572 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.826 ms
 Execution time: 9285.512 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=8562.208..8562.208 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=1515.895..1515.895 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.827 ms
 Execution time: 8562.561 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=8963.330..8963.330 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=1525.869..1525.869 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.761 ms
 Execution time: 8963.702 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=8771.280..8771.280 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=1504.329..1504.329 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.931 ms
 Execution time: 8771.646 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=9228.242..9228.242 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=1558.901..1558.901 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.911 ms
 Execution time: 9228.572 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=15109.144..15109.144 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=1668.835..1668.835 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.836 ms
 Execution time: 15109.459 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=7535.338..7535.338 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=1580.368..1580.368 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.914 ms
 Execution time: 7535.828 ms
(12 rows)

