Untitled
public text v1 · immutable
-> Merge Full Join (cost=2860
.72..2880.04 rows=1083 width=95)
Merge Cond: ("outer"."?co
lumn3?" = "inner".msisdn)
-> Sort (cost=2665.53..
2665.55 rows=6 width=40)
Sort Key: (smsdn.dn
)::numeric
-> Subquery Scan s
msdn (cost=2665.32..2665.45 rows=6 width=40)
-> HashAggre
gate (cost=2665.32..2665.39 rows=6 width=34)
-> Seq
Scan on raw3 (cost=0.00..2661.01 rows=861 width=34)
F
ilter: (rtype ~* 'sms'::text)
-> Sort (cost=195.19..1
97.90 rows=1083 width=87)
Sort Key: sims.msis
dn
-> Merge Full Join
(cost=122.46..140.60 rows=1083 width=87)
Merge Cond: (
"outer".plan_num = "inner".plan_num)
-> Sort (co
st=30.08..31.03 rows=380 width=48)
Sort Ke
y: plans.plan_num
-> Seq
Scan on plans (cost=0.00..13.80 rows=380 width=48)
-> Sort (co
st=92.38..93.80 rows=570 width=47)
Sort Ke
y: sims.plan_num
-> Mer
ge Full Join (cost=56.25..66.28 rows=570 width=47)
M
erge Cond: ("outer".dn = "inner"."?column4?")
-
> Sort (cost=14.46..14.86 rows=160 width=40)
Sort Key: users2.dn
-> Seq Scan on users2 (cost=0.00..8.60 rows=160 width=40)
-
> Sort (cost=41.79..43.22 rows=570 width=21)
Sort Key: (sims.msisdn)::text
-> Seq Scan on sims (cost=0.00..15.70 rows=570 width=21)