1 SET search_path TO public;
3 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id;
5 --------------------------------------
7 Merge Cond: (t1.id = t2.id)
8 -> Index Scan using t1_pkey on t1
9 -> Index Scan using t2_pkey on t2
13 EXPLAIN (COSTS false) SELECT * FROM t1, t4 WHERE t1.val < 10;
15 -----------------------------------------
17 -> Bitmap Heap Scan on t1
18 Recheck Cond: (val < 10)
19 -> Bitmap Index Scan on t1_val
20 Index Cond: (val < 10)
26 EXPLAIN (COSTS false) SELECT * FROM t3, t4 WHERE t3.id = t4.id AND t4.ctid = '(1,1)';
28 ---------------------------------------------
30 Merge Cond: (t3.id = t4.id)
31 -> Index Scan using t3_pkey on t3
35 Filter: (ctid = '(1,1)'::tid)
39 EXPLAIN (COSTS false) SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.ctid = '(1,1)';
41 -----------------------------------------
44 TID Cond: (ctid = '(1,1)'::tid)
45 -> Index Scan using t2_pkey on t2
46 Index Cond: (id = t1.id)
50 EXPLAIN (COSTS false) SELECT * FROM t1, t3 WHERE t1.val = t3.val;
52 --------------------------------
54 Hash Cond: (t1.val = t3.val)
61 EXPLAIN (COSTS false) SELECT * FROM t1, t2, t3, t4 WHERE t1.id = t2.id AND t1.id = t3.id AND t1.id = t4.id;
63 --------------------------------------------------
66 Merge Cond: (t1.id = t4.id)
68 Merge Cond: (t1.id = t2.id)
69 -> Index Scan using t1_pkey on t1
70 -> Index Scan using t2_pkey on t2
74 -> Index Scan using t3_pkey on t3
75 Index Cond: (id = t1.id)