-- Tests for pgbench with using extra statistics for loops

-- pgbench -i -n database
-- pgbench -f -n path_to/pgbench_loop_without_verbose database


EXPLAIN (analyze, verbose off, costs off, summary off, timing off)
SELECT * FROM pgbench_accounts JOIN pgbench_tellers on aid != tid;

EXPLAIN (analyze, verbose off, costs off, summary off, timing off)
SELECT * FROM pgbench_accounts JOIN pgbench_tellers on aid = tid;

EXPLAIN (analyze, verbose off, costs off, summary off, timing off)
SELECT * FROM pgbench_accounts JOIN pgbench_tellers on aid > tid;

EXPLAIN (analyze, verbose off, costs, summary, timing)
SELECT * FROM pgbench_accounts JOIN pgbench_tellers on aid != tid;

EXPLAIN (analyze, verbose off, costs, summary, timing)
SELECT * FROM pgbench_accounts JOIN pgbench_tellers on aid = tid;

EXPLAIN (analyze, verbose off, costs, summary, timing)
SELECT * FROM pgbench_accounts JOIN pgbench_tellers on aid > tid;