2 -------------------------------------------------------------------------
3 Hash Join (cost=xxx rows=301 width=31)
4 Hash Cond: (p2.c1 = p1.c1)
5 -> Append (cost=xxx rows=304 width=16)
6 -> Seq Scan on p2 (cost=xxx rows=1 width=44)
7 -> Seq Scan on p2c1 (cost=xxx rows=1 width=44)
8 -> Seq Scan on p2c2 (cost=xxx rows=1 width=44)
9 -> Seq Scan on p2c3 (cost=xxx rows=1 width=44)
10 -> Seq Scan on p2c1c1 (cost=xxx rows=50 width=14)
11 -> Seq Scan on p2c1c2 (cost=xxx rows=50 width=15)
12 -> Seq Scan on p2c2c1 (cost=xxx rows=50 width=16)
13 -> Seq Scan on p2c2c2 (cost=xxx rows=50 width=16)
14 -> Seq Scan on p2c3c1 (cost=xxx rows=50 width=16)
15 -> Seq Scan on p2c3c2 (cost=xxx rows=50 width=16)
16 -> Hash (cost=xxx rows=301 width=15)
17 -> Append (cost=xxx rows=301 width=15)
18 -> Seq Scan on p1 (cost=xxx rows=1 width=44)
19 -> Seq Scan on p1c1 (cost=xxx rows=100 width=14)
20 -> Seq Scan on p1c2 (cost=xxx rows=100 width=16)
21 -> Seq Scan on p1c3 (cost=xxx rows=100 width=16)
25 -------------------------------------------------------------------------
26 Hash Join (cost=xxx rows=301 width=31)
27 Hash Cond: (p2.c1 = p1.c1)
28 -> Append (cost=xxx rows=304 width=16)
29 -> Seq Scan on p2 (cost=xxx rows=1 width=44)
30 -> Seq Scan on p2c1 (cost=xxx rows=1 width=44)
31 -> Seq Scan on p2c2 (cost=xxx rows=1 width=44)
32 -> Seq Scan on p2c3 (cost=xxx rows=1 width=44)
33 -> Seq Scan on p2c1c1 (cost=xxx rows=50 width=14)
34 -> Seq Scan on p2c1c2 (cost=xxx rows=50 width=15)
35 -> Seq Scan on p2c2c1 (cost=xxx rows=50 width=16)
36 -> Seq Scan on p2c2c2 (cost=xxx rows=50 width=16)
37 -> Seq Scan on p2c3c1 (cost=xxx rows=50 width=16)
38 -> Seq Scan on p2c3c2 (cost=xxx rows=50 width=16)
39 -> Hash (cost=xxx rows=301 width=15)
40 -> Append (cost=xxx rows=301 width=15)
41 -> Seq Scan on p1 (cost=xxx rows=1 width=44)
42 -> Seq Scan on p1c1 (cost=xxx rows=100 width=14)
43 -> Seq Scan on p1c2 (cost=xxx rows=100 width=16)
44 -> Seq Scan on p1c3 (cost=xxx rows=100 width=16)