explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rV2U

Settings
# exclusive inclusive rows x rows loops node
1. 1.018 429.291 ↑ 4.6 23 1

GroupAggregate (cost=8,939.09..8,940.95 rows=106 width=70) (actual time=427.928..429.291 rows=23 loops=1)

  • Group Key: instelling.id
2. 4.174 428.273 ↓ 99.8 10,581 1

Sort (cost=8,939.09..8,939.36 rows=106 width=70) (actual time=427.844..428.273 rows=10,581 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,358kB
3. 5.589 424.099 ↓ 99.8 10,581 1

Nested Loop Semi Join (cost=503.73..8,935.53 rows=106 width=70) (actual time=6.222..424.099 rows=10,581 loops=1)

4. 1.268 68.174 ↓ 41.5 10,948 1

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

5. 0.811 6.746 ↓ 2.7 128 1

Hash Left Join (cost=500.01..905.65 rows=48 width=62) (actual time=2.993..6.746 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
6. 2.985 2.985 ↓ 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..2.985 rows=9,558 loops=1)

7. 0.852 2.950 ↓ 1.0 9,558 1

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

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

9. 60.160 60.160 ↑ 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.010..0.470 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
10. 0.000 350.336 ↑ 1.0 1 10,948

Nested Loop (cost=3.29..6.65 rows=1 width=24) (actual time=0.032..0.032 rows=1 loops=10,948)

11. 10.932 306.544 ↑ 1.0 1 10,948

Nested Loop (cost=2.86..6.17 rows=1 width=32) (actual time=0.028..0.028 rows=1 loops=10,948)

  • Join Filter: (o.id = b.onderzoek)
12. 9.356 251.804 ↑ 1.0 1 10,948

Nested Loop (cost=2.42..5.64 rows=1 width=40) (actual time=0.023..0.023 rows=1 loops=10,948)

13. 0.000 197.064 ↑ 1.0 1 10,948

Nested Loop (cost=1.99..5.14 rows=1 width=32) (actual time=0.018..0.018 rows=1 loops=10,948)

14. 10.932 142.324 ↑ 1.0 1 10,948

Nested Loop (cost=1.42..4.44 rows=1 width=32) (actual time=0.012..0.013 rows=1 loops=10,948)

  • Join Filter: (this_.screening_ronde = u.screening_ronde)
15. 10.932 87.584 ↑ 1.0 1 10,948

Nested Loop (cost=0.98..3.91 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=10,948)

  • Join Filter: (this_.screening_ronde = sr.id)
16. 32.844 32.844 ↑ 1.0 1 10,948

Index Only Scan using idx_90905c45f999889 on follow_up_radiologieverslag fur (cost=0.42..1.11 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=10,948)

  • Index Cond: (screening_ronde = this_.screening_ronde)
  • Heap Fetches: 10,952
17. 43.808 43.808 ↑ 1.0 1 10,952

Index Only Scan using screening_ronde_pkey on screening_ronde sr (cost=0.56..2.78 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=10,952)

  • Index Cond: (id = fur.screening_ronde)
  • Heap Fetches: 1,594
18. 43.808 43.808 ↑ 1.0 1 10,952

Index Scan using idx_70765babf999889 on uitnodiging u (cost=0.44..0.52 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=10,952)

  • Index Cond: (screening_ronde = sr.id)
19. 54.830 54.830 ↑ 1.0 1 10,966

Index Scan using idx_20d39191b0d90981 on afspraak a (cost=0.56..0.69 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=10,966)

  • Index Cond: (uitnodiging = u.id)
20. 45.384 45.384 ↑ 1.0 1 15,128

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

  • Index Cond: (id = a.onderzoek)
  • Heap Fetches: 10,952
21. 43.808 43.808 ↑ 1.0 1 10,952

Index Scan using idx_8aa01da649359f6d on beoordeling b (cost=0.44..0.51 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=10,952)

  • Index Cond: (onderzoek = a.onderzoek)
22. 43.812 43.812 ↑ 1.0 1 10,953

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

  • Index Cond: (laatste_beoordeling_met_uitslag = b.id)
  • Heap Fetches: 10,201
Planning time : 3.331 ms
Execution time : 429.415 ms