QUERY PLAN
GroupAggregate (cost=519.87..520.07 rows=10 width=25)
Group Key: it.product_type_id, it.name
-> Sort (cost=519.87..519.90 rows=10 width=17)
Sort Key: it.product_type_id, it.name
-> Hash Join (cost=357.95..519.71 rows=10 width=17)
Hash Cond: (it.implement_id = tbl_implement_records.id)
-> Seq Scan on tbl_implement_product_types it (cost=0.00..139.76 rows=8376 width=21)
-> Hash (cost=357.85..357.85 rows=8 width=4)
-> Seq Scan on tbl_implement_records (cost=0.00..357.85 rows=8 width=4)
Filter: ((NOT is_draft) AND (client_id = 3461))