QUERY PLAN
Sort (cost=112.24..112.24 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..112.23 rows=1 width=182)
Index Cond: (project_id = ANY ('{3197,3927,3915,263,2914,3837,2939,3751,3934,3883,3930,3665,3150,3910,3922,3932,3911,3933,3895,3908}'::integer[]))
Filter: (((NOT is_complete) OR (end_at >= '2025-07-27 00:00:00+08'::timestamp with time zone)) AND (((is_public = 1) AND (created_by <> 1001)) OR (created_by = 1001)))