explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BjgD

Settings
# exclusive inclusive rows x rows loops node
1. 0.784 215.546 ↓ 23.0 23 1

GroupAggregate (cost=9,191.75..9,191.77 rows=1 width=70) (actual time=214.492..215.546 rows=23 loops=1)

  • Group Key: instelling.id
2. 3.317 214.762 ↓ 10,759.0 10,759 1

Sort (cost=9,191.75..9,191.75 rows=1 width=70) (actual time=214.411..214.762 rows=10,759 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,374kB
3. 4.394 211.445 ↓ 10,759.0 10,759 1

Nested Loop (cost=482.12..9,191.74 rows=1 width=70) (actual time=7.452..211.445 rows=10,759 loops=1)

4. 5.931 174.774 ↓ 10,759.0 10,759 1

Nested Loop (cost=481.69..9,191.21 rows=1 width=86) (actual time=7.435..174.774 rows=10,759 loops=1)

  • Join Filter: (o.laatste_beoordeling = d.laatste_beoordeling_met_uitslag)
  • Rows Removed by Join Filter: 300
5. 7.155 135.666 ↓ 44.4 11,059 1

Nested Loop (cost=481.25..9,071.96 rows=249 width=86) (actual time=7.421..135.666 rows=11,059 loops=1)

6. 0.000 95.334 ↓ 44.4 11,059 1

Nested Loop (cost=480.82..8,945.14 rows=249 width=86) (actual time=7.405..95.334 rows=11,059 loops=1)

7. 1.135 51.557 ↓ 44.4 11,059 1

Nested Loop (cost=480.25..7,077.24 rows=249 width=78) (actual time=7.394..51.557 rows=11,059 loops=1)

8. 1.466 5.366 ↓ 2.7 128 1

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

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

10. 1.083 3.004 ↑ 1.0 9,548 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 506kB
11. 1.921 1.921 ↑ 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..1.921 rows=9,548 loops=1)

12. 45.056 45.056 ↑ 6.0 86 128

Index Scan using idx_90905c45fe82e03a on follow_up_radiologieverslag this_ (cost=0.42..124.24 rows=517 width=24) (actual time=0.280..0.352 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: 723
13. 44.236 44.236 ↑ 1.0 1 11,059

Index Scan using screening_ronde_pkey on screening_ronde sr (cost=0.56..7.50 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=11,059)

  • Index Cond: (id = this_.screening_ronde)
14. 33.177 33.177 ↑ 1.0 1 11,059

Index Scan using onderzoek_pkey on onderzoek o (cost=0.44..0.51 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=11,059)

  • Index Cond: (id = sr.laatste_onderzoek)
15. 33.177 33.177 ↑ 1.0 1 11,059

Index Scan using dossier_pkey on dossier d (cost=0.43..0.47 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=11,059)

  • Index Cond: (id = sr.dossier)
16. 32.277 32.277 ↑ 1.0 1 10,759

Index Only Scan using onderzoeks_verslag_pkey on beoordeling b (cost=0.44..0.53 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=10,759)

  • Index Cond: (id = o.laatste_beoordeling)
  • Heap Fetches: 10,759
Planning time : 1.890 ms
Execution time : 215.785 ms