2 --------------------------------------------------------------------------------------
3 Nested Loop (cost=xxx rows=1 width=117)
4 Join Filter: (t1.c1 = "*VALUES*_1".column1)
5 -> Nested Loop (cost=xxx rows=1 width=73)
6 -> Hash Join (cost=xxx rows=1 width=58)
7 Hash Cond: (t2.c1 = "*VALUES*".column1)
8 -> Seq Scan on t2 (cost=xxx rows=100 width=14)
9 -> Hash (cost=xxx rows=1 width=44)
10 -> Values Scan on "*VALUES*" (cost=xxx rows=1 width=44)
11 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1 width=15)
12 Index Cond: (c1 = t2.c1)
13 -> Values Scan on "*VALUES*_1" (cost=xxx rows=2 width=44)
17 --------------------------------------------------------------------------------------
18 Nested Loop (cost=xxx rows=1 width=117)
19 Join Filter: (t1.c1 = "*VALUES*_1".column1)
20 -> Nested Loop (cost=xxx rows=1 width=73)
21 -> Hash Join (cost=xxx rows=1 width=58)
22 Hash Cond: (t2.c1 = "*VALUES*".column1)
23 -> Seq Scan on t2 (cost=xxx rows=100 width=14)
24 -> Hash (cost=xxx rows=1 width=44)
25 -> Values Scan on "*VALUES*" (cost=xxx rows=1 width=44)
26 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1 width=15)
27 Index Cond: (c1 = t2.c1)
28 -> Values Scan on "*VALUES*_1" (cost=xxx rows=2 width=44)
32 --------------------------------------------------------------------------------------
33 Nested Loop (cost=xxx rows=1 width=117)
34 Join Filter: (t1.c1 = "*VALUES*_1".column1)
35 -> Nested Loop (cost=xxx rows=1 width=73)
36 -> Hash Join (cost=xxx rows=1 width=58)
37 Hash Cond: (t2.c1 = "*VALUES*".column1)
38 -> Seq Scan on t2 (cost=xxx rows=100 width=14)
39 -> Hash (cost=xxx rows=1 width=44)
40 -> Values Scan on "*VALUES*" (cost=xxx rows=1 width=44)
41 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1 width=15)
42 Index Cond: (c1 = t2.c1)
43 -> Values Scan on "*VALUES*_1" (cost=xxx rows=2 width=44)