 * Restarting PostgreSQL 9.6 database server
   ...done.
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=210190.89..713484.18 rows=1 width=97) (actual time=3855.542..3855.542 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..210190.89 rows=10024245 width=0) (actual time=1285.655..1285.655 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.651 ms
 Execution time: 3856.143 ms
(12 rows)

 * Restarting PostgreSQL 9.6 database server
   ...done.
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=210190.89..713484.18 rows=1 width=97) (actual time=10410.098..10410.098 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..210190.89 rows=10024245 width=0) (actual time=1252.332..1252.332 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.587 ms
 Execution time: 10410.729 ms
(12 rows)

 * Restarting PostgreSQL 9.6 database server
   ...done.
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=210190.89..713484.18 rows=1 width=97) (actual time=4714.256..4714.256 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..210190.89 rows=10024245 width=0) (actual time=1279.678..1279.678 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.483 ms
 Execution time: 4714.845 ms
(12 rows)

 * Restarting PostgreSQL 9.6 database server
   ...done.
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=210190.89..713484.18 rows=1 width=97) (actual time=4652.245..4652.245 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..210190.89 rows=10024245 width=0) (actual time=1258.063..1258.063 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.446 ms
 Execution time: 4652.839 ms
(12 rows)

 * Restarting PostgreSQL 9.6 database server
   ...done.
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=210190.89..713484.18 rows=1 width=97) (actual time=4724.243..4724.243 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..210190.89 rows=10024245 width=0) (actual time=1266.651..1266.651 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.368 ms
 Execution time: 4724.837 ms
(12 rows)

 * Restarting PostgreSQL 9.6 database server
   ...done.
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=210190.89..713484.18 rows=1 width=97) (actual time=4655.652..4655.652 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..210190.89 rows=10024245 width=0) (actual time=1246.507..1246.507 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.755 ms
 Execution time: 4656.235 ms
(12 rows)

 * Restarting PostgreSQL 9.6 database server
   ...done.
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=210190.89..713484.18 rows=1 width=97) (actual time=4739.827..4739.827 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..210190.89 rows=10024245 width=0) (actual time=1257.895..1257.895 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.685 ms
 Execution time: 4740.427 ms
(12 rows)

 * Restarting PostgreSQL 9.6 database server
   ...done.
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=210190.89..713484.18 rows=1 width=97) (actual time=4641.229..4641.229 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..210190.89 rows=10024245 width=0) (actual time=1254.620..1254.620 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.419 ms
 Execution time: 4641.797 ms
(12 rows)

 * Restarting PostgreSQL 9.6 database server
   ...done.
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=210190.89..713484.18 rows=1 width=97) (actual time=4816.753..4816.753 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..210190.89 rows=10024245 width=0) (actual time=1265.367..1265.367 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.592 ms
 Execution time: 4817.322 ms
(12 rows)

 * Restarting PostgreSQL 9.6 database server
   ...done.
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=210190.89..713484.18 rows=1 width=97) (actual time=10909.595..10909.595 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..210190.89 rows=10024245 width=0) (actual time=1237.719..1237.719 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.307 ms
 Execution time: 10910.171 ms
(12 rows)

 * Restarting PostgreSQL 9.6 database server
   ...done.
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=210190.89..713484.18 rows=1 width=97) (actual time=3758.171..3758.171 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..210190.89 rows=10024245 width=0) (actual time=1272.410..1272.410 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.727 ms
 Execution time: 3758.752 ms
(12 rows)

