explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lcpG

Settings
# exclusive inclusive rows x rows loops node
1. 0.279 5.688 ↓ 5.1 268 1

Sort (cost=1,578.08..1,578.22 rows=53 width=585) (actual time=5.659..5.688 rows=268 loops=1)

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

Nested Loop Left Join (cost=4.46..1,576.57 rows=53 width=585) (actual time=0.064..5.409 rows=268 loops=1)

3. 0.241 4.863 ↓ 5.1 268 1

Nested Loop Left Join (cost=4.04..1,425.64 rows=53 width=533) (actual time=0.060..4.863 rows=268 loops=1)

4. 0.252 4.354 ↓ 5.1 268 1

Nested Loop Left Join (cost=3.62..1,274.72 rows=53 width=481) (actual time=0.056..4.354 rows=268 loops=1)

5. 0.236 3.834 ↓ 5.1 268 1

Nested Loop Left Join (cost=3.21..1,123.79 rows=53 width=429) (actual time=0.051..3.834 rows=268 loops=1)

6. 0.287 3.330 ↓ 5.1 268 1

Nested Loop Left Join (cost=2.79..972.87 rows=53 width=377) (actual time=0.047..3.330 rows=268 loops=1)

7. 0.234 2.775 ↓ 5.1 268 1

Nested Loop Left Join (cost=2.37..821.95 rows=53 width=325) (actual time=0.044..2.775 rows=268 loops=1)

8. 0.208 2.273 ↓ 5.1 268 1

Nested Loop Left Join (cost=1.95..671.02 rows=53 width=273) (actual time=0.040..2.273 rows=268 loops=1)

9. 0.147 1.797 ↓ 5.1 268 1

Nested Loop Left Join (cost=1.53..520.10 rows=53 width=221) (actual time=0.037..1.797 rows=268 loops=1)

10. 0.293 1.382 ↓ 5.1 268 1

Nested Loop Left Join (cost=1.12..369.17 rows=53 width=169) (actual time=0.034..1.382 rows=268 loops=1)

11. 0.117 0.821 ↓ 5.1 268 1

Nested Loop Left Join (cost=0.70..218.25 rows=53 width=117) (actual time=0.030..0.821 rows=268 loops=1)

12. 0.077 0.168 ↓ 5.1 268 1

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

13. 0.016 0.016 ↑ 1.0 1 1

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

  • Filter: (tournament_id = 1)
  • Rows Removed by Filter: 83
14. 0.075 0.075 ↓ 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.075 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))