QUERY PLAN
Sort (cost=213.89..213.90 rows=5 width=98)
Sort Key: pt.id
-> Hash Left Join (cost=11.20..213.83 rows=5 width=98)
Hash Cond: (pt.taxonomy_id = tt.id)
-> Index Scan using tbl_term_taxonomy_relationships_object_id_term_id_idx on tbl_term_taxonomy_relationships pt (cost=0.29..202.91 rows=5 width=51)
Index Cond: ((object_id = ANY ('{8489,8488,8487,8486,8485,8484,8483,8482,8480,8479,8474,8472,8471,8470,8469,8467,8466,8465,8461,8460}'::integer[])) AND (term_id = 18))
Filter: (object_type = 11)
-> Hash (cost=7.07..7.07 rows=307 width=22)
-> Seq Scan on tbl_term_taxonomies tt (cost=0.00..7.07 rows=307 width=22)