QUERY PLAN
GroupAggregate (cost=1489.85..1489.87 rows=1 width=48)
Group Key: dg.id
-> Sort (cost=1489.85..1489.85 rows=1 width=286)
Sort Key: dg.id
-> Nested Loop Left Join (cost=0.00..1489.84 rows=1 width=286)
Join Filter: (d.document_type_id = dg.id)
-> Nested Loop (cost=0.00..1488.41 rows=1 width=12)
Join Filter: (d.id = dt.object_id)
-> Seq Scan on tbl_term_taxonomy_relationships dt (cost=0.00..1470.28 rows=1 width=4)
Filter: ((term_id = 7) AND (taxonomy_id = 116))
-> Seq Scan on tbl_documents d (cost=0.00..12.50 rows=450 width=16)
-> Seq Scan on tbl_document_types dg (cost=0.00..1.19 rows=19 width=278)