QUERY PLAN
Seq Scan on tbl_calendars c (cost=0.00..1010.39 rows=4 width=20)
Filter: (((start_at IS NOT NULL) OR (end_at IS NOT NULL)) AND (created_by = 1015) AND (created_by = ANY ('{1015,1015,1023,1022,5248}'::integer[])) AND (((is_public = 1) AND (created_by <> 1015)) OR (created_by = 1015)) AND (((start_at >= '2026-07-01 00:00:00+08'::timestamp with time zone) AND (end_at < '2026-07-31 23:59:59+08'::timestamp with time zone)) OR ((start_at <= '2026-07-01 00:00:00+08'::timestamp with time zone) AND (end_at > '2026-07-01 00:00:00+08'::timestamp with time zone)) OR ((start_at <= '2026-07-31 23:59:59+08'::timestamp with time zone) AND (end_at > '2026-07-31 23:59:59+08'::timestamp with time zone))))

QUERY PLAN

Seq Scan on tbl_calendars c (cost=0.00..1010.39 rows=4 width=20)

Filter: (((start_at IS NOT NULL) OR (end_at IS NOT NULL)) AND (created_by = 1015) AND (created_by = ANY ('{1015,1015,1023,1022,5248}'::integer[])) AND (((is_public = 1) AND (created_by <> 1015)) OR (created_by = 1015)) AND (((start_at >= '2026-07-01 00:00:00+08'::timestamp with time zone) AND (end_at < '2026-07-31 23:59:59+08'::timestamp with time zone)) OR ((start_at <= '2026-07-01 00:00:00+08'::timestamp with time zone) AND (end_at > '2026-07-01 00:00:00+08'::timestamp with time zone)) OR ((start_at <= '2026-07-31 23:59:59+08'::timestamp with time zone) AND (end_at > '2026-07-31 23:59:59+08'::timestamp with time zone))))