explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yxoW

Settings
# exclusive inclusive rows x rows loops node
1. 0.756 221.565 ↓ 23.0 23 1

GroupAggregate (cost=9,543.69..9,543.71 rows=1 width=70) (actual time=220.552..221.565 rows=23 loops=1)

  • Group Key: instelling.id
2. 2.898 220.809 ↓ 10,580.0 10,580 1

Sort (cost=9,543.69..9,543.70 rows=1 width=70) (actual time=220.468..220.809 rows=10,580 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,358kB
3. 2.505 217.911 ↓ 10,580.0 10,580 1

Nested Loop (cost=501.87..9,543.68 rows=1 width=70) (actual time=7.299..217.911 rows=10,580 loops=1)

  • Join Filter: (o.laatste_beoordeling = d.laatste_beoordeling_met_uitslag)
  • Rows Removed by Join Filter: 368
4. 5.615 171.614 ↓ 41.5 10,948 1

Nested Loop (cost=501.43..9,414.46 rows=264 width=86) (actual time=7.281..171.614 rows=10,948 loops=1)

5. 0.006 122.207 ↓ 41.5 10,948 1

Nested Loop (cost=501.00..9,279.51 rows=264 width=86) (actual time=7.263..122.207 rows=10,948 loops=1)

6. 1.084 67.461 ↓ 41.5 10,948 1

Nested Loop (cost=500.43..7,178.40 rows=264 width=78) (actual time=7.242..67.461 rows=10,948 loops=1)

7. 0.812 7.881 ↓ 2.7 128 1

Hash Left Join (cost=500.01..905.65 rows=48 width=62) (actual time=3.629..7.881 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,430
8. 3.487 3.487 ↓ 1.0 9,558 1

Seq Scan on org_organisatie instelling (cost=0.00..380.56 rows=9,556 width=70) (actual time=0.013..3.487 rows=9,558 loops=1)

9. 1.042 3.582 ↓ 1.0 9,558 1

Hash (cost=380.56..380.56 rows=9,556 width=16) (actual time=3.582..3.582 rows=9,558 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 506kB
10. 2.540 2.540 ↓ 1.0 9,558 1

Seq Scan on org_organisatie pinstellin8_ (cost=0.00..380.56 rows=9,556 width=16) (actual time=0.002..2.540 rows=9,558 loops=1)

11. 58.496 58.496 ↑ 6.4 86 128

Index Scan using idx_90905c45fe82e03a on follow_up_radiologieverslag this_ (cost=0.42..125.20 rows=548 width=24) (actual time=0.010..0.457 rows=86 loops=128)

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

Index Scan using screening_ronde_pkey on screening_ronde sr (cost=0.56..7.96 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=10,948)

  • Index Cond: (id = this_.screening_ronde)
13. 43.792 43.792 ↑ 1.0 1 10,948

Index Scan using onderzoek_pkey on onderzoek o (cost=0.44..0.51 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=10,948)

  • Index Cond: (id = sr.laatste_onderzoek)
14. 43.792 43.792 ↑ 1.0 1 10,948

Index Scan using dossier_pkey on dossier d (cost=0.43..0.48 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=10,948)

  • Index Cond: (id = sr.dossier)
Planning time : 1.378 ms
Execution time : 221.663 ms