Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- Limit (cost=1002.57..2475.59 rows=20 width=2624) (actual time=7.229..13.125 rows=20 loops=1)
- -> Nested Loop Left Join (cost=1002.57..296637.48 rows=4014 width=2624) (actual time=7.227..7.809 rows=20 loops=1)
- Join Filter: (users_4.user_id = comments_1.user_id)
- -> Gather Merge (cost=1002.29..296568.96 rows=4014 width=2575) (actual time=7.170..13.037 rows=20 loops=1)
- Workers Planned: 2
- Workers Launched: 2
- -> Nested Loop Left Join (cost=2.27..295105.62 rows=1672 width=2575) (actual time=0.269..0.776 rows=12 loops=3)
- -> Nested Loop Left Join (cost=1.98..294573.42 rows=1672 width=2526) (actual time=0.241..0.717 rows=12 loops=3)
- -> Nested Loop Left Join (cost=1.70..290670.87 rows=1672 width=1761) (actual time=0.224..0.666 rows=12 loops=3)
- -> Nested Loop Left Join (cost=1.41..290167.84 rows=1672 width=1712) (actual time=0.177..0.573 rows=12 loops=3)
- -> Nested Loop Left Join (cost=1.13..289635.64 rows=1672 width=1663) (actual time=0.133..0.491 rows=12 loops=3)
- -> Nested Loop (cost=0.84..289090.03 rows=1672 width=898) (actual time=0.087..0.401 rows=12 loops=3)
- -> Parallel Index Scan Backward using comments_posted on comments (cost=0.42..138759.33 rows=201896 width=449) (actual time=0.033..0.105 rows=27 loops=3)
- Filter: (user_id <> 8086)
- Rows Removed by Filter: 12
- -> Index Scan using comments_comment_ids on comments comments_1 (cost=0.42..0.74 rows=1 width=449) (actual time=0.009..0.009 rows=0 loops=82)
- Index Cond: (comment_id = comments.parent_id)
- Filter: (user_id = 8086)
- Rows Removed by Filter: 1
- -> Index Scan using posts_post_ids on posts posts_1 (cost=0.29..0.33 rows=1 width=765) (actual time=0.006..0.006 rows=1 loops=37)
- Index Cond: (post_id = comments.post_id)
- -> Index Scan using users_user_ids on users users_1 (cost=0.28..0.32 rows=1 width=49) (actual time=0.005..0.005 rows=1 loops=37)
- Index Cond: (user_id = posts_1.user_id)
- -> Index Scan using users_user_ids on users users_2 (cost=0.28..0.30 rows=1 width=49) (actual time=0.006..0.006 rows=1 loops=37)
- Index Cond: (user_id = comments.user_id)
- -> Index Scan using posts_post_ids on posts posts_2 (cost=0.29..2.33 rows=1 width=765) (actual time=0.003..0.003 rows=1 loops=37)
- Index Cond: (post_id = comments_1.post_id)
- -> Index Scan using users_user_ids on users users_3 (cost=0.28..0.32 rows=1 width=49) (actual time=0.003..0.003 rows=1 loops=37)
- Index Cond: (user_id = posts_2.user_id)
- -> Materialize (cost=0.28..8.31 rows=1 width=49) (actual time=0.002..0.002 rows=1 loops=20)
- -> Index Scan using users_user_ids on users users_4 (cost=0.28..8.30 rows=1 width=49) (actual time=0.038..0.038 rows=1 loops=1)
- Index Cond: (user_id = 8086)
- Planning Time: 9.147 ms
- Execution Time: 13.851 ms
- (34 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement