QUERY PLAN
GroupAggregate (cost=4.34..31.02 rows=1 width=12)
Group Key: p.project_status
-> Bitmap Heap Scan on tbl_projects p (cost=4.34..31.00 rows=1 width=4)
Recheck Cond: (client_id = 982)
Filter: ((bargain_date >= '2026-01-01'::date) AND (bargain_date < '2027-01-01 00:00:00'::timestamp without time zone) AND (created_by = 1001) AND (project_status = 3) AND (created_by = ANY ('{5332,1001,5087,5467,5300,5311,5295,1013,5476,1004,1005,5449}'::integer[])))
-> Bitmap Index Scan on tbl_projects_client_id_idx (cost=0.00..4.34 rows=8 width=0)
Index Cond: (client_id = 982)