explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u53H

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.094 ↑ 1.0 1 1

Nested Loop Left Join (cost=6.13..97.88 rows=1 width=138) (actual time=0.091..0.094 rows=1 loops=1)

2. 0.000 0.085 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.71..89.42 rows=1 width=116) (actual time=0.083..0.085 rows=1 loops=1)

3. 0.002 0.081 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.29..83.31 rows=1 width=114) (actual time=0.079..0.081 rows=1 loops=1)

4. 0.001 0.075 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.01..79.67 rows=1 width=106) (actual time=0.074..0.075 rows=1 loops=1)

5. 0.000 0.069 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.74..71.37 rows=1 width=98) (actual time=0.067..0.069 rows=1 loops=1)

6. 0.001 0.065 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.32..67.32 rows=1 width=88) (actual time=0.063..0.065 rows=1 loops=1)

7. 0.001 0.058 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.90..58.87 rows=1 width=80) (actual time=0.056..0.058 rows=1 loops=1)

8. 0.000 0.053 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.46..54.75 rows=1 width=66) (actual time=0.052..0.053 rows=1 loops=1)

9. 0.001 0.046 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.03..46.29 rows=1 width=58) (actual time=0.044..0.046 rows=1 loops=1)

10. 0.000 0.041 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.61..42.25 rows=1 width=56) (actual time=0.040..0.041 rows=1 loops=1)

11. 0.002 0.037 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.17..37.96 rows=1 width=46) (actual time=0.035..0.037 rows=1 loops=1)

12. 0.001 0.030 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.73..29.49 rows=1 width=38) (actual time=0.029..0.030 rows=1 loops=1)

13. 0.001 0.025 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.30..25.38 rows=1 width=36) (actual time=0.024..0.025 rows=1 loops=1)

14. 0.002 0.019 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.88..16.92 rows=1 width=28) (actual time=0.019..0.019 rows=1 loops=1)

  • Join Filter: (feed_activities.id = activities.feed_activity_id)
15. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using feed_activities_pkey on feed_activities (cost=0.44..8.46 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = 47584216)
  • Heap Fetches: 1
16. 0.008 0.008 ↑ 1.0 1 1

Index Scan using index_activities_feed_activity_id on activities (cost=0.44..8.46 rows=1 width=28) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (feed_activity_id = 47584216)
17. 0.005 0.005 ↑ 1.0 1 1

Index Scan using index_account_achievement_activities_activity_id on account_achievement_activities (cost=0.43..8.45 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (activities.id = activity_id)
18. 0.004 0.004 ↑ 1.0 1 1

Index Scan using account_achievements_pkey on account_achievements (cost=0.43..4.11 rows=1 width=10) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (account_achievement_activities.account_achievement_id = id)
19. 0.005 0.005 ↓ 0.0 0 1

Index Scan using index_seven_workout_session_activities_activity_id on seven_workout_session_activities (cost=0.44..8.46 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (activities.id = activity_id)
20. 0.004 0.004 ↓ 0.0 0 1

Index Scan using seven_workout_sessions_pkey on seven_workout_sessions (cost=0.44..4.29 rows=1 width=18) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (seven_workout_session_activities.seven_workout_session_id = id)
21. 0.004 0.004 ↓ 0.0 0 1

Index Scan using custom_workouts_pkey on custom_workouts seven_workout_sessions_custom_workouts (cost=0.42..4.04 rows=1 width=18) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (seven_workout_sessions.custom_workout_id = id)
22. 0.007 0.007 ↓ 0.0 0 1

Index Scan using index_external_workout_session_activities_activity_id on external_workout_session_activities (cost=0.43..8.45 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (activities.id = activity_id)
23. 0.004 0.004 ↓ 0.0 0 1

Index Scan using external_workout_sessions_pkey on external_workout_sessions (cost=0.43..4.12 rows=1 width=22) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (external_workout_session_activities.external_workout_session_id = id)
24. 0.006 0.006 ↓ 0.0 0 1

Index Scan using index_custom_workout_activities_activity_id on custom_workout_activities (cost=0.42..8.44 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (activities.id = activity_id)
25. 0.004 0.004 ↓ 0.0 0 1

Index Scan using custom_workouts_pkey on custom_workouts (cost=0.42..4.05 rows=1 width=18) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (custom_workout_activities.custom_workout_id = id)
26. 0.005 0.005 ↓ 0.0 0 1

Index Scan using index_custom_workout_follower_activities_activity_id on custom_workout_follower_activities (cost=0.28..8.29 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (activities.id = activity_id)
27. 0.004 0.004 ↓ 0.0 0 1

Index Scan using custom_workout_followers_pkey on custom_workout_followers (cost=0.28..3.63 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (custom_workout_follower_activities.custom_workout_follower_id = id)
28. 0.004 0.004 ↓ 0.0 0 1

Index Scan using custom_workouts_pkey on custom_workouts custom_workout_followers_custom_workouts (cost=0.42..6.11 rows=1 width=18) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (custom_workout_followers.custom_workout_id = id)
29. 0.007 0.007 ↑ 1.0 1 1

Index Scan using index_user_info_account_id on user_info (cost=0.42..8.44 rows=1 width=30) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (activities.account_id = account_id)
Planning time : 1.952 ms
Execution time : 0.182 ms