explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ngOG : met exists

Settings
# exclusive inclusive rows x rows loops node
1. 0.802 414.772 ↑ 4.5 23 1

GroupAggregate (cost=9,041.76..9,043.57 rows=103 width=70) (actual time=413.693..414.772 rows=23 loops=1)

  • Group Key: instelling.id
2. 2.924 413.970 ↓ 102.9 10,603 1

Sort (cost=9,041.76..9,042.02 rows=103 width=70) (actual time=413.614..413.970 rows=10,603 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,360kB
3. 7.250 411.046 ↓ 102.9 10,603 1

Nested Loop Semi Join (cost=483.67..9,038.32 rows=103 width=70) (actual time=12.755..411.046 rows=10,603 loops=1)

4. 1.493 65.803 ↓ 43.3 10,903 1

Nested Loop (cost=480.25..7,080.12 rows=252 width=78) (actual time=12.657..65.803 rows=10,903 loops=1)

5. 2.814 9.526 ↓ 2.7 128 1

Hash Left Join (cost=479.83..865.37 rows=48 width=62) (actual time=5.271..9.526 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. 1.486 1.486 ↑ 1.0 9,548 1

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

7. 1.668 5.226 ↑ 1.0 9,548 1

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

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

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

9. 54.784 54.784 ↑ 6.2 85 128

Index Scan using idx_90905c45fe82e03a on follow_up_radiologieverslag this_ (cost=0.42..124.24 rows=523 width=24) (actual time=0.328..0.428 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: 724
10. 0.000 337.993 ↑ 1.0 1 10,903

Nested Loop (cost=3.42..7.76 rows=1 width=24) (actual time=0.031..0.031 rows=1 loops=10,903)

11. 10.879 294.381 ↑ 1.0 1 10,903

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

12. 0.000 239.866 ↑ 1.0 1 10,903

Nested Loop (cost=2.42..6.61 rows=1 width=24) (actual time=0.022..0.022 rows=1 loops=10,903)

  • Join Filter: (o.id = b.onderzoek)
13. 6.101 196.254 ↑ 1.0 1 10,903

Nested Loop (cost=1.99..6.09 rows=1 width=32) (actual time=0.018..0.018 rows=1 loops=10,903)

14. 0.000 141.739 ↑ 1.0 1 10,903

Nested Loop (cost=1.55..5.59 rows=1 width=24) (actual time=0.013..0.013 rows=1 loops=10,903)

15. 0.000 87.224 ↑ 1.0 1 10,903

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

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

Index Only Scan using idx_90905c45f999889 on follow_up_radiologieverslag fur (cost=0.42..1.11 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=10,903)

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = u.screening_ronde)
  • Heap Fetches: 10,603
Planning time : 5.151 ms
Execution time : 414.921 ms