CREATE EXTENSION IF NOT EXISTS pg_plan_tree_dot;

CREATE TABLE T1 (C1 int, C2 int, C3 int);
CREATE TABLE T2 (C1 int, C2 int, C3 int);

INSERT INTO T1 (C1, C2, C3) SELECT i, i, i FROM generate_series(0, 10000) AS i;
INSERT INTO T2 (C1, C2, C3) SELECT i, i, i FROM generate_series(0, 10000) AS i;

ANALYZE;

SET enable_mergejoin = off;

-- SELECT T1.C1, T2.C2 FROM T1 JOIN T2 ON (T1.C3 = T2.C3);
EXPLAIN (COSTS OFF, VERBOSE ON) SELECT T1.C1, T2.C2 FROM T1 JOIN T2 ON (T1.C3 = T2.C3);
SELECT generate_plan_tree_dot('SELECT T1.C1, T2.C2 FROM T1 JOIN T2 ON (T1.C3 = T2.C3);', 'sample-hashjoin.dot');

DROP TABLE IF EXISTS T1 CASCADE;
DROP TABLE IF EXISTS T2 CASCADE;