explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JQpI : radiologieverslag laatste onderzoek

Settings
# exclusive inclusive rows x rows loops node
1. 1.467 268.692 ↓ 23.0 23 1

GroupAggregate (cost=9,199.64..9,199.66 rows=1 width=70) (actual time=266.785..268.692 rows=23 loops=1)

  • Group Key: instelling.id
2. 5.424 267.225 ↓ 10,655.0 10,655 1

Sort (cost=9,199.64..9,199.65 rows=1 width=70) (actual time=266.639..267.225 rows=10,655 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,365kB
3. 2.848 261.801 ↓ 10,655.0 10,655 1

Nested Loop (cost=481.69..9,199.63 rows=1 width=70) (actual time=12.044..261.801 rows=10,655 loops=1)

  • Join Filter: (o.laatste_beoordeling = d.laatste_beoordeling_met_uitslag)
  • Rows Removed by Join Filter: 300
4. 4.859 204.178 ↓ 43.8 10,955 1

Nested Loop (cost=481.25..9,079.91 rows=250 width=86) (actual time=12.025..204.178 rows=10,955 loops=1)

5. 12.538 144.544 ↓ 43.8 10,955 1

Nested Loop (cost=480.82..8,952.57 rows=250 width=86) (actual time=12.001..144.544 rows=10,955 loops=1)

6. 1.959 77.231 ↓ 43.8 10,955 1

Nested Loop (cost=480.25..7,078.20 rows=250 width=78) (actual time=11.967..77.231 rows=10,955 loops=1)

7. 2.733 9.352 ↓ 2.7 128 1

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

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

9. 1.772 4.983 ↑ 1.0 9,548 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 506kB
10. 3.211 3.211 ↑ 1.0 9,548 1

Seq Scan on org_organisatie pinstellin8_ (cost=0.00..360.48 rows=9,548 width=16) (actual time=0.007..3.211 rows=9,548 loops=1)

11. 65.920 65.920 ↑ 6.0 86 128

Index Scan using idx_90905c45fe82e03a on follow_up_radiologieverslag this_ (cost=0.42..124.24 rows=519 width=24) (actual time=0.400..0.515 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
12. 54.775 54.775 ↑ 1.0 1 10,955

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

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

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

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

Index Scan using dossier_pkey on dossier d (cost=0.43..0.47 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=10,955)

  • Index Cond: (id = sr.dossier)
Planning time : 2.271 ms
Execution time : 269.042 ms