QUERY PLAN
GroupAggregate (cost=611.99..612.24 rows=11 width=44)
Group Key: c.project_id
-> Sort (cost=611.99..612.02 rows=11 width=20)
Sort Key: c.project_id
-> Hash Right Join (cost=568.54..611.80 rows=11 width=20)
Hash Cond: (tbl_pre_sales.case_id = c.id)
-> HashAggregate (cost=101.54..125.03 rows=1566 width=20)
Group Key: tbl_pre_sales.case_id
-> Seq Scan on tbl_pre_sales (cost=0.00..85.78 rows=1576 width=24)
Filter: (NOT is_draft)
-> Hash (cost=466.86..466.86 rows=11 width=8)
-> Seq Scan on tbl_cases c (cost=0.00..466.86 rows=11 width=8)
Filter: ((case_type = 1) AND (project_id = ANY ('{3935,3927,3751,3899,3890,3886,3872,3857,3855,3816,3786,3767,3764,3760,3752,3744,3723,3714,3679,3653}'::integer[])))