explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RAyj : origineel radiologieverslag

Settings
# exclusive inclusive rows x rows loops node
1. 1.887 1,470.512 ↑ 4.2 23 1

GroupAggregate (cost=489,185.20..489,186.88 rows=96 width=70) (actual time=1,467.673..1,470.512 rows=23 loops=1)

  • Group Key: instelling.id
2. 6.024 1,468.625 ↓ 111.0 10,656 1

Sort (cost=489,185.20..489,185.44 rows=96 width=70) (actual time=1,467.386..1,468.625 rows=10,656 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,365kB
3. 13.145 1,462.601 ↓ 111.0 10,656 1

Hash Left Join (cost=483.11..489,182.04 rows=96 width=70) (actual time=33.434..1,462.601 rows=10,656 loops=1)

  • Hash Cond: (instelling.parent = pinstellin8_.id)
  • Filter: ((instelling.parent = 10,910,337) OR (pinstellin8_.parent = 10,910,337))
  • Rows Removed by Filter: 35,773
4. 17.921 1,446.642 ↓ 2.4 46,429 1

Nested Loop (cost=3.28..488,652.08 rows=19,098 width=78) (actual time=30.310..1,446.642 rows=46,429 loops=1)

  • Join Filter: (beoordelin1_.onderzoek = onderzoek2_.id)
5. 28.784 1,243.005 ↓ 3.7 46,429 1

Nested Loop (cost=2.85..482,304.60 rows=12,392 width=94) (actual time=30.295..1,243.005 rows=46,429 loops=1)

6. 21.354 1,028.505 ↓ 3.7 46,429 1

Nested Loop (cost=2.28..473,983.41 rows=12,387 width=110) (actual time=30.282..1,028.505 rows=46,429 loops=1)

7. 3.454 960.722 ↓ 3.7 46,429 1

Nested Loop (cost=2.00..469,943.83 rows=12,387 width=48) (actual time=30.269..960.722 rows=46,429 loops=1)

8. 11.491 764.128 ↓ 1.2 48,285 1

Nested Loop (cost=1.56..451,075.00 rows=39,245 width=48) (actual time=30.223..764.128 rows=48,285 loops=1)

9. 14.889 537.435 ↓ 1.2 71,734 1

Nested Loop (cost=1.13..419,932.20 rows=60,493 width=32) (actual time=30.207..537.435 rows=71,734 loops=1)

10. 0.000 280.676 ↑ 1.0 48,374 1

Nested Loop (cost=0.56..383,855.34 rows=49,792 width=32) (actual time=30.194..280.676 rows=48,374 loops=1)

11. 48.988 48.988 ↑ 1.0 48,267 1

Seq Scan on follow_up_radiologieverslag radiologie6_ (cost=0.00..15,278.06 rows=49,792 width=16) (actual time=30.167..48.988 rows=48,267 loops=1)

  • Filter: ((ingevoerd_op IS NULL) AND (aangemaakt_op <= (now() - '30 days'::interval)))
  • Rows Removed by Filter: 413,565
12. 241.335 241.335 ↑ 1.0 1 48,267

Index Scan using idx_70765babf999889 on uitnodiging uitnodigin4_ (cost=0.56..7.39 rows=1 width=16) (actual time=0.004..0.005 rows=1 loops=48,267)

  • Index Cond: (screening_ronde = radiologie6_.screening_ronde)
13. 241.870 241.870 ↑ 2.0 1 48,374

Index Scan using idx_20d39191b0d90981 on afspraak afspraak3_ (cost=0.56..0.70 rows=2 width=16) (actual time=0.004..0.005 rows=1 loops=48,374)

  • Index Cond: (uitnodiging = uitnodigin4_.id)
14. 215.202 215.202 ↑ 1.0 1 71,734

Index Scan using idx_8aa01da649359f6d on beoordeling beoordelin1_ (cost=0.44..0.50 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=71,734)

  • Index Cond: (onderzoek = afspraak3_.onderzoek)
15. 193.140 193.140 ↑ 1.0 1 48,285

Index Scan using idx_54ba8fa1f8a62420 on dossier this_ (cost=0.43..0.47 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=48,285)

  • Index Cond: (laatste_beoordeling_met_uitslag = beoordelin1_.id)
16. 46.429 46.429 ↑ 1.0 1 46,429

Index Scan using org_organisatie_pkey on org_organisatie instelling (cost=0.29..0.33 rows=1 width=70) (actual time=0.001..0.001 rows=1 loops=46,429)

  • Index Cond: (id = radiologie6_.aangemaakt_in)
17. 185.716 185.716 ↑ 1.0 1 46,429

Index Only Scan using screening_ronde_pkey on screening_ronde screeningr5_ (cost=0.56..0.67 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=46,429)

  • Index Cond: (id = uitnodigin4_.screening_ronde)
  • Heap Fetches: 46,429
18. 185.716 185.716 ↑ 1.0 1 46,429

Index Only Scan using onderzoek_pkey on onderzoek onderzoek2_ (cost=0.44..0.50 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=46,429)

  • Index Cond: (id = afspraak3_.onderzoek)
  • Heap Fetches: 46,429
19. 0.834 2.814 ↑ 1.0 9,548 1

Hash (cost=360.48..360.48 rows=9,548 width=16) (actual time=2.814..2.814 rows=9,548 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 506kB
20. 1.980 1.980 ↑ 1.0 9,548 1

Seq Scan on org_organisatie pinstellin8_ (cost=0.00..360.48 rows=9,548 width=16) (actual time=0.013..1.980 rows=9,548 loops=1)

Planning time : 2.704 ms
Execution time : 1,470.640 ms