Aggregate (cost=144.12..144.13 rows=1 width=112) |
-> Bitmap Heap Scan on tbl_projects p (cost=5.11..143.99 rows=7 width=22) |
Recheck Cond: (created_by = 1001) |
Filter: ((bargain_date >= '2024-01-01'::date) AND (bargain_date < '2025-01-01 00:00:00'::timestamp without time zone) AND (project_status = 3)) |
-> Bitmap Index Scan on tbl_projects_created_by_idx (cost=0.00..5.11 rows=110 width=0) |
Index Cond: (created_by = 1001) |