QUERY PLAN
Aggregate (cost=19377.86..19377.87 rows=1 width=8)
-> Sort (cost=18915.31..18992.40 rows=30837 width=248)
Sort Key: (CASE WHEN ((c.created_by = 1001) OR uc.is_read) THEN true ELSE false END), c.created_at DESC
-> Hash Right Join (cost=7732.27..13032.04 rows=30837 width=248)
Hash Cond: (uc.comment_id = c.id)
Filter: ((uc.remind_user_id = 1001) OR (c.created_by = 1001))
-> Seq Scan on tbl_unread_comments uc (cost=0.00..4165.14 rows=32587 width=9)
Filter: (remind_user_id = 1001)
-> Hash (cost=5413.41..5413.41 rows=133349 width=16)
-> Seq Scan on tbl_comments c (cost=0.00..5413.41 rows=133349 width=16)
Filter: is_system