set enable_indexscan = off;
set enable_seqscan = off;
set max_parallel_workers_per_gather = 0;

set effective_io_concurrency = 0;
explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 50000000 and abalance != 0;

set effective_io_concurrency = 1;
explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 50000000 and abalance != 0;

set effective_io_concurrency = 2;
explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 50000000 and abalance != 0;

set effective_io_concurrency = 3;
explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 50000000 and abalance != 0;

set effective_io_concurrency = 4;
explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 50000000 and abalance != 0;

set effective_io_concurrency = 8;
explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 50000000 and abalance != 0;

set effective_io_concurrency = 16;
explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 50000000 and abalance != 0;

set effective_io_concurrency = 32;
explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 50000000 and abalance != 0;

set effective_io_concurrency = 64;
explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 50000000 and abalance != 0;

set effective_io_concurrency = 128;
explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 50000000 and abalance != 0;

set effective_io_concurrency = 256;
explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 50000000 and abalance != 0;

set effective_io_concurrency = 512;
explain (analyze, buffers)  select * from pgbench_accounts where aid between 1000 and 50000000 and abalance != 0;
