| GroupAggregate (cost=23.47..23.52 rows=1 width=36) |
| Group Key: p.client_id, ttr.taxonomy_id, tt.name |
| -> Sort (cost=23.47..23.48 rows=1 width=40) |
| Sort Key: ttr.taxonomy_id, tt.name |
| -> Nested Loop Left Join (cost=4.73..23.46 rows=1 width=40) |
| -> Nested Loop (cost=4.59..23.20 rows=1 width=28) |
| -> Bitmap Heap Scan on tbl_projects p (cost=4.30..11.62 rows=1 width=8) |
| Recheck Cond: (client_id = 1389) |
| Filter: (project_status = 3) |
| -> Bitmap Index Scan on tbl_projects_client_id_idx (cost=0.00..4.29 rows=2 width=0) |
| Index Cond: (client_id = 1389) |
| -> Index Scan using tbl_term_taxonomy_relationships_object_id_term_id_idx on tbl_term_taxonomy_relationships ttr (cost=0.29..11.56 rows=1 width=28) |
| Index Cond: ((object_id = p.id) AND (term_id = 1)) |
| Filter: ((taxonomy_id IS NOT NULL) AND (value IS NOT NULL) AND (object_type = 1)) |
| -> Index Scan using tbl_term_taxonomies_pkey on tbl_term_taxonomies tt (cost=0.15..0.27 rows=1 width=16) |
| Index Cond: (ttr.taxonomy_id = id) |