| GroupAggregate (cost=5.12..147.58 rows=1 width=72) |
| Group Key: p.created_by |
| -> Bitmap Heap Scan on tbl_projects p (cost=5.12..147.55 rows=1 width=18) |
| Recheck Cond: (created_by = 1001) |
| Filter: ((bargain_date <@ '[2025-01-01,2026-01-01)'::daterange) AND (project_status = 3)) |
| -> Bitmap Index Scan on tbl_projects_created_by_idx (cost=0.00..5.12 rows=112 width=0) |
| Index Cond: (created_by = 1001) |