explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nfzk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.015 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.71..41.83 rows=1 width=194) (actual time=0.014..0.015 rows=1 loops=1)

2. 0.001 0.014 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.28..33.38 rows=1 width=185) (actual time=0.013..0.014 rows=1 loops=1)

  • Join Filter: (comment_mentions.comment_id = comments.id)
3. 0.002 0.011 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.00..25.07 rows=1 width=98) (actual time=0.010..0.011 rows=1 loops=1)

4. 0.001 0.009 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.58..16.63 rows=1 width=102) (actual time=0.009..0.009 rows=1 loops=1)

  • Join Filter: (comment_reactions.comment_id = comments.id)
5. 0.005 0.005 ↑ 1.0 1 1

Index Scan using comments_pkey on comments (cost=0.29..8.31 rows=1 width=78) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (id = 55557)
6. 0.003 0.003 ↓ 0.0 0 1

Index Scan using index_comment_reactions_comment_id on comment_reactions (cost=0.29..8.30 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (comment_id = 55557)
7. 0.000 0.000 ↓ 0.0 0 1

Index Scan using reactions_pkey on reactions (cost=0.42..8.44 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (id = comment_reactions.reaction_id)
8. 0.002 0.002 ↓ 0.0 0 1

Index Scan using index_comment_mentions_comment_id on comment_mentions (cost=0.28..8.30 rows=1 width=87) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (comment_id = 55557)
9. 0.001 0.001 ↓ 0.0 0 1

Index Scan using index_user_info_account_id on user_info user_mentioned_user_info (cost=0.42..8.44 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (account_id = comment_mentions.mentioned_account_id)
Planning time : 0.295 ms
Execution time : 0.043 ms