QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Hash Right Join  (cost=4229.78..4251.54 rows=3 width=65) (actual time=37.091..37.095 rows=0 loops=1)
   Hash Cond: (t7.fldtmp2 = t1.fld2)
   ->  Seq Scan on tt4 t7  (cost=0.00..18.00 rows=1000 width=25) (never executed)
   ->  Hash  (cost=4229.74..4229.74 rows=3 width=57) (actual time=37.076..37.080 rows=0 loops=1)
         Buckets: 1024  Batches: 1  Memory Usage: 8kB
         ->  Hash Right Join  (cost=4207.98..4229.74 rows=3 width=57) (actual time=37.076..37.080 rows=0 loops=1)
               Hash Cond: (t6.fldtmp2 = t1.fld2)
               ->  Seq Scan on tt6 t6  (cost=0.00..18.00 rows=1000 width=25) (never executed)
               ->  Hash  (cost=4207.94..4207.94 rows=3 width=49) (actual time=37.066..37.070 rows=0 loops=1)
                     Buckets: 1024  Batches: 1  Memory Usage: 8kB
                     ->  Hash Semi Join  (cost=122.05..4207.94 rows=3 width=49) (actual time=37.066..37.069 rows=0 loops=1)
                           Hash Cond: (t1.fld2 = "*VALUES*".column1)
                           ->  Hash Left Join  (cost=122.00..3945.36 rows=100000 width=49) (actual time=0.575..33.126 rows=101020 loops=1)
                                 Hash Cond: (t1.fld2 = t5.fldtmp2)
                                 ->  Hash Left Join  (cost=91.50..3401.02 rows=100000 width=41) (actual time=0.430..26.265 rows=100476 loops=1)
                                       Hash Cond: (t1.fld2 = t4.fldtmp2)
                                       ->  Hash Left Join  (cost=61.00..2856.68 rows=100000 width=33) (actual time=0.278..19.463 rows=100204 loops=1)
                                             Hash Cond: (t1.fld2 = t3.fldtmp2)
                                             ->  Hash Left Join  (cost=30.50..2312.34 rows=100000 width=25) (actual time=0.148..12.776 rows=100068 loops=1)
                                                   Hash Cond: (t1.fld2 = t2.fldtmp2)
                                                   ->  Seq Scan on table1 t1  (cost=0.00..1768.00 rows=100000 width=17) (actual time=0.005..4.784 rows=100000 loops=1)
                                                   ->  Hash  (cost=18.00..18.00 rows=1000 width=25) (actual time=0.131..0.132 rows=1000 loops=1)
                                                         Buckets: 1024  Batches: 1  Memory Usage: 64kB
                                                         ->  Seq Scan on tt1 t2  (cost=0.00..18.00 rows=1000 width=25) (actual time=0.004..0.046 rows=1000 loops=1)
                                             ->  Hash  (cost=18.00..18.00 rows=1000 width=25) (actual time=0.122..0.122 rows=1000 loops=1)
                                                   Buckets: 1024  Batches: 1  Memory Usage: 64kB
                                                   ->  Seq Scan on tt2 t3  (cost=0.00..18.00 rows=1000 width=25) (actual time=0.003..0.045 rows=1000 loops=1)
                                       ->  Hash  (cost=18.00..18.00 rows=1000 width=25) (actual time=0.141..0.141 rows=1000 loops=1)
                                             Buckets: 1024  Batches: 1  Memory Usage: 64kB
                                             ->  Seq Scan on tt3 t4  (cost=0.00..18.00 rows=1000 width=25) (actual time=0.002..0.047 rows=1000 loops=1)
                                 ->  Hash  (cost=18.00..18.00 rows=1000 width=25) (actual time=0.129..0.129 rows=1000 loops=1)
                                       Buckets: 1024  Batches: 1  Memory Usage: 64kB
                                       ->  Seq Scan on tt5 t5  (cost=0.00..18.00 rows=1000 width=25) (actual time=0.006..0.050 rows=1000 loops=1)
                           ->  Hash  (cost=0.03..0.03 rows=2 width=32) (actual time=0.005..0.005 rows=2 loops=1)
                                 Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                 ->  Values Scan on "*VALUES*"  (cost=0.00..0.03 rows=2 width=32) (actual time=0.001..0.002 rows=2 loops=1)
 Planning Time: 0.588 ms
 Execution Time: 37.161 ms
(38 rows)