QUERY PLAN
GroupAggregate (cost=610.21..610.46 rows=11 width=44)
Group Key: c.project_id
-> Sort (cost=610.21..610.24 rows=11 width=20)
Sort Key: c.project_id
-> Hash Right Join (cost=566.84..610.02 rows=11 width=20)
Hash Cond: (tbl_pre_sales.case_id = c.id)
-> HashAggregate (cost=101.48..124.92 rows=1563 width=20)
Group Key: tbl_pre_sales.case_id
-> Seq Scan on tbl_pre_sales (cost=0.00..85.75 rows=1573 width=24)
Filter: (NOT is_draft)
-> Hash (cost=465.22..465.22 rows=11 width=8)
-> Seq Scan on tbl_cases c (cost=0.00..465.22 rows=11 width=8)
Filter: ((case_type = 1) AND (project_id = ANY ('{3927,3751,3899,3890,3886,3872,3857,3855,3816,3813,3786,3767,3764,3760,3752,3744,3723,3714,3679,3653}'::integer[])))