QUERY PLAN
Sort (cost=103.72..103.72 rows=1 width=182)
Sort Key: set_top_at DESC NULLS LAST, (CASE WHEN is_complete THEN 3 WHEN ((NOT is_complete) AND (end_at <= now())) THEN 2 ELSE 1 END), (CASE WHEN is_complete THEN complete_at ELSE NULL::timestamp with time zone END) DESC, (CASE WHEN (NOT is_complete) THEN end_at ELSE NULL::timestamp with time zone END), end_at DESC
-> Index Scan using tbl_schedules_project_id_idx on tbl_schedules (cost=0.29..103.71 rows=1 width=182)
Index Cond: (project_id = ANY ('{1018,4184,4186,4126,2290,4024,4185,4182,4183,4181,4174,4146,3957,3796,3854,4173,4180,4179,4178,4177}'::integer[]))
Filter: (((NOT is_complete) OR (end_at >= '2026-06-15 00:00:00+08'::timestamp with time zone)) AND (((is_public = 1) AND (created_by <> 1001)) OR (created_by = 1001)))