QUERY PLAN
GroupAggregate (cost=650.96..651.25 rows=13 width=44)
Group Key: c.project_id
-> Sort (cost=650.96..650.99 rows=13 width=20)
Sort Key: c.project_id
-> Hash Right Join (cost=606.02..650.71 rows=13 width=20)
Hash Cond: (tbl_pre_sales.case_id = c.id)
-> HashAggregate (cost=104.58..128.85 rows=1618 width=20)
Group Key: tbl_pre_sales.case_id
-> Seq Scan on tbl_pre_sales (cost=0.00..88.30 rows=1628 width=24)
Filter: (NOT is_draft)
-> Hash (cost=501.27..501.27 rows=13 width=8)
-> Seq Scan on tbl_cases c (cost=0.00..501.27 rows=13 width=8)
Filter: ((case_type = 1) AND (project_id = ANY ('{3019,3027,2939,2893,2907,2759,2684,2695,2530,2508,2507,2504,2459,2458,2422,2080,2079,1983,1963,1938}'::integer[])))