 * 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=3760.263..3760.263 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..210190.89 rows=10024245 width=0) (actual time=1267.061..1267.061 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.594 ms
 Execution time: 3760.865 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=11092.269..11092.269 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=1281.112..1281.112 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.513 ms
 Execution time: 11092.846 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=4933.100..4933.100 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=1304.844..1304.844 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.626 ms
 Execution time: 4933.662 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=4733.136..4733.136 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=1248.815..1248.815 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.495 ms
 Execution time: 4733.713 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=4860.291..4860.291 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.299..1246.299 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.699 ms
 Execution time: 4860.886 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=5063.141..5063.141 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=1268.409..1268.409 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.637 ms
 Execution time: 5063.696 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=4669.542..4669.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=1265.813..1265.813 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.462 ms
 Execution time: 4670.155 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=5049.312..5049.312 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=1267.522..1267.522 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.538 ms
 Execution time: 5049.901 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=4784.658..4784.658 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.394..1266.394 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.601 ms
 Execution time: 4785.219 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=11105.553..11105.553 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=1422.027..1422.027 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.880 ms
 Execution time: 11106.143 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=3778.533..3778.533 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=1304.199..1304.199 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.654 ms
 Execution time: 3779.058 ms
(12 rows)

