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=207170.36..707942.72 rows=1 width=97) (actual time=3910.419..3910.419 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 23
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=32229 lossy=131690
   Buffers: shared hit=2 read=191240 written=1
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..207170.36 rows=9880192 width=0) (actual time=1190.550..1190.550 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.423 ms
 Execution time: 3910.770 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=207170.36..707942.72 rows=1 width=97) (actual time=10754.135..10754.135 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 23
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=32229 lossy=131690
   Buffers: shared hit=2 read=191240
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..207170.36 rows=9880192 width=0) (actual time=1257.503..1257.503 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.883 ms
 Execution time: 10754.483 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=207170.36..707942.72 rows=1 width=97) (actual time=5347.507..5347.507 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 23
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=32229 lossy=131690
   Buffers: shared hit=2 read=191240
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..207170.36 rows=9880192 width=0) (actual time=1210.350..1210.350 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.632 ms
 Execution time: 5347.845 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=207170.36..707942.72 rows=1 width=97) (actual time=5736.761..5736.761 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 23
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=32229 lossy=131690
   Buffers: shared hit=2 read=191240
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..207170.36 rows=9880192 width=0) (actual time=1570.434..1570.434 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.948 ms
 Execution time: 5737.166 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=207170.36..707942.72 rows=1 width=97) (actual time=4904.621..4904.621 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 23
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=32229 lossy=131690
   Buffers: shared hit=2 read=191240
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..207170.36 rows=9880192 width=0) (actual time=1202.959..1202.959 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.432 ms
 Execution time: 4904.962 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=207170.36..707942.72 rows=1 width=97) (actual time=4947.592..4947.592 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 23
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=32229 lossy=131690
   Buffers: shared hit=2 read=191240
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..207170.36 rows=9880192 width=0) (actual time=1206.521..1206.521 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.375 ms
 Execution time: 4947.941 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=207170.36..707942.72 rows=1 width=97) (actual time=4736.773..4736.773 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 23
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=32229 lossy=131690
   Buffers: shared hit=2 read=191240
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..207170.36 rows=9880192 width=0) (actual time=1197.695..1197.695 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.567 ms
 Execution time: 4737.117 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=207170.36..707942.72 rows=1 width=97) (actual time=4748.737..4748.737 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 23
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=32229 lossy=131690
   Buffers: shared hit=2 read=191240
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..207170.36 rows=9880192 width=0) (actual time=1216.090..1216.090 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.416 ms
 Execution time: 4749.065 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=207170.36..707942.72 rows=1 width=97) (actual time=5030.963..5030.963 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 23
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=32229 lossy=131690
   Buffers: shared hit=2 read=191240
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..207170.36 rows=9880192 width=0) (actual time=1203.441..1203.441 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.683 ms
 Execution time: 5031.390 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=207170.36..707942.72 rows=1 width=97) (actual time=10117.579..10117.579 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 23
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=32229 lossy=131690
   Buffers: shared hit=2 read=191240
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..207170.36 rows=9880192 width=0) (actual time=1188.859..1188.859 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.161 ms
 Execution time: 10117.927 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=207170.36..707942.72 rows=1 width=97) (actual time=3768.927..3768.927 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 23
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=32229 lossy=131690
   Buffers: shared hit=2 read=191240
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..207170.36 rows=9880192 width=0) (actual time=1167.637..1167.637 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.473 ms
 Execution time: 3769.260 ms
(12 rows)

