QUERY PLAN

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------
 Hash Right Join  (cost=134.41..158.66 rows=3 width=65) (actual time=0.070..0.072 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=134.37..134.37 rows=3 width=57) (actual time=0.061..0.062 rows=0 loops=1)
         Buckets: 1024  Batches: 1  Memory Usage: 8kB
         ->  Hash Right Join  (cost=110.11..134.37 rows=3 width=57) (actual time=0.061..0.062 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=110.07..110.07 rows=3 width=49) (actual time=0.052..0.053 rows=0 loops=1)
                     Buckets: 1024  Batches: 1  Memory Usage: 8kB
                     ->  Hash Right Join  (cost=85.81..110.07 rows=3 width=49) (actual time=0.052..0.053 rows=0 loops=1)
                           Hash Cond: (t5.fldtmp2 = t1.fld2)
                           ->  Seq Scan on tt5 t5  (cost=0.00..18.00 rows=1000 width=25) (never executed)
                           ->  Hash  (cost=85.77..85.77 rows=3 width=41) (actual time=0.044..0.045 rows=0 loops=1)
                                 Buckets: 1024  Batches: 1  Memory Usage: 8kB
                                 ->  Hash Right Join  (cost=61.51..85.77 rows=3 width=41) (actual time=0.043..0.045 rows=0 loops=1)
                                       Hash Cond: (t4.fldtmp2 = t1.fld2)
                                       ->  Seq Scan on tt3 t4  (cost=0.00..18.00 rows=1000 width=25) (never executed)
                                       ->  Hash  (cost=61.48..61.48 rows=3 width=33) (actual time=0.033..0.034 rows=0 loops=1)
                                             Buckets: 1024  Batches: 1  Memory Usage: 8kB
                                             ->  Hash Right Join  (cost=37.22..61.48 rows=3 width=33) (actual time=0.033..0.034 rows=0 loops=1)
                                                   Hash Cond: (t3.fldtmp2 = t1.fld2)
                                                   ->  Seq Scan on tt2 t3  (cost=0.00..18.00 rows=1000 width=25) (never executed)
                                                   ->  Hash  (cost=37.18..37.18 rows=3 width=25) (actual time=0.025..0.026 rows=0 loops=1)
                                                         Buckets: 1024  Batches: 1  Memory Usage: 8kB
                                                         ->  Hash Right Join  (cost=12.92..37.18 rows=3 width=25) (actual time=0.025..0.026 rows=0 loops=1)
                                                               Hash Cond: (t2.fldtmp2 = t1.fld2)
                                                               ->  Seq Scan on tt1 t2  (cost=0.00..18.00 rows=1000 width=25) (never executed)
                                                               ->  Hash  (cost=12.88..12.88 rows=3 width=17) (actual time=0.016..0.016 rows=0 loops=1)
                                                                     Buckets: 1024  Batches: 1  Memory Usage: 8kB
                                                                     ->  Index Only Scan using table1index on table1 t1  (cost=0.42..12.88 rows=3 width=17) (actual time=0.
016..0.016 rows=0 loops=1)
                                                                           Index Cond: (fld2 = ANY ('{"\\x5c3233305c3231315c303330665c3333325c323631525c3333335c3032315c333
5365c3333377a355c3333365c3033325c333732","\\x5c3233355c323034205c3030345c3031375c3335335c3330315c3230305c3032315c3335356126647d5c3234355c333132"}'::bytea[]))
                                                                           Heap Fetches: 0
 Planning Time: 0.564 ms
 Execution Time: 0.133 ms
(35 rows)