QUERY PLAN
Sort (cost=213.87..213.88 rows=5 width=100)
Sort Key: pt.id
-> Hash Left Join (cost=11.20..213.81 rows=5 width=100)
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.89 rows=5 width=52)
Index Cond: ((object_id = ANY ('{8489,8488,8487,8486,8485,8484,8482,8480,8474,8435,8421,8420,8419,8418,8363,8367,8366,8365,8364,8362}'::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)