| GroupAggregate (cost=5.38..159.11 rows=1 width=72) |
| Group Key: p.created_by |
| -> Bitmap Heap Scan on tbl_projects p (cost=5.38..159.08 rows=1 width=18) |
| Recheck Cond: (created_by = 1001) |
| Filter: ((bargain_date <@ '[2026-01-01,2027-01-01)'::daterange) AND (project_status = 2)) |
| -> Bitmap Index Scan on tbl_projects_created_by_idx (cost=0.00..5.38 rows=147 width=0) |
| Index Cond: (created_by = 1001) |