| Sort (cost=281.74..281.74 rows=1 width=288) |
| Sort Key: start_at, updated_at DESC |
| -> Bitmap Heap Scan on tbl_work_logs (cost=95.44..281.73 rows=1 width=288) |
| Recheck Cond: ((created_by = ANY ('{1000,1001,1004,1005,1011,1013,1015,1022,1023,5016,5064,5085,5087,5248,5250,5252,5295,5300,5311,5332,5360,5446,5461,5476}'::integer[])) AND (created_by = 1001)) |
| Filter: ((NOT is_draft) AND (start_at >= '2024-12-16 00:00:00+08'::timestamp with time zone) AND (start_at < '2024-12-23 00:00:00'::timestamp without time zone)) |
| -> Bitmap Index Scan on tbl_work_logs_created_by_idx (cost=0.00..95.44 rows=55 width=0) |
| Index Cond: ((created_by = ANY ('{1000,1001,1004,1005,1011,1013,1015,1022,1023,5016,5064,5085,5087,5248,5250,5252,5295,5300,5311,5332,5360,5446,5461,5476}'::integer[])) AND (created_by = 1001)) |