Sort (cost=24377.56..24382.07 rows=1804 width=18) |
Sort Key: c.object_type |
-> HashAggregate (cost=24261.95..24279.99 rows=1804 width=18) |
Group Key: c.object_type, sub.unreadcount |
-> Hash Left Join (cost=18312.37..24090.75 rows=34240 width=10) |
Hash Cond: ((c.object_type)::text = (sub.object_type)::text) |
-> Hash Right Join (cost=8738.50..14418.34 rows=34240 width=2) |
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..4564.96 rows=35002 width=8) |
Filter: (remind_user_id = 1001) |
-> Hash (cost=6073.06..6073.06 rows=153315 width=10) |
-> Seq Scan on tbl_comments c (cost=0.00..6073.06 rows=153315 width=10) |
Filter: is_system |
-> Hash (cost=9573.36..9573.36 rows=41 width=10) |
-> Subquery Scan on sub (cost=9560.68..9573.36 rows=41 width=10) |
-> Finalize GroupAggregate (cost=9560.68..9572.95 rows=41 width=10) |
Group Key: uc_1.object_type |
-> Gather Merge (cost=9560.68..9572.33 rows=41 width=10) |
Workers Planned: 1 |
-> Partial GroupAggregate (cost=8560.67..8567.71 rows=41 width=10) |
Group Key: uc_1.object_type |
-> Sort (cost=8560.67..8562.88 rows=884 width=2) |
Sort Key: uc_1.object_type |
-> Nested Loop (cost=0.42..8517.41 rows=884 width=2) |
-> Parallel Seq Scan on tbl_unread_comments uc_1 (cost=0.00..3320.21 rows=1071 width=6) |
Filter: ((NOT is_read) AND (remind_user_id = 1001)) |
-> Index Scan using tbl_comments_pkey on tbl_comments c_1 (cost=0.42..4.85 rows=1 width=4) |
Index Cond: (id = uc_1.comment_id) |
Filter: is_system |