explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r6wp

Settings
# exclusive inclusive rows x rows loops node
1. 0.292 5.577 ↓ 5.1 268 1

Sort (cost=1,578.37..1,578.50 rows=53 width=585) (actual time=5.548..5.577 rows=268 loops=1)

  • Sort Key: tournament_registrations.score
  • Sort Method: quicksort Memory: 293kB
2. 0.261 5.285 ↓ 5.1 268 1

Nested Loop Left Join (cost=4.46..1,576.85 rows=53 width=585) (actual time=0.093..5.285 rows=268 loops=1)

3. 0.234 4.756 ↓ 5.1 268 1

Nested Loop Left Join (cost=4.04..1,425.90 rows=53 width=533) (actual time=0.087..4.756 rows=268 loops=1)

4. 0.239 4.254 ↓ 5.1 268 1

Nested Loop Left Join (cost=3.62..1,274.95 rows=53 width=481) (actual time=0.079..4.254 rows=268 loops=1)

5. 0.215 3.747 ↓ 5.1 268 1

Nested Loop Left Join (cost=3.21..1,123.99 rows=53 width=429) (actual time=0.072..3.747 rows=268 loops=1)

6. 0.233 3.264 ↓ 5.1 268 1

Nested Loop Left Join (cost=2.79..973.04 rows=53 width=377) (actual time=0.065..3.264 rows=268 loops=1)

7. 0.242 2.763 ↓ 5.1 268 1

Nested Loop Left Join (cost=2.37..822.09 rows=53 width=325) (actual time=0.058..2.763 rows=268 loops=1)

8. 0.236 2.253 ↓ 5.1 268 1

Nested Loop Left Join (cost=1.95..671.13 rows=53 width=273) (actual time=0.052..2.253 rows=268 loops=1)

9. 0.149 1.749 ↓ 5.1 268 1

Nested Loop Left Join (cost=1.53..520.18 rows=53 width=221) (actual time=0.046..1.749 rows=268 loops=1)

10. 0.252 1.332 ↓ 5.1 268 1

Nested Loop Left Join (cost=1.12..369.23 rows=53 width=169) (actual time=0.040..1.332 rows=268 loops=1)

11. 0.126 0.812 ↓ 5.1 268 1

Nested Loop Left Join (cost=0.70..218.28 rows=53 width=117) (actual time=0.033..0.812 rows=268 loops=1)

12. 0.061 0.150 ↓ 5.1 268 1

Nested Loop (cost=0.28..67.32 rows=53 width=65) (actual time=0.024..0.150 rows=268 loops=1)

13. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on tournament_places (cost=0.00..3.05 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (tournament_id = 1)
  • Rows Removed by Filter: 83
14. 0.074 0.074 ↓ 3.7 268 1

Index Scan using index_tournament_registrations_on_tournament_place_id on tournament_registrations (cost=0.28..63.55 rows=72 width=65) (actual time=0.008..0.074 rows=268 loops=1)

  • Index Cond: (tournament_place_id = tournament_places.id)
15. 0.536 0.536 ↑ 1.0 1 268

Index Scan using index_answers_on_user_id_and_tournament_question_id on answers q_1 (cost=0.42..2.85 rows=1 width=56) (actual time=0.002..0.002 rows=1 loops=268)

  • Index Cond: ((user_id = tournament_registrations.user_id) AND (tournament_question_id = 61))
16. 0.268 0.268 ↑ 1.0 1 268

Index Scan using index_answers_on_user_id_and_tournament_question_id on answers q_2 (cost=0.42..2.85 rows=1 width=56) (actual time=0.001..0.001 rows=1 loops=268)

  • Index Cond: ((user_id = tournament_registrations.user_id) AND (tournament_question_id = 62))
17. 0.268 0.268 ↓ 0.0 0 268

Index Scan using index_answers_on_user_id_and_tournament_question_id on answers q_3 (cost=0.42..2.85 rows=1 width=56) (actual time=0.001..0.001 rows=0 loops=268)

  • Index Cond: ((user_id = tournament_registrations.user_id) AND (tournament_question_id = 63))
18. 0.268 0.268 ↑ 1.0 1 268

Index Scan using index_answers_on_user_id_and_tournament_question_id on answers q_4 (cost=0.42..2.85 rows=1 width=56) (actual time=0.001..0.001 rows=1 loops=268)

  • Index Cond: ((user_id = tournament_registrations.user_id) AND (tournament_question_id = 64))
19. 0.268 0.268 ↑ 1.0 1 268

Index Scan using index_answers_on_user_id_and_tournament_question_id on answers q_5 (cost=0.42..2.85 rows=1 width=56) (actual time=0.001..0.001 rows=1 loops=268)

  • Index Cond: ((user_id = tournament_registrations.user_id) AND (tournament_question_id = 65))
20. 0.268 0.268 ↑ 1.0 1 268

Index Scan using index_answers_on_user_id_and_tournament_question_id on answers q_6 (cost=0.42..2.85 rows=1 width=56) (actual time=0.001..0.001 rows=1 loops=268)

  • Index Cond: ((user_id = tournament_registrations.user_id) AND (tournament_question_id = 66))
21. 0.268 0.268 ↑ 1.0 1 268

Index Scan using index_answers_on_user_id_and_tournament_question_id on answers q_7 (cost=0.42..2.85 rows=1 width=56) (actual time=0.001..0.001 rows=1 loops=268)

  • Index Cond: ((user_id = tournament_registrations.user_id) AND (tournament_question_id = 67))
22. 0.268 0.268 ↑ 1.0 1 268

Index Scan using index_answers_on_user_id_and_tournament_question_id on answers q_8 (cost=0.42..2.85 rows=1 width=56) (actual time=0.001..0.001 rows=1 loops=268)

  • Index Cond: ((user_id = tournament_registrations.user_id) AND (tournament_question_id = 68))
23. 0.268 0.268 ↑ 1.0 1 268

Index Scan using index_answers_on_user_id_and_tournament_question_id on answers q_9 (cost=0.42..2.85 rows=1 width=56) (actual time=0.001..0.001 rows=1 loops=268)

  • Index Cond: ((user_id = tournament_registrations.user_id) AND (tournament_question_id = 69))
24. 0.268 0.268 ↑ 1.0 1 268

Index Scan using index_answers_on_user_id_and_tournament_question_id on answers q_10 (cost=0.42..2.85 rows=1 width=56) (actual time=0.001..0.001 rows=1 loops=268)

  • Index Cond: ((user_id = tournament_registrations.user_id) AND (tournament_question_id = 70))