explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eZUm

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

Nested Loop Left Join (cost=22.19..78.33 rows=1 width=138) (actual time=0.051..0.053 rows=1 loops=1)

2.          

CTE feed_activity

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

  • Index Cond: (id = 47584216)
  • Heap Fetches: 1
4.          

CTE activity_joined

5. 0.002 0.015 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.44..8.48 rows=1 width=61) (actual time=0.014..0.015 rows=1 loops=1)

6. 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.008..0.008 rows=1 loops=1)

7. 0.005 0.005 ↑ 1.0 1 1

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

  • Index Cond: (feed_activity.feed_activities_id = feed_activity_id)
8. 0.001 0.048 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.83..52.94 rows=1 width=116) (actual time=0.046..0.048 rows=1 loops=1)

9. 0.000 0.047 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.41..46.93 rows=1 width=114) (actual time=0.045..0.047 rows=1 loops=1)

10. 0.001 0.046 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.13..46.58 rows=1 width=106) (actual time=0.044..0.046 rows=1 loops=1)

11. 0.001 0.043 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.86..38.27 rows=1 width=98) (actual time=0.041..0.043 rows=1 loops=1)

12. 0.001 0.042 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.44..37.59 rows=1 width=88) (actual time=0.040..0.042 rows=1 loops=1)

13. 0.001 0.038 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.02..29.14 rows=1 width=80) (actual time=0.036..0.038 rows=1 loops=1)

14. 0.001 0.037 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.59..28.26 rows=1 width=66) (actual time=0.035..0.037 rows=1 loops=1)

15. 0.001 0.033 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.15..19.80 rows=1 width=58) (actual time=0.031..0.033 rows=1 loops=1)

16. 0.000 0.031 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.73..19.16 rows=1 width=56) (actual time=0.030..0.031 rows=1 loops=1)

17. 0.000 0.030 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.30..17.80 rows=1 width=46) (actual time=0.029..0.030 rows=1 loops=1)

18. 0.001 0.026 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.86..9.33 rows=1 width=38) (actual time=0.024..0.026 rows=1 loops=1)

19. 0.001 0.022 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.43..8.48 rows=1 width=36) (actual time=0.020..0.022 rows=1 loops=1)

20. 0.016 0.016 ↑ 1.0 1 1

CTE Scan on activity_joined (cost=0.00..0.02 rows=1 width=28) (actual time=0.015..0.016 rows=1 loops=1)

21. 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.004..0.005 rows=1 loops=1)

  • Index Cond: (activity_joined.id = activity_id)
22. 0.003 0.003 ↑ 1.0 1 1

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

  • Index Cond: (account_achievement_activities.account_achievement_id = id)
23. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Index Cond: (activity_joined.id = activity_id)
24. 0.001 0.001 ↓ 0.0 0 1

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

  • Index Cond: (seven_workout_session_activities.seven_workout_session_id = id)
25. 0.001 0.001 ↓ 0.0 0 1

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

  • Index Cond: (seven_workout_sessions.custom_workout_id = id)
26. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (activity_joined.id = activity_id)
27. 0.000 0.000 ↓ 0.0 0 1

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

  • Index Cond: (external_workout_session_activities.external_workout_session_id = id)
28. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (activity_joined.id = activity_id)
29. 0.000 0.000 ↓ 0.0 0 1

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

  • Index Cond: (custom_workout_activities.custom_workout_id = id)
30. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Index Cond: (activity_joined.id = activity_id)
31. 0.001 0.001 ↓ 0.0 0 1

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

  • Index Cond: (custom_workout_follower_activities.custom_workout_follower_id = id)
32. 0.000 0.000 ↓ 0.0 0 1

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

  • Index Cond: (custom_workout_followers.custom_workout_id = id)
33. 0.004 0.004 ↑ 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.003..0.004 rows=1 loops=1)

  • Index Cond: (activity_joined.account_id = account_id)