| Bitmap Heap Scan on tbl_work_logs w (cost=79.01..1465.65 rows=1 width=20) |
| Recheck Cond: (created_by = 5295) |
| Filter: ((NOT is_draft) AND ((start_at IS NOT NULL) OR (end_at IS NOT NULL)) AND (((start_at >= '2025-06-01 00:00:00+08'::timestamp with time zone) AND (end_at < '2025-06-30 00:00:00+08'::timestamp with time zone)) OR ((start_at <= '2025-06-01 00:00:00+08'::timestamp with time zone) AND (end_at > '2025-06-01 00:00:00+08'::timestamp with time zone)) OR ((start_at <= '2025-06-30 00:00:00+08'::timestamp with time zone) AND (end_at > '2025-06-30 00:00:00+08'::timestamp with time zone)))) |
| -> Bitmap Index Scan on tbl_work_logs_created_by_idx (cost=0.00..79.01 rows=4096 width=0) |
| Index Cond: (created_by = 5295) |