explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AsWf : onderbroken met status onderbroken

Settings
# exclusive inclusive rows x rows loops node
1. 1.287 415.037 ↓ 23.0 23 1

GroupAggregate (cost=0.99..7,060,532.28 rows=1 width=70) (actual time=45.725..415.037 rows=23 loops=1)

  • Group Key: instelling.id
2. 1.144 413.750 ↓ 10,638.0 10,638 1

Nested Loop (cost=0.99..7,060,532.27 rows=1 width=70) (actual time=13.268..413.750 rows=10,638 loops=1)

3. 5.901 10.174 ↓ 2.7 128 1

Nested Loop Left Join (cost=0.57..5,252.82 rows=48 width=62) (actual time=0.030..10.174 rows=128 loops=1)

  • Filter: ((instelling.parent = 10,910,337) OR (pinstellin8_.parent = 10,910,337))
  • Rows Removed by Filter: 9,420
4. 4.273 4.273 ↑ 1.0 9,548 1

Index Scan using org_organisatie_pkey on org_organisatie instelling (cost=0.29..1,045.33 rows=9,548 width=70) (actual time=0.011..4.273 rows=9,548 loops=1)

5. 0.000 0.000 ↓ 0.0 0 9,548

Index Scan using org_organisatie_pkey on org_organisatie pinstellin8_ (cost=0.29..0.43 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=9,548)

  • Index Cond: (instelling.parent = id)
6. 63.354 402.432 ↓ 27.7 83 128

Index Scan using idx_90905c45fe82e03a on follow_up_radiologieverslag this_ (cost=0.42..146,984.96 rows=3 width=16) (actual time=0.389..3.144 rows=83 loops=128)

  • Index Cond: (aangemaakt_in = instelling.id)
  • Filter: ((ingevoerd_op IS NULL) AND (aangemaakt_op <= (now() - '30 days'::interval)) AND (screening_ronde = (SubPlan 1)))
  • Rows Removed by Filter: 726
7.          

SubPlan (for Index Scan)

8. 1.500 339.078 ↑ 1.0 1 10,938

Nested Loop (cost=3.00..30.52 rows=1 width=8) (actual time=0.030..0.031 rows=1 loops=10,938)

9. 10.930 284.388 ↑ 1.0 1 10,938

Nested Loop (cost=2.44..21.93 rows=1 width=8) (actual time=0.025..0.026 rows=1 loops=10,938)

10. 10.930 229.698 ↑ 1.0 1 10,938

Nested Loop (cost=2.00..21.45 rows=1 width=16) (actual time=0.020..0.021 rows=1 loops=10,938)

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

Nested Loop (cost=1.56..20.94 rows=1 width=24) (actual time=0.016..0.016 rows=1 loops=10,938)

12. 10.818 120.318 ↓ 2.0 2 10,938

Nested Loop (cost=1.13..20.44 rows=1 width=16) (actual time=0.010..0.011 rows=2 loops=10,938)

13. 54.690 54.690 ↑ 1.0 1 10,938

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

  • Index Cond: (screening_ronde = this_.screening_ronde)
14. 54.810 54.810 ↑ 1.0 2 10,962

Index Scan using idx_20d39191b0d90981 on afspraak a (cost=0.56..11.84 rows=2 width=16) (actual time=0.005..0.005 rows=2 loops=10,962)

  • Index Cond: (uitnodiging = u.id)
15. 49.797 49.797 ↑ 1.0 1 16,599

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,599)

  • Index Cond: (id = a.onderzoek)
  • Heap Fetches: 10,940
16. 43.760 43.760 ↑ 1.0 1 10,940

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,940)

  • Index Cond: (onderzoek = a.onderzoek)
17. 43.760 43.760 ↑ 1.0 1 10,940

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,940)

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

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

  • Index Cond: (id = this_.screening_ronde)
  • Heap Fetches: 10,638
Planning time : 2.451 ms
Execution time : 415.222 ms