plan_with_patch.txt
text/plain
Filename: plan_with_patch.txt
Type: text/plain
Part: 2
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)