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
