Advertisement
Guest User

Untitled

a guest
Feb 16th, 2020
32
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.88 KB | None | 0 0
  1. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  2. Limit (cost=1002.57..2475.59 rows=20 width=2624) (actual time=7.229..13.125 rows=20 loops=1)
  3. -> Nested Loop Left Join (cost=1002.57..296637.48 rows=4014 width=2624) (actual time=7.227..7.809 rows=20 loops=1)
  4. Join Filter: (users_4.user_id = comments_1.user_id)
  5. -> Gather Merge (cost=1002.29..296568.96 rows=4014 width=2575) (actual time=7.170..13.037 rows=20 loops=1)
  6. Workers Planned: 2
  7. Workers Launched: 2
  8. -> Nested Loop Left Join (cost=2.27..295105.62 rows=1672 width=2575) (actual time=0.269..0.776 rows=12 loops=3)
  9. -> Nested Loop Left Join (cost=1.98..294573.42 rows=1672 width=2526) (actual time=0.241..0.717 rows=12 loops=3)
  10. -> Nested Loop Left Join (cost=1.70..290670.87 rows=1672 width=1761) (actual time=0.224..0.666 rows=12 loops=3)
  11. -> Nested Loop Left Join (cost=1.41..290167.84 rows=1672 width=1712) (actual time=0.177..0.573 rows=12 loops=3)
  12. -> Nested Loop Left Join (cost=1.13..289635.64 rows=1672 width=1663) (actual time=0.133..0.491 rows=12 loops=3)
  13. -> Nested Loop (cost=0.84..289090.03 rows=1672 width=898) (actual time=0.087..0.401 rows=12 loops=3)
  14. -> 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)
  15. Filter: (user_id <> 8086)
  16. Rows Removed by Filter: 12
  17. -> 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)
  18. Index Cond: (comment_id = comments.parent_id)
  19. Filter: (user_id = 8086)
  20. Rows Removed by Filter: 1
  21. -> 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)
  22. Index Cond: (post_id = comments.post_id)
  23. -> 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)
  24. Index Cond: (user_id = posts_1.user_id)
  25. -> 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)
  26. Index Cond: (user_id = comments.user_id)
  27. -> 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)
  28. Index Cond: (post_id = comments_1.post_id)
  29. -> 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)
  30. Index Cond: (user_id = posts_2.user_id)
  31. -> Materialize (cost=0.28..8.31 rows=1 width=49) (actual time=0.002..0.002 rows=1 loops=20)
  32. -> 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)
  33. Index Cond: (user_id = 8086)
  34. Planning Time: 9.147 ms
  35. Execution Time: 13.851 ms
  36. (34 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement