explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ol4X

Settings
# exclusive inclusive rows x rows loops node
1. 1.332 1,498.317 ↑ 4.2 23 1

GroupAggregate (cost=492,653.38..492,655.08 rows=97 width=70) (actual time=1,496.236..1,498.317 rows=23 loops=1)

  • Group Key: instelling.id
2. 4.862 1,496.985 ↓ 109.2 10,593 1

Sort (cost=492,653.38..492,653.62 rows=97 width=70) (actual time=1,496.024..1,496.985 rows=10,593 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,359kB
3. 13.128 1,492.123 ↓ 109.2 10,593 1

Hash Left Join (cost=483.11..492,650.18 rows=97 width=70) (actual time=35.854..1,492.123 rows=10,593 loops=1)

  • Hash Cond: (instelling.parent = pinstellin8_.id)
  • Filter: ((instelling.parent = 10,910,337) OR (pinstellin8_.parent = 10,910,337))
  • Rows Removed by Filter: 35,602
4. 15.134 1,476.139 ↓ 2.4 46,195 1

Nested Loop (cost=3.28..492,119.75 rows=19,277 width=78) (actual time=32.699..1,476.139 rows=46,195 loops=1)

  • Join Filter: (beoordelin1_.onderzoek = onderzoek2_.id)
5. 23.851 1,276.225 ↓ 3.7 46,195 1

Nested Loop (cost=2.85..485,721.73 rows=12,492 width=94) (actual time=32.687..1,276.225 rows=46,195 loops=1)

6. 0.000 1,206.179 ↓ 3.7 46,195 1

Nested Loop (cost=2.56..481,650.24 rows=12,492 width=32) (actual time=32.662..1,206.179 rows=46,195 loops=1)

7. 10.387 982.120 ↓ 3.7 46,195 1

Nested Loop (cost=2.00..473,252.05 rows=12,501 width=48) (actual time=32.650..982.120 rows=46,195 loops=1)

8. 10.403 779.529 ↓ 1.2 48,051 1

Nested Loop (cost=1.56..454,221.32 rows=39,582 width=48) (actual time=32.596..779.529 rows=48,051 loops=1)

9. 25.751 555.085 ↓ 1.2 71,347 1

Nested Loop (cost=1.13..422,781.59 rows=61,077 width=32) (actual time=32.580..555.085 rows=71,347 loops=1)

10. 0.000 288.634 ↑ 1.0 48,140 1

Nested Loop (cost=0.56..386,414.16 rows=50,190 width=32) (actual time=32.568..288.634 rows=48,140 loops=1)

11. 52.666 52.666 ↑ 1.0 48,033 1

Seq Scan on follow_up_radiologieverslag radiologie6_ (cost=0.00..15,278.06 rows=50,190 width=16) (actual time=32.547..52.666 rows=48,033 loops=1)

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

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

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

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,140)

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

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,347)

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

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,051)

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

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,195)

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

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,195)

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

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,195)

  • Index Cond: (id = afspraak3_.onderzoek)
  • Heap Fetches: 46,195
19. 0.859 2.856 ↑ 1.0 9,548 1

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

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

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

Planning time : 2.766 ms
Execution time : 1,498.431 ms