QUERY PLAN
GroupAggregate (cost=516.99..517.17 rows=9 width=25)
Group Key: it.product_type_id, it.name
-> Sort (cost=516.99..517.02 rows=9 width=17)
Sort Key: it.product_type_id, it.name
-> Hash Join (cost=357.96..516.85 rows=9 width=17)
Hash Cond: (it.implement_id = tbl_implement_records.id)
-> Seq Scan on tbl_implement_product_types it (cost=0.00..137.28 rows=8228 width=21)
-> Hash (cost=357.86..357.86 rows=8 width=4)
-> Seq Scan on tbl_implement_records (cost=0.00..357.86 rows=8 width=4)
Filter: ((NOT is_draft) AND (client_id = 3462))