-- Tests for pgbench with using extra statistics for loops

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


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

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

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

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

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

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