QUERY PLAN
GroupAggregate (cost=612.03..612.30 rows=12 width=44)
Group Key: c.project_id
-> Sort (cost=612.03..612.06 rows=12 width=20)
Sort Key: c.project_id
-> Hash Right Join (cost=568.55..611.81 rows=12 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=12 width=8)
-> Seq Scan on tbl_cases c (cost=0.00..466.86 rows=12 width=8)
Filter: ((case_type = 1) AND (project_id = ANY ('{3256,3935,3599,3477,3483,3458,3433,3423,3402,3381,3250,3379,3315,3357,3320,3165,3300,3239,3276,3252}'::integer[])))