QUERY PLAN
GroupAggregate (cost=212.27..212.36 rows=1 width=72)
Group Key: p.created_by, (CASE WHEN ((p.bargain_date >= '2025-01-01'::date) AND (p.bargain_date <= '2025-01-31'::date)) THEN 1 WHEN ((p.bargain_date >= '2025-02-01'::date) AND (p.bargain_date <= '2025-02-28'::date)) THEN 2 WHEN ((p.bargain_date >= '2025-03-01'::date) AND (p.bargain_date <= '2025-03-31'::date)) THEN 3 WHEN ((p.bargain_date >= '2025-04-01'::date) AND (p.bargain_date <= '2025-04-30'::date)) THEN 4 WHEN ((p.bargain_date >= '2025-05-01'::date) AND (p.bargain_date <= '2025-05-31'::date)) THEN 5 WHEN ((p.bargain_date >= '2025-06-01'::date) AND (p.bargain_date <= '2025-06-30'::date)) THEN 6 WHEN ((p.bargain_date >= '2025-07-01'::date) AND (p.bargain_date <= '2025-07-31'::date)) THEN 7 WHEN ((p.bargain_date >= '2025-08-01'::date) AND (p.bargain_date <= '2025-08-31'::date)) THEN 8 WHEN ((p.bargain_date >= '2025-09-01'::date) AND (p.bargain_date <= '2025-09-30'::date)) THEN 9 WHEN ((p.bargain_date >= '2025-10-01'::date) AND (p.bargain_date <= '2025-10-31'::date)) THEN 10 WHEN ((p.bargain_date >= '2025-11-01'::date) AND (p.bargain_date <= '2025-11-30'::date)) THEN 11 WHEN ((p.bargain_date >= '2025-12-01'::date) AND (p.bargain_date <= '2025-12-31'::date)) THEN 12 ELSE NULL::integer END)
-> Sort (cost=212.27..212.27 rows=1 width=18)
Sort Key: (CASE WHEN ((p.bargain_date >= '2025-01-01'::date) AND (p.bargain_date <= '2025-01-31'::date)) THEN 1 WHEN ((p.bargain_date >= '2025-02-01'::date) AND (p.bargain_date <= '2025-02-28'::date)) THEN 2 WHEN ((p.bargain_date >= '2025-03-01'::date) AND (p.bargain_date <= '2025-03-31'::date)) THEN 3 WHEN ((p.bargain_date >= '2025-04-01'::date) AND (p.bargain_date <= '2025-04-30'::date)) THEN 4 WHEN ((p.bargain_date >= '2025-05-01'::date) AND (p.bargain_date <= '2025-05-31'::date)) THEN 5 WHEN ((p.bargain_date >= '2025-06-01'::date) AND (p.bargain_date <= '2025-06-30'::date)) THEN 6 WHEN ((p.bargain_date >= '2025-07-01'::date) AND (p.bargain_date <= '2025-07-31'::date)) THEN 7 WHEN ((p.bargain_date >= '2025-08-01'::date) AND (p.bargain_date <= '2025-08-31'::date)) THEN 8 WHEN ((p.bargain_date >= '2025-09-01'::date) AND (p.bargain_date <= '2025-09-30'::date)) THEN 9 WHEN ((p.bargain_date >= '2025-10-01'::date) AND (p.bargain_date <= '2025-10-31'::date)) THEN 10 WHEN ((p.bargain_date >= '2025-11-01'::date) AND (p.bargain_date <= '2025-11-30'::date)) THEN 11 WHEN ((p.bargain_date >= '2025-12-01'::date) AND (p.bargain_date <= '2025-12-31'::date)) THEN 12 ELSE NULL::integer END)
-> Bitmap Heap Scan on tbl_projects p (cost=5.08..212.26 rows=1 width=18)
Recheck Cond: (created_by = 1001)
Filter: ((bargain_date >= '2025-01-01'::date) AND (bargain_date <= '2025-12-31'::date) AND (project_status = 2))
-> Bitmap Index Scan on tbl_projects_created_by_idx (cost=0.00..5.08 rows=107 width=0)
Index Cond: (created_by = 1001)