explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fGtS : zonder join

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=9,682.92..9,687.33 rows=252 width=70) (actual rows= loops=)

  • Group Key: instelling.id
2. 0.000 0.000 ↓ 0.0

Sort (cost=9,682.92..9,683.55 rows=252 width=70) (actual rows= loops=)

  • Sort Key: instelling.id
3. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=483.25..9,672.87 rows=252 width=70) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=480.25..7,080.12 rows=252 width=78) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=479.83..865.37 rows=48 width=62) (actual rows= loops=)

  • Hash Cond: (instelling.parent = pinstellin8_.id)
  • Filter: ((instelling.parent = 10,910,337) OR (pinstellin8_.parent = 10,910,337))
6. 0.000 0.000 ↓ 0.0

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

7. 0.000 0.000 ↓ 0.0

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

8. 0.000 0.000 ↓ 0.0

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

9. 0.000 0.000 ↓ 0.0

Index Scan using idx_90905c45fe82e03a on follow_up_radiologieverslag this_ (cost=0.42..124.24 rows=523 width=24) (actual rows= loops=)

  • Index Cond: (aangemaakt_in = instelling.id)
  • Filter: ((ingevoerd_op IS NULL) AND (aangemaakt_op <= (now() - '30 days'::interval)))
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.00..10.28 rows=1 width=16) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.44..9.61 rows=1 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.00..9.13 rows=1 width=16) (actual rows= loops=)

  • Join Filter: (o.id = b.onderzoek)
13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..8.61 rows=1 width=24) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..8.11 rows=1 width=16) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Scan using idx_70765babf999889 on uitnodiging u (cost=0.56..7.38 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (screening_ronde = this_.screening_ronde)
16. 0.000 0.000 ↓ 0.0

Index Scan using idx_20d39191b0d90981 on afspraak a (cost=0.56..0.70 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (uitnodiging = u.id)
17. 0.000 0.000 ↓ 0.0

Index Only Scan using onderzoek_pkey on onderzoek o (cost=0.44..0.50 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = a.onderzoek)
18. 0.000 0.000 ↓ 0.0

Index Scan using idx_8aa01da649359f6d on beoordeling b (cost=0.44..0.50 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (onderzoek = a.onderzoek)
19. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_54ba8fa1f8a62420 on dossier d (cost=0.43..0.47 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (laatste_beoordeling_met_uitslag = b.id)
20. 0.000 0.000 ↓ 0.0

Index Only Scan using screening_ronde_pkey on screening_ronde sr (cost=0.56..0.67 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = u.screening_ronde)