| Sort (cost=208.98..209.00 rows=5 width=98) |
| Sort Key: pt.id |
| -> Hash Left Join (cost=93.04..208.93 rows=5 width=98) |
| Hash Cond: (pt.taxonomy_id = tt.id) |
| -> Bitmap Heap Scan on tbl_term_taxonomy_relationships pt (cost=82.20..198.07 rows=5 width=51) |
| Recheck Cond: ((object_id = ANY ('{7852,7853,7851,7850,7849,7848,7847,7846,7845,7844,7843,7842,7841,7840,7839,7838,7837,7836,7835,7834}'::integer[])) AND (term_id = 18)) |
| Filter: (object_type = 11) |
| -> Bitmap Index Scan on tbl_term_taxonomy_relationships_object_id_term_id_idx (cost=0.00..82.20 rows=37 width=0) |
| Index Cond: ((object_id = ANY ('{7852,7853,7851,7850,7849,7848,7847,7846,7845,7844,7843,7842,7841,7840,7839,7838,7837,7836,7835,7834}'::integer[])) AND (term_id = 18)) |
| -> Hash (cost=7.04..7.04 rows=304 width=22) |
| -> Seq Scan on tbl_term_taxonomies tt (cost=0.00..7.04 rows=304 width=22) |