QUERY PLAN
Aggregate (cost=3908.43..3908.44 rows=1 width=8)
-> Sort (cost=3838.93..3850.52 rows=4633 width=1155)
Sort Key: (CASE WHEN (s.start_at < now()) THEN 1 ELSE 0 END), (CASE WHEN (s.start_at < now()) THEN s.start_at ELSE NULL::timestamp with time zone END) DESC NULLS LAST, (CASE WHEN (s.start_at >= now()) THEN s.start_at ELSE NULL::timestamp with time zone END)
-> HashAggregate (cost=1096.01..1211.84 rows=4633 width=1155)
Group Key: s.id
-> Seq Scan on tbl_calendars s (cost=0.00..1084.43 rows=4633 width=12)
Filter: ((((is_public = 1) AND (created_by <> 1001)) OR (created_by = 1001)) AND (created_by = ANY ('{1000,1001,1004,1005,1011,1013,1015,1017,1022,1023,5016,5064,5085,5087,5248,5250,5252,5295,5300,5311,5332,5360,5388,5446,5449}'::integer[])))