explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DZOy

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.109 ↑ 1.0 1 1

Nested Loop Left Join (cost=14.15..62.47 rows=1 width=138) (actual time=0.107..0.109 rows=1 loops=1)

2.          

CTE feed_activity

3. 0.006 0.006 ↑ 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.006..0.006 rows=1 loops=1)

  • Index Cond: (id = 47584216)
  • Heap Fetches: 1
4. 0.002 0.101 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.27..50.56 rows=1 width=116) (actual time=0.099..0.101 rows=1 loops=1)

5. 0.001 0.096 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.85..44.55 rows=1 width=114) (actual time=0.094..0.096 rows=1 loops=1)

6. 0.002 0.092 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.57..42.28 rows=1 width=106) (actual time=0.089..0.092 rows=1 loops=1)

7. 0.000 0.085 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.30..40.38 rows=1 width=98) (actual time=0.083..0.085 rows=1 loops=1)

8. 0.001 0.081 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.88..36.93 rows=1 width=88) (actual time=0.079..0.081 rows=1 loops=1)

9. 0.001 0.074 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.46..33.50 rows=1 width=80) (actual time=0.072..0.074 rows=1 loops=1)

10. 0.001 0.069 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.02..29.97 rows=1 width=66) (actual time=0.067..0.069 rows=1 loops=1)

11. 0.001 0.062 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.59..26.44 rows=1 width=58) (actual time=0.060..0.062 rows=1 loops=1)

12. 0.001 0.046 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.17..23.01 rows=1 width=56) (actual time=0.044..0.046 rows=1 loops=1)

13. 0.001 0.041 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.73..19.27 rows=1 width=46) (actual time=0.040..0.041 rows=1 loops=1)

14. 0.001 0.034 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.30..15.52 rows=1 width=38) (actual time=0.033..0.034 rows=1 loops=1)

15. 0.001 0.027 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.87..12.00 rows=1 width=36) (actual time=0.026..0.027 rows=1 loops=1)

16. 0.002 0.018 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.44..8.48 rows=1 width=28) (actual time=0.017..0.018 rows=1 loops=1)

17. 0.008 0.008 ↑ 1.0 1 1

CTE Scan on feed_activity (cost=0.00..0.02 rows=1 width=8) (actual time=0.007..0.008 rows=1 loops=1)

18. 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 = feed_activity_id)
19. 0.008 0.008 ↑ 1.0 1 1

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

  • Index Cond: (activities.id = activity_id)
20. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (account_achievement_activities.account_achievement_id = id)
21. 0.006 0.006 ↓ 0.0 0 1

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

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

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

  • Index Cond: (seven_workout_session_activities.seven_workout_session_id = id)
23. 0.015 0.015 ↓ 0.0 0 1

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

  • Index Cond: (seven_workout_sessions.custom_workout_id = id)
24. 0.006 0.006 ↓ 0.0 0 1

Index Scan using index_external_workout_session_activities_activity_id on external_workout_session_activities (cost=0.43..3.51 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 external_workout_sessions_pkey on external_workout_sessions (cost=0.43..3.53 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)
26. 0.006 0.006 ↓ 0.0 0 1

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

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

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

  • Index Cond: (custom_workout_activities.custom_workout_id = id)
28. 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..1.89 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (activities.id = activity_id)
29. 0.003 0.003 ↓ 0.0 0 1

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

  • Index Cond: (custom_workout_follower_activities.custom_workout_follower_id = id)
30. 0.003 0.003 ↓ 0.0 0 1

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

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

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

  • Index Cond: (activities.account_id = account_id)