explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oLnI : onderbroken met status onderbroken

Settings
# exclusive inclusive rows x rows loops node
1. 0.867 358.330 ↑ 4.4 23 1

GroupAggregate (cost=9,025.62..9,027.39 rows=101 width=70) (actual time=357.185..358.330 rows=23 loops=1)

  • Group Key: instelling.id
2. 3.335 357.463 ↓ 105.3 10,638 1

Sort (cost=9,025.62..9,025.88 rows=101 width=70) (actual time=357.089..357.463 rows=10,638 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,363kB
3. 4.874 354.128 ↓ 105.3 10,638 1

Nested Loop Semi Join (cost=483.67..9,022.26 rows=101 width=70) (actual time=7.742..354.128 rows=10,638 loops=1)

4. 1.396 53.928 ↓ 43.8 10,938 1

Nested Loop (cost=480.25..7,078.20 rows=250 width=78) (actual time=7.626..53.928 rows=10,938 loops=1)

5. 1.583 5.684 ↓ 2.7 128 1

Hash Left Join (cost=479.83..865.37 rows=48 width=62) (actual time=3.243..5.684 rows=128 loops=1)

  • Hash Cond: (instelling.parent = pinstellin8_.id)
  • Filter: ((instelling.parent = 10,910,337) OR (pinstellin8_.parent = 10,910,337))
  • Rows Removed by Filter: 9,420
6. 0.934 0.934 ↑ 1.0 9,548 1

Seq Scan on org_organisatie instelling (cost=0.00..360.48 rows=9,548 width=70) (actual time=0.007..0.934 rows=9,548 loops=1)

7. 1.128 3.167 ↑ 1.0 9,548 1

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

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

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

9. 46.848 46.848 ↑ 6.1 85 128

Index Scan using idx_90905c45fe82e03a on follow_up_radiologieverslag this_ (cost=0.42..124.24 rows=519 width=24) (actual time=0.286..0.366 rows=85 loops=128)

  • Index Cond: (aangemaakt_in = instelling.id)
  • Filter: ((ingevoerd_op IS NULL) AND (aangemaakt_op <= (now() - '30 days'::interval)))
  • Rows Removed by Filter: 723
10. 1.200 295.326 ↑ 1.0 1 10,938

Nested Loop (cost=3.42..7.77 rows=1 width=24) (actual time=0.027..0.027 rows=1 loops=10,938)

11. 0.000 251.574 ↑ 1.0 1 10,938

Nested Loop (cost=2.86..7.09 rows=1 width=16) (actual time=0.023..0.023 rows=1 loops=10,938)

12. 10.920 218.760 ↑ 1.0 1 10,938

Nested Loop (cost=2.42..6.61 rows=1 width=24) (actual time=0.019..0.020 rows=1 loops=10,938)

  • Join Filter: (o.id = b.onderzoek)
13. 11.362 175.008 ↑ 1.0 1 10,938

Nested Loop (cost=1.99..6.10 rows=1 width=32) (actual time=0.016..0.016 rows=1 loops=10,938)

14. 10.826 131.256 ↑ 1.0 1 10,938

Nested Loop (cost=1.55..5.60 rows=1 width=24) (actual time=0.011..0.012 rows=1 loops=10,938)

15. 10.922 76.566 ↑ 1.0 1 10,938

Nested Loop (cost=0.98..4.87 rows=1 width=24) (actual time=0.007..0.007 rows=1 loops=10,938)

  • Join Filter: (this_.screening_ronde = u.screening_ronde)
16. 21.876 21.876 ↑ 1.0 1 10,938

Index Only Scan using idx_90905c45f999889 on follow_up_radiologieverslag fur (cost=0.42..1.12 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=10,938)

  • Index Cond: (screening_ronde = this_.screening_ronde)
  • Heap Fetches: 10,942
17. 43.768 43.768 ↑ 1.0 1 10,942

Index Scan using idx_70765babf999889 on uitnodiging u (cost=0.56..3.74 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=10,942)

  • Index Cond: (screening_ronde = fur.screening_ronde)
18. 43.864 43.864 ↑ 2.0 1 10,966

Index Scan using idx_20d39191b0d90981 on afspraak a (cost=0.56..0.70 rows=2 width=16) (actual time=0.004..0.004 rows=1 loops=10,966)

  • Index Cond: (uitnodiging = u.id)
19. 32.390 32.390 ↑ 1.0 1 16,195

Index Only Scan using onderzoek_pkey on onderzoek o (cost=0.44..0.50 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=16,195)

  • Index Cond: (id = a.onderzoek)
  • Heap Fetches: 10,944
20. 32.832 32.832 ↑ 1.0 1 10,944

Index Scan using idx_8aa01da649359f6d on beoordeling b (cost=0.44..0.50 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=10,944)

  • Index Cond: (onderzoek = a.onderzoek)
21. 32.832 32.832 ↑ 1.0 1 10,944

Index Only Scan using idx_54ba8fa1f8a62420 on dossier d (cost=0.43..0.47 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=10,944)

  • Index Cond: (laatste_beoordeling_met_uitslag = b.id)
  • Heap Fetches: 10,638
22. 42.552 42.552 ↑ 1.0 1 10,638

Index Only Scan using screening_ronde_pkey on screening_ronde sr (cost=0.56..0.67 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=10,638)

  • Index Cond: (id = u.screening_ronde)
  • Heap Fetches: 10,638
Planning time : 3.833 ms
Execution time : 358.501 ms