->  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)