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