explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hcA8 : radiologieverslag laatste onderzoek

Settings
# exclusive inclusive rows x rows loops node
1. 0.738 252.327 ↓ 23.0 23 1

GroupAggregate (cost=9,544.18..9,544.20 rows=1 width=70) (actual time=251.335..252.327 rows=23 loops=1)

  • Group Key: instelling.id
2. 3.458 251.589 ↓ 10,581.0 10,581 1

Sort (cost=9,544.18..9,544.18 rows=1 width=70) (actual time=251.248..251.589 rows=10,581 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,358kB
3. 3.743 248.131 ↓ 10,581.0 10,581 1

Nested Loop Semi Join (cost=502.30..9,544.17 rows=1 width=70) (actual time=6.441..248.131 rows=10,581 loops=1)

  • Join Filter: (d.laatste_beoordeling_met_uitslag = d_1.laatste_beoordeling_met_uitslag)
4. 2.082 212.645 ↓ 10,581.0 10,581 1

Nested Loop (cost=501.87..9,543.68 rows=1 width=86) (actual time=6.419..212.645 rows=10,581 loops=1)

  • Join Filter: (o.laatste_beoordeling = d.laatste_beoordeling_met_uitslag)
  • Rows Removed by Join Filter: 367
5. 4.498 166.771 ↓ 41.5 10,948 1

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

6. 10.009 118.481 ↓ 41.5 10,948 1

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

7. 1.052 64.680 ↓ 41.5 10,948 1

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

8. 0.791 6.924 ↓ 2.7 128 1

Hash Left Join (cost=500.01..905.65 rows=48 width=62) (actual time=3.135..6.924 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
9. 3.082 3.082 ↓ 1.0 9,558 1

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

10. 1.050 3.051 ↓ 1.0 9,558 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 506kB
11. 2.001 2.001 ↓ 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.001 rows=9,558 loops=1)

12. 56.704 56.704 ↑ 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.009..0.443 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
13. 43.792 43.792 ↑ 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.004..0.004 rows=1 loops=10,948)

  • Index Cond: (id = this_.screening_ronde)
14. 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)
15. 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)
16. 31.743 31.743 ↑ 1.0 1 10,581

Index Only Scan using idx_54ba8fa1f8a62420 on dossier d_1 (cost=0.43..0.47 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=10,581)

  • Index Cond: (laatste_beoordeling_met_uitslag = o.laatste_beoordeling)
  • Heap Fetches: 9,835
Planning time : 2.359 ms
Execution time : 252.469 ms