explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8HBU : onderbroken vanuit dossier

Settings
# exclusive inclusive rows x rows loops node
1. 1.618 436.787 ↓ 23.0 23 1

GroupAggregate (cost=0.99..6,312,422.08 rows=1 width=70) (actual time=33.592..436.787 rows=23 loops=1)

  • Group Key: instelling.id
2. 1.256 435.169 ↓ 10,578.0 10,578 1

Nested Loop (cost=0.99..6,312,422.06 rows=1 width=70) (actual time=7.733..435.169 rows=10,578 loops=1)

3. 2.666 8.441 ↓ 2.7 128 1

Nested Loop Left Join (cost=0.57..5,402.46 rows=48 width=62) (actual time=0.031..8.441 rows=128 loops=1)

  • Filter: ((instelling.parent = 10,910,337) OR (pinstellin8_.parent = 10,910,337))
  • Rows Removed by Filter: 9,430
4. 5.775 5.775 ↓ 1.0 9,558 1

Index Scan using org_organisatie_pkey on org_organisatie instelling (cost=0.29..1,108.43 rows=9,556 width=70) (actual time=0.006..5.775 rows=9,558 loops=1)

5. 0.000 0.000 ↓ 0.0 0 9,558

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

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

Index Scan using idx_90905c45fe82e03a on follow_up_radiologieverslag this_ (cost=0.42..131,396.21 rows=3 width=16) (actual time=0.020..3.324 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: 731
7.          

SubPlan (for Index Scan)

8. 1.835 350.240 ↑ 1.0 1 10,945

Nested Loop (cost=2.87..27.14 rows=1 width=8) (actual time=0.031..0.032 rows=1 loops=10,945)

9. 0.000 295.515 ↑ 1.0 1 10,945

Nested Loop (cost=2.31..18.55 rows=1 width=8) (actual time=0.026..0.027 rows=1 loops=10,945)

10. 0.000 240.790 ↑ 1.0 1 10,945

Nested Loop (cost=1.88..18.07 rows=1 width=16) (actual time=0.021..0.022 rows=1 loops=10,945)

  • Join Filter: (o.id = b.onderzoek)
11. 4.928 186.065 ↑ 1.0 1 10,945

Nested Loop (cost=1.44..17.55 rows=1 width=24) (actual time=0.016..0.017 rows=1 loops=10,945)

12. 10.801 131.340 ↓ 2.0 2 10,945

Nested Loop (cost=1.00..17.05 rows=1 width=16) (actual time=0.010..0.012 rows=2 loops=10,945)

13. 54.725 54.725 ↑ 1.0 1 10,945

Index Scan using idx_70765babf999889 on uitnodiging u (cost=0.44..8.46 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=10,945)

  • Index Cond: (screening_ronde = this_.screening_ronde)
14. 65.814 65.814 ↓ 2.0 2 10,969

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

  • 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,947
16. 54.735 54.735 ↑ 1.0 1 10,947

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

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

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

  • Index Cond: (laatste_beoordeling_met_uitslag = b.id)
  • Heap Fetches: 10,889
18. 52.890 52.890 ↑ 1.0 1 10,578

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

  • Index Cond: (id = this_.screening_ronde)
  • Heap Fetches: 3,190
Planning time : 1.618 ms
Execution time : 436.888 ms