explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hgz

Settings
# exclusive inclusive rows x rows loops node
1. 2,334.706 5,988.299 ↓ 2.0 70,436 1

Nested Loop Left Join (cost=0.29..13,348,625.62 rows=35,519 width=1,768) (actual time=2.748..5,988.299 rows=70,436 loops=1)

  • Join Filter: (accreditat0_.id = accreditat0_1_.accreditation_form_id)
  • Rows Removed by Join Filter: 16200280
2. 699.988 2,808.361 ↓ 2.0 70,436 1

Nested Loop Left Join (cost=0.29..13,218,618.03 rows=35,519 width=1,484) (actual time=2.561..2,808.361 rows=70,436 loops=1)

  • Join Filter: (accreditat0_.id = accreditat0_4_.accreditation_form_id)
  • Rows Removed by Join Filter: 6198368
3. 584.421 1,756.193 ↓ 2.0 70,436 1

Nested Loop Left Join (cost=0.29..13,173,328.24 rows=35,519 width=1,237) (actual time=2.476..1,756.193 rows=70,436 loops=1)

  • Join Filter: (accreditat0_.id = accreditat0_3_.accreditation_form_id)
  • Rows Removed by Join Filter: 4437443
4. 62.958 960.464 ↓ 2.0 70,436 1

Nested Loop Left Join (cost=0.29..13,145,621.77 rows=35,519 width=1,196) (actual time=2.429..960.464 rows=70,436 loops=1)

5. 245.268 686.198 ↓ 2.0 70,436 1

Nested Loop Anti Join (cost=0.00..13,132,818.21 rows=35,519 width=1,169) (actual time=2.377..686.198 rows=70,436 loops=1)

  • Join Filter: (shortliste5_.form_id = accreditat0_.id)
  • Rows Removed by Join Filter: 2536326
6. 230.968 299.986 ↓ 2.0 70,472 1

Nested Loop Semi Join (cost=0.00..13,118,425.42 rows=35,532 width=1,169) (actual time=2.319..299.986 rows=70,472 loops=1)

  • Join Filter: (alternatives: SubPlan 1 or hashed SubPlan 2)
  • Rows Removed by Join Filter: 509468
7. 66.884 66.884 ↑ 1.0 71,064 1

Seq Scan on acr_access_form accreditat0_ (cost=0.00..21,364.95 rows=71,064 width=1,169) (actual time=0.021..66.884 rows=71,064 loops=1)

  • Filter: ((form_type)::text = ANY ('{ATH,ACR,TOF,PRS}'::text[]))
  • Rows Removed by Filter: 67
8. 0.000 0.000 ↑ 2.5 8 71,064

Materialize (cost=0.00..1.30 rows=20 width=6) (actual time=0.000..0.000 rows=8 loops=71,064)

9. 0.022 0.022 ↑ 1.1 19 1

Seq Scan on acr_short_list_entry_definition shortliste1_ (cost=0.00..1.20 rows=20 width=6) (actual time=0.019..0.022 rows=19 loops=1)

10.          

SubPlan (forNested Loop Semi Join)

11. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.81 rows=1 width=0) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..16.60 rows=1 width=13) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using acr_role_pkey on acr_role role4_ (cost=0.28..8.30 rows=1 width=6) (never executed)

  • Index Cond: ((accreditat0_.role_code)::text = (code)::text)
14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using acr_role_subcategory_pkey on acr_role_subcategory rolesubcat3_ (cost=0.28..8.29 rows=1 width=7) (never executed)

  • Index Cond: (code = (role4_.subcategory_code)::text)
  • Heap Fetches: 0
15. 0.000 0.000 ↓ 0.0 0

Index Only Scan using acr_short_list_entry_definition_role_subcategory_pkey on acr_short_list_entry_definition_role_subcategory rolesubcat2_ (cost=0.15..0.20 rows=1 width=38) (never executed)

  • Index Cond: ((definition_code = (shortliste1_.code)::text) AND (role_subcategory_code = (rolesubcat3_.code)::text))
  • Heap Fetches: 0
