 * 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=3680.225..3680.225 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=1249.561..1249.561 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.631 ms
 Execution time: 3680.816 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=11060.148..11060.148 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=1274.832..1274.832 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.676 ms
 Execution time: 11060.739 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=4819.052..4819.052 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.622..1267.622 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.785 ms
 Execution time: 4819.644 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=4688.261..4688.261 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=1250.750..1250.750 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.504 ms
 Execution time: 4688.826 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=5072.509..5072.509 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=1430.116..1430.116 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.865 ms
 Execution time: 5073.110 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=4897.281..4897.281 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=1330.348..1330.348 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.844 ms
 Execution time: 4897.795 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=4766.614..4766.614 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=1250.580..1250.580 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.461 ms
 Execution time: 4767.195 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=4700.530..4700.530 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=1308.508..1308.508 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 2.106 ms
 Execution time: 4701.147 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=4749.493..4749.493 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=1255.914..1255.914 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.345 ms
 Execution time: 4750.086 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=10895.106..10895.106 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=1250.480..1250.480 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.417 ms
 Execution time: 10895.711 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=3697.726..3697.726 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=1259.068..1259.068 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared hit=2 read=27321
 Planning time: 1.563 ms
 Execution time: 3698.320 ms
(12 rows)

