 * 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=2125.31..217038.10 rows=99500 width=352) (actual time=6205.592..6205.592 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848922
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37150 lossy=290719
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1426.276..1426.276 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.969 ms
 Execution time: 6206.104 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=2125.31..217038.10 rows=99500 width=352) (actual time=14266.077..14266.077 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848922
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37150 lossy=290719
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1414.973..1414.973 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.860 ms
 Execution time: 14266.616 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=2125.31..217038.10 rows=99500 width=352) (actual time=8643.084..8643.084 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848922
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37150 lossy=290719
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1501.773..1501.773 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.909 ms
 Execution time: 8643.629 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=2125.31..217038.10 rows=99500 width=352) (actual time=8384.976..8384.976 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848922
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37150 lossy=290719
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1458.334..1458.334 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.896 ms
 Execution time: 8385.461 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=2125.31..217038.10 rows=99500 width=352) (actual time=8579.139..8579.139 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848922
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37150 lossy=290719
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1802.035..1802.035 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 1.338 ms
 Execution time: 8579.688 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=2125.31..217038.10 rows=99500 width=352) (actual time=8459.586..8459.586 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848922
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37150 lossy=290719
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1573.927..1573.927 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 1.116 ms
 Execution time: 8460.117 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=2125.31..217038.10 rows=99500 width=352) (actual time=8695.850..8695.850 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848922
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37150 lossy=290719
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1623.747..1623.747 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 1.066 ms
 Execution time: 8696.387 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=2125.31..217038.10 rows=99500 width=352) (actual time=8248.924..8248.924 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848922
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37150 lossy=290719
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1415.115..1415.115 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.922 ms
 Execution time: 8249.480 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=2125.31..217038.10 rows=99500 width=352) (actual time=8588.890..8588.890 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848922
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37150 lossy=290719
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1444.158..1444.158 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.944 ms
 Execution time: 8589.388 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=2125.31..217038.10 rows=99500 width=352) (actual time=14868.010..14868.010 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848922
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37150 lossy=290719
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1646.070..1646.070 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 1.146 ms
 Execution time: 14868.558 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=2125.31..217038.10 rows=99500 width=352) (actual time=6250.731..6250.731 rows=0 loops=1)
   Recheck Cond: ((aid >= 1000) AND (aid <= 10000000))
   Rows Removed by Index Recheck: 8848922
   Filter: (abalance <> 0)
   Rows Removed by Filter: 9999001
   Heap Blocks: exact=37150 lossy=290719
   Buffers: shared read=355192
   ->  Bitmap Index Scan on pgbench_accounts_pkey  (cost=0.00..2100.44 rows=100000 width=0) (actual time=1455.797..1455.797 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.879 ms
 Execution time: 6251.262 ms
(12 rows)

