QUERY PLAN
Unique (cost=287609.37..287903.37 rows=39200 width=17)
-> Sort (cost=287609.37..287707.37 rows=39200 width=17)
Sort Key: (date(tt.dt)) DESC, (CASE WHEN ((count(cl.alarm_before) <> 0) OR (count(sh.alarm_before) <> 0)) THEN true ELSE false END)
-> GroupAggregate (cost=280073.39..284618.69 rows=39200 width=17)
Group Key: tt.dt, cl.id
-> Sort (cost=280073.39..280845.25 rows=308744 width=44)
Sort Key: tt.dt, cl.id
-> Nested Loop Left Join (cost=4.55..242423.03 rows=308744 width=44)
Join Filter: ((((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone >= cl.start_at) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone <= cl.end_at)) OR (((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone <= cl.start_at) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone >= cl.start_at)) OR (((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone <= cl.end_at) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone >= cl.end_at)))
Filter: (((cl.start_at - cl.alarm_before) > '2025-08-08 11:00:04+08'::timestamp with time zone) OR ((sh.start_at - sh.alarm_before) > '2025-08-08 11:00:04+08'::timestamp with time zone))
-> Nested Loop Left Join (cost=4.55..3873.27 rows=9525 width=32)
Join Filter: ((((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone >= sh.start_at) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone <= sh.end_at)) OR (((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone <= sh.start_at) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone >= sh.start_at)) OR (((((date(tt.dt))::text || ' 00:00:00'::text))::timestamp without time zone <= sh.end_at) AND ((((date(tt.dt))::text || ' 23:59:59'::text))::timestamp without time zone >= sh.end_at)))
-> Function Scan on generate_series tt (cost=0.02..10.02 rows=1000 width=8)
-> Materialize (cost=4.53..103.33 rows=32 width=32)
-> Bitmap Heap Scan on tbl_schedules sh (cost=4.53..103.17 rows=32 width=32)
Recheck Cond: (created_by = 1000)
-> Bitmap Index Scan on tbl_schedules_created_by_idx (cost=0.00..4.53 rows=32 width=0)
Index Cond: (created_by = 1000)
-> Materialize (cost=0.00..520.50 rows=196 width=36)
-> Seq Scan on tbl_calendars cl (cost=0.00..519.52 rows=196 width=36)
Filter: (created_by = 1000)