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=3814.989..3814.989 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=1194.436..1194.436 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.954 ms
 Execution time: 3815.360 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=11535.531..11535.531 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.029..1210.029 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.692 ms
 Execution time: 11535.923 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=5119.779..5119.779 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.410..1206.410 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.348 ms
 Execution time: 5120.168 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=4855.275..4855.275 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.241..1197.241 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.415 ms
 Execution time: 4855.619 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=4879.758..4879.758 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=1191.229..1191.229 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.407 ms
 Execution time: 4880.180 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=4958.253..4958.253 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=1204.381..1204.381 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.242 ms
 Execution time: 4958.645 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=5022.981..5022.981 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=1215.642..1215.642 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.326 ms
 Execution time: 5023.410 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=4913.696..4913.696 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=1183.243..1183.243 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.582 ms
 Execution time: 4914.083 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=5000.873..5000.873 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.189..1197.189 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.390 ms
 Execution time: 5001.237 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=10894.945..10894.945 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.835..1167.835 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.231 ms
 Execution time: 10895.436 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=3824.523..3824.523 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=1204.530..1204.530 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.463 ms
 Execution time: 3824.871 ms
(12 rows)

