| Result (cost=10.10..10.11 rows=1 width=1) |
| InitPlan 1 (returns $0) |
| -> Seq Scan on tbl_punch_leaves (cost=0.00..10.10 rows=1 width=0) |
| Filter: ((created_by = 5064) AND (status = 1) AND (((leave_start < '2025-12-24'::date) AND (leave_end > '2025-12-24'::date)) OR ((leave_end = '2025-12-24'::date) AND (leave_end_type = 2)) OR ((leave_start = '2025-12-24'::date) AND (leave_start_type = 2)) OR ((leave_start = '2025-12-24'::date) AND (leave_start_type = 1) AND (leave_end <> '2025-12-24'::date)) OR ((leave_start <= '2025-12-24'::date) AND (leave_end >= '2025-12-24'::date) AND (leave_start_time IS NOT NULL)))) |