 * 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=6243.049..6243.049 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=1403.032..1403.032 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.890 ms
 Execution time: 6243.600 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=14612.824..14612.824 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=1461.318..1461.318 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 1.708 ms
 Execution time: 14613.348 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=8250.033..8250.033 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=1400.719..1400.719 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.824 ms
 Execution time: 8250.552 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=8285.804..8285.804 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.698..1458.698 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 1.053 ms
 Execution time: 8286.333 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=8167.307..8167.307 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=1402.643..1402.643 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.829 ms
 Execution time: 8167.817 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=8192.668..8192.668 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=1407.007..1407.007 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.871 ms
 Execution time: 8193.186 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=8206.077..8206.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=1423.122..1423.122 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 1.126 ms
 Execution time: 8206.614 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=8374.619..8374.619 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=1507.408..1507.408 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.919 ms
 Execution time: 8375.153 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=8353.583..8353.583 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=1468.872..1468.872 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.995 ms
 Execution time: 8354.106 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=14139.162..14139.162 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=1409.552..1409.552 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.962 ms
 Execution time: 14139.712 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=6408.709..6408.709 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=1505.004..1505.004 rows=9999001 loops=1)
         Index Cond: ((aid >= 1000) AND (aid <= 10000000))
         Buffers: shared read=27323
 Planning time: 0.967 ms
 Execution time: 6409.229 ms
(12 rows)

