EXPLAIN SELECT
    pshai.simple_fault.id AS fault_id,
    pshai.simple_fault.owner_id AS fault_owner_id,
    pshai.simple_fault.gid AS fault_gid,
    pshai.simple_fault.name AS fault_name,
    pshai.simple_fault.description, pshai.simple_fault.dip,
    pshai.simple_fault.upper_depth, pshai.simple_fault.lower_depth,
    pshai.simple_fault.mfd_tgr_id, pshai.simple_fault.mfd_evd_id,
    pshai.simple_fault.last_update AS fault_last_update,
    pshai.simple_fault.edge, pshai.simple_fault.outline,
    pshai.mfd_evd.id AS mfd_evd_id,
    pshai.mfd_evd.owner_id AS mfd_evd_owner_id,
    pshai.mfd_evd.magnitude_type AS mfd_evd_magnitude_type,
    pshai.mfd_evd.min_val AS mfd_evd_min_val,
    pshai.mfd_evd.max_val AS mfd_evd_max_val,
    pshai.mfd_evd.bin_size AS mfd_evd_bin_size,
    pshai.mfd_evd.mfd_values AS mfd_evd_mfd_values,
    pshai.mfd_evd.total_cumulative_rate AS mfd_evd_total_cumulative_rate,
    pshai.mfd_evd.total_moment_rate AS mfd_evd_total_moment_rate,
    pshai.mfd_evd.last_update AS mfd_evd_last_update,
    pshai.mfd_tgr.id AS mfd_tgr_id,
    pshai.mfd_tgr.owner_id AS mfd_tgr_owner_id,
    pshai.mfd_tgr.magnitude_type AS mfd_tgr_magnitude_type,
    pshai.mfd_tgr.min_val AS mfd_tgr_min_val,
    pshai.mfd_tgr.max_val AS mfd_tgr_max_val,
    pshai.mfd_tgr.a_val AS mfd_tgr_a_val,
    pshai.mfd_tgr.b_val AS mfd_tgr_b_val,
    pshai.mfd_tgr.total_cumulative_rate AS mfd_tgr_total_cumulative_rate,
    pshai.mfd_tgr.total_moment_rate AS mfd_tgr_total_moment_rate,
    pshai.mfd_tgr.last_update AS mfd_tgr_last_update
FROM
    pshai.simple_fault
FULL OUTER JOIN pshai.mfd_tgr ON pshai.mfd_tgr.id = pshai.simple_fault.mfd_tgr_id
FULL OUTER JOIN pshai.mfd_evd ON pshai.mfd_evd.id = pshai.simple_fault.mfd_evd_id;
                                             QUERY PLAN
----------------------------------------------------------------------------------------------------
 MERGE FULL JOIN  (cost=1114786.37..1114825.83 ROWS=5523 width=78789)
   MERGE Cond: (simple_fault.mfd_evd_id = mfd_evd.id)
   ->  Sort  (cost=1114656.94..1114670.75 ROWS=5523 width=78632)
         Sort KEY: simple_fault.mfd_evd_id
         ->  MERGE FULL JOIN  (cost=557213.02..557498.65 ROWS=5523 width=78632)
               MERGE Cond: (mfd_tgr.id = simple_fault.mfd_tgr_id)
               ->  INDEX Scan USING mfd_tgr_pkey ON mfd_tgr  (cost=0.00..164.85 ROWS=3973 width=67)
               ->  Materialize  (cost=557213.02..557282.06 ROWS=5523 width=78565)
                     ->  Sort  (cost=557213.02..557226.83 ROWS=5523 width=78565)
                           Sort KEY: simple_fault.mfd_tgr_id
                           ->  Seq Scan ON simple_fault  (cost=0.00..506.23 ROWS=5523 width=78565)
   ->  Sort  (cost=129.43..133.16 ROWS=1490 width=157)
         Sort KEY: mfd_evd.id
         ->  Seq Scan ON mfd_evd  (cost=0.00..50.90 ROWS=1490 width=157)