Forum .LRN Q&A: Re: Bad performance in one query

Collapse
Posted by Jose Agustin Lopez Bueno on
Ok, the explain you want is:

------------------------------------------------
Sort  (cost=73802.62..73826.51 rows=9553 width=14)
  Sort Key: acs_object__name(ap.package_id)
  ->  Hash Join  (cost=4.04..73171.09 rows=9553 width=14)
        Hash Cond: (("outer".package_key)::text =
          ("inner".package_key)::text)
        ->  Seq Scan on apm_packages ap  (cost=0.00..72957.96
              rows=13157 width=14)
              Filter: (((package_key)::text <> 'acs-subsite'::text) OR
                  ((subplan) IS NULL))
              SubPlan
                ->  Index Scan using site_nodes_object_id_idx on site_nodes
                      (cost=0.00..5.52 rows=2 width=4)
                      Index Cond: (object_id = $0)
        ->  Hash  (cost=3.91..3.91 rows=53 width=16)
              ->  Seq Scan on apm_package_types  (cost=0.00..3.91
                        rows=53 width=16)
                    Filter: ((package_type)::text = 'apm_service'::text)

------------------------------------------------

Regards,
Agustin