16. 0.078 2.134 ↑ 3.5 323 1

Hash Join (cost=147.44..179.62 rows=1,145 width=64) (actual time=2.072..2.134 rows=323 loops=1)

  • Hash Cond: ((rolesubcat2__1.role_subcategory_code)::text = (rolesubcat3__1.code)::text)
17. 0.012 0.012 ↑ 32.5 24 1

Seq Scan on acr_short_list_entry_definition_role_subcategory rolesubcat2__1 (cost=0.00..17.80 rows=780 width=76) (actual time=0.008..0.012 rows=24 loops=1)

18. 0.456 2.044 ↓ 1.0 2,206 1

Hash (cost=120.22..120.22 rows=2,178 width=20) (actual time=2.044..2.044 rows=2,206 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 148kB
19. 0.724 1.588 ↓ 1.0 2,206 1

Hash Join (cost=47.39..120.22 rows=2,178 width=20) (actual time=0.604..1.588 rows=2,206 loops=1)

  • Hash Cond: ((role4__1.subcategory_code)::text = (rolesubcat3__1.code)::text)
20. 0.325 0.325 ↓ 1.0 2,206 1

Seq Scan on acr_role role4__1 (cost=0.00..43.78 rows=2,178 width=13) (actual time=0.023..0.325 rows=2,206 loops=1)

21. 0.231 0.539 ↑ 1.0 1,484 1

Hash (cost=28.84..28.84 rows=1,484 width=7) (actual time=0.539..0.539 rows=1,484 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 74kB
22. 0.308 0.308 ↑ 1.0 1,484 1

Seq Scan on acr_role_subcategory rolesubcat3__1 (cost=0.00..28.84 rows=1,484 width=7) (actual time=0.011..0.308 rows=1,484 loops=1)

23. 140.916 140.944 ↓ 1.3 36 70,472

Materialize (cost=0.00..2.41 rows=27 width=4) (actual time=0.000..0.002 rows=36 loops=70,472)

24. 0.028 0.028 ↓ 1.3 36 1

Seq Scan on acr_short_list_entry_form shortliste5_ (cost=0.00..2.27 rows=27 width=4) (actual time=0.016..0.028 rows=36 loops=1)

25. 211.308 211.308 ↑ 1.0 1 70,436

Index Scan using acr_general_accreditation_form_pkey on acr_general_accreditation_form accreditat0_2_ (cost=0.29..0.35 rows=1 width=31) (actual time=0.003..0.003 rows=1 loops=70,436)

  • Index Cond: (accreditat0_.id = accreditation_form_id)
26. 211.285 211.308 ↓ 1.2 63 70,436

Materialize (cost=0.00..1.78 rows=52 width=45) (actual time=0.000..0.003 rows=63 loops=70,436)

27. 0.023 0.023 ↓ 1.2 63 1

Seq Scan on acr_team_official_accreditation_form accreditat0_3_ (cost=0.00..1.52 rows=52 width=45) (actual time=0.010..0.023 rows=63 loops=1)

28. 352.155 352.180 ↓ 1.0 88 70,436

Materialize (cost=0.00..3.27 rows=85 width=251) (actual time=0.000..0.005 rows=88 loops=70,436)

29. 0.025 0.025 ↓ 1.0 88 1

Seq Scan on acr_press_accreditation_form accreditat0_4_ (cost=0.00..2.85 rows=85 width=251) (actual time=0.010..0.025 rows=88 loops=1)

30. 845.157 845.232 ↑ 1.1 230 70,436

Materialize (cost=0.00..8.66 rows=244 width=288) (actual time=0.000..0.012 rows=230 loops=70,436)

31. 0.075 0.075 ↑ 1.1 230 1

Seq Scan on acr_athlete_accreditation_form accreditat0_1_ (cost=0.00..7.44 rows=244 width=288) (actual time=0.012..0.075 rows=230 loops=1)

Planning time : 3.167 ms
Execution time : 5,993.128 ms