explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m7sz

Settings
# exclusive inclusive rows x rows loops node
1. 0.745 224.935 ↓ 23.0 23 1

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

  • Group Key: instelling.id
2. 3.350 224.190 ↓ 10,759.0 10,759 1

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

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

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

4. 6.585 183.154 ↓ 10,759.0 10,759 1

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

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

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

6. 0.751 102.545 ↓ 44.4 11,059 1

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

7. 1.163 57.558 ↓ 44.4 11,059 1

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

8. 2.267 8.139 ↓ 2.7 128 1

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

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

10. 1.546 4.593 ↑ 1.0 9,548 1

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

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

12. 48.256 48.256 ↑ 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.304..0.377 rows=86 loops=128)

  • Index Cond: (aangemaakt_in = instelling.id)
  • Filter: ((ingevoerd_door 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 : 3.051 ms
Execution time : 225.220 ms