QUERY PLAN
GroupAggregate (cost=8.18..8.20 rows=1 width=12)
Group Key: p.project_status
-> Sort (cost=8.18..8.18 rows=1 width=4)
Sort Key: p.project_status
-> Index Scan using tbl_projects_created_by_idx on tbl_projects p (cost=0.14..8.17 rows=1 width=4)
Index Cond: (created_by = 5495)
Filter: ((project_status <> 1) AND (bargain_date >= '2026-06-02'::date) AND (bargain_date <= '2026-06-02'::date))