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 ('{2939,3915,3914,3888,3864,3937,3939,3921,3931,3232,3461,3695,3778,3832,3849,3868,3923,3927,3938,3907}'::integer[])))