| GroupAggregate (cost=448.56..449.80 rows=62 width=25) |
| Group Key: it.product_type_id, it.name |
| -> Sort (cost=448.56..448.71 rows=62 width=17) |
| Sort Key: it.product_type_id, it.name |
| -> Hash Join (cost=308.90..446.71 rows=62 width=17) |
| Hash Cond: (it.implement_id = tbl_implement_records.id) |
| -> Seq Scan on tbl_implement_product_types it (cost=0.00..119.13 rows=7113 width=21) |
| -> Hash (cost=308.23..308.23 rows=54 width=4) |
| -> Seq Scan on tbl_implement_records (cost=0.00..308.23 rows=54 width=4) |
| Filter: ((NOT is_draft) AND (client_id = 982)) |