explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ka4K : voor

Settings
# exclusive inclusive rows x rows loops node
1. 1.481 1,512.656 ↑ 4.9 24 1

GroupAggregate (cost=492,660.70..492,662.74 rows=117 width=70) (actual time=1,510.400..1,512.656 rows=24 loops=1)

  • Group Key: instelling.id
2. 6.090 1,511.175 ↓ 101.7 11,901 1

Sort (cost=492,660.70..492,660.99 rows=117 width=70) (actual time=1,510.118..1,511.175 rows=11,901 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,499kB
3. 13.735 1,505.085 ↓ 101.7 11,901 1

Hash Left Join (cost=483.11..492,656.68 rows=117 width=70) (actual time=37.474..1,505.085 rows=11,901 loops=1)

  • Hash Cond: (instelling.parent = pinstellin8_.id)
  • Filter: ((instelling.parent = 60,096,047) OR (pinstellin8_.parent = 60,096,047))
  • Rows Removed by Filter: 34,324
4. 18.248 1,487.830 ↓ 2.4 46,225 1

Nested Loop (cost=3.28..492,126.24 rows=19,277 width=78) (actual time=33.838..1,487.830 rows=46,225 loops=1)

  • Join Filter: (beoordelin1_.onderzoek = onderzoek2_.id)
5. 24.345 1,284.682 ↓ 3.7 46,225 1

Nested Loop (cost=2.85..485,728.22 rows=12,492 width=94) (actual time=33.824..1,284.682 rows=46,225 loops=1)

6. 0.000 1,214.112 ↓ 3.7 46,225 1

Nested Loop (cost=2.56..481,656.74 rows=12,492 width=32) (actual time=33.812..1,214.112 rows=46,225 loops=1)

7. 12.693 989.943 ↓ 3.7 46,225 1

Nested Loop (cost=2.00..473,257.88 rows=12,502 width=48) (actual time=33.799..989.943 rows=46,225 loops=1)

8. 13.220 784.926 ↓ 1.2 48,081 1

Nested Loop (cost=1.56..454,227.15 rows=39,582 width=48) (actual time=33.757..784.926 rows=48,081 loops=1)

9. 24.480 557.548 ↓ 1.2 71,386 1

Nested Loop (cost=1.13..422,786.91 rows=61,078 width=32) (actual time=33.741..557.548 rows=71,386 loops=1)

10. 0.000 292.218 ↑ 1.0 48,170 1

Nested Loop (cost=0.56..386,418.75 rows=50,191 width=32) (actual time=33.729..292.218 rows=48,170 loops=1)

11. 53.227 53.227 ↑ 1.0 48,063 1

Seq Scan on follow_up_radiologieverslag radiologie6_ (cost=0.00..15,278.06 rows=50,191 width=16) (actual time=33.703..53.227 rows=48,063 loops=1)

  • Filter: ((ingevoerd_op IS NULL) AND (aangemaakt_op <= (now() - '30 days'::interval)))
  • Rows Removed by Filter: 413,769
12. 240.315 240.315 ↑ 1.0 1 48,063

Index Scan using idx_70765babf999889 on uitnodiging uitnodigin4_ (cost=0.56..7.38 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=48,063)

  • Index Cond: (screening_ronde = radiologie6_.screening_ronde)
13. 240.850 240.850 ↑ 2.0 1 48,170

Index Scan using idx_20d39191b0d90981 on afspraak afspraak3_ (cost=0.56..0.70 rows=2 width=16) (actual time=0.004..0.005 rows=1 loops=48,170)

  • Index Cond: (uitnodiging = uitnodigin4_.id)
14. 214.158 214.158 ↑ 1.0 1 71,386

Index Scan using idx_8aa01da649359f6d on beoordeling beoordelin1_ (cost=0.44..0.50 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=71,386)

  • Index Cond: (onderzoek = afspraak3_.onderzoek)
15. 192.324 192.324 ↑ 1.0 1 48,081

Index Scan using idx_54ba8fa1f8a62420 on dossier this_ (cost=0.43..0.47 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=48,081)

  • Index Cond: (laatste_beoordeling_met_uitslag = beoordelin1_.id)
16. 231.125 231.125 ↑ 1.0 1 46,225

Index Only Scan using screening_ronde_pkey on screening_ronde screeningr5_ (cost=0.56..0.67 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=46,225)

  • Index Cond: (id = uitnodigin4_.screening_ronde)
  • Heap Fetches: 46,225
17. 46.225 46.225 ↑ 1.0 1 46,225

Index Scan using org_organisatie_pkey on org_organisatie instelling (cost=0.29..0.33 rows=1 width=70) (actual time=0.001..0.001 rows=1 loops=46,225)

  • Index Cond: (id = radiologie6_.aangemaakt_in)
18. 184.900 184.900 ↑ 1.0 1 46,225

Index Only Scan using onderzoek_pkey on onderzoek onderzoek2_ (cost=0.44..0.50 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=46,225)

  • Index Cond: (id = afspraak3_.onderzoek)
  • Heap Fetches: 46,225
19. 1.063 3.520 ↑ 1.0 9,548 1

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

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

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

Planning time : 2.729 ms
Execution time : 1,512.987 ms