QUERY PLAN                                
-------------------------------------------------------------------------
 Hash Join  (cost=xxx rows=301 width=31)
   Hash Cond: (p2.c1 = p1.c1)
   ->  Append  (cost=xxx rows=304 width=16)
         ->  Seq Scan on p2  (cost=xxx rows=1 width=44)
         ->  Seq Scan on p2c1  (cost=xxx rows=1 width=44)
         ->  Seq Scan on p2c2  (cost=xxx rows=1 width=44)
         ->  Seq Scan on p2c3  (cost=xxx rows=1 width=44)
         ->  Seq Scan on p2c1c1  (cost=xxx rows=50 width=14)
         ->  Seq Scan on p2c1c2  (cost=xxx rows=50 width=15)
         ->  Seq Scan on p2c2c1  (cost=xxx rows=50 width=16)
         ->  Seq Scan on p2c2c2  (cost=xxx rows=50 width=16)
         ->  Seq Scan on p2c3c1  (cost=xxx rows=50 width=16)
         ->  Seq Scan on p2c3c2  (cost=xxx rows=50 width=16)
   ->  Hash  (cost=xxx rows=301 width=15)
         ->  Append  (cost=xxx rows=301 width=15)
               ->  Seq Scan on p1  (cost=xxx rows=1 width=44)
               ->  Seq Scan on p1c1  (cost=xxx rows=100 width=14)
               ->  Seq Scan on p1c2  (cost=xxx rows=100 width=16)
               ->  Seq Scan on p1c3  (cost=xxx rows=100 width=16)
(19 rows)

                               QUERY PLAN                                
-------------------------------------------------------------------------
 Hash Join  (cost=xxx rows=1 width=31)
   Hash Cond: (p2.c1 = p1.c1)
   ->  Append  (cost=xxx rows=304 width=16)
         ->  Seq Scan on p2  (cost=xxx rows=1 width=44)
         ->  Seq Scan on p2c1  (cost=xxx rows=1 width=44)
         ->  Seq Scan on p2c2  (cost=xxx rows=1 width=44)
         ->  Seq Scan on p2c3  (cost=xxx rows=1 width=44)
         ->  Seq Scan on p2c1c1  (cost=xxx rows=50 width=14)
         ->  Seq Scan on p2c1c2  (cost=xxx rows=50 width=15)
         ->  Seq Scan on p2c2c1  (cost=xxx rows=50 width=16)
         ->  Seq Scan on p2c2c2  (cost=xxx rows=50 width=16)
         ->  Seq Scan on p2c3c1  (cost=xxx rows=50 width=16)
         ->  Seq Scan on p2c3c2  (cost=xxx rows=50 width=16)
   ->  Hash  (cost=xxx rows=301 width=15)
         ->  Append  (cost=xxx rows=301 width=15)
               ->  Seq Scan on p1  (cost=xxx rows=1 width=44)
               ->  Seq Scan on p1c1  (cost=xxx rows=100 width=14)
               ->  Seq Scan on p1c2  (cost=xxx rows=100 width=16)
               ->  Seq Scan on p1c3  (cost=xxx rows=100 width=16)
(19 rows)