 * 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=6241.765..6241.765 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=1421.632..1421.632 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.872 ms
 Execution time: 6242.298 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=14584.434..14584.434 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=1518.945..1518.945 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.855 ms
 Execution time: 14584.953 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=8434.116..8434.116 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=1373.952..1373.952 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.900 ms
 Execution time: 8434.636 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=8338.358..8338.358 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=1441.612..1441.612 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.856 ms
 Execution time: 8338.912 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=8237.415..8237.415 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=1397.501..1397.501 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.944 ms
 Execution time: 8237.940 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=8168.551..8168.551 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=1466.636..1466.636 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.903 ms
 Execution time: 8169.103 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=8190.256..8190.256 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.005..1444.005 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.802 ms
 Execution time: 8190.808 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=8226.856..8226.856 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=1427.083..1427.083 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.899 ms
 Execution time: 8227.390 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=8522.094..8522.094 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=1423.972..1423.972 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.876 ms
 Execution time: 8522.638 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=14791.907..14791.907 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=1431.149..1431.149 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.935 ms
 Execution time: 14792.420 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=6230.264..6230.264 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=1427.153..1427.153 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.988 ms
 Execution time: 6230.782 ms
(12 rows)

