QUERY PLAN
HashAggregate (cost=1106.54..1110.04 rows=280 width=44)
Group Key: c.client_id
-> Hash Right Join (cost=917.51..1103.11 rows=458 width=20)
Hash Cond: (tbl_implement_records.case_id = c.id)
-> HashAggregate (cost=410.51..511.28 rows=6718 width=20)
Group Key: tbl_implement_records.case_id
-> Seq Scan on tbl_implement_records (cost=0.00..340.28 rows=7023 width=24)
Filter: (NOT is_draft)
-> Hash (cost=501.27..501.27 rows=458 width=8)
-> Seq Scan on tbl_cases c (cost=0.00..501.27 rows=458 width=8)
Filter: ((case_type = 2) AND (client_id = ANY ('{3354,399,2616,2538,146,1661,982,2166,1301,3330,2182,3411,304,402,3367,2242,3400,3342,3381,2699}'::integer[])))