QUERY PLAN
GroupAggregate (cost=481.68..481.84 rows=8 width=25)
Group Key: it.product_type_id, it.name
-> Sort (cost=481.68..481.70 rows=8 width=17)
Sort Key: it.product_type_id, it.name
-> Hash Join (cost=332.59..481.56 rows=8 width=17)
Hash Cond: (it.implement_id = tbl_implement_records.id)
-> Seq Scan on tbl_implement_product_types it (cost=0.00..128.80 rows=7680 width=21)
-> Hash (cost=332.50..332.50 rows=7 width=4)
-> Seq Scan on tbl_implement_records (cost=0.00..332.50 rows=7 width=4)
Filter: ((NOT is_draft) AND (client_id = 1661))