explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gSgs : met exists

Settings
# exclusive inclusive rows x rows loops node
1. 0.756 449.929 ↑ 4.5 23 1

GroupAggregate (cost=8,865.55..8,867.36 rows=103 width=70) (actual time=448.915..449.929 rows=23 loops=1)

  • Group Key: instelling.id
2. 4.412 449.173 ↓ 102.3 10,534 1

Sort (cost=8,865.55..8,865.81 rows=103 width=70) (actual time=448.840..449.173 rows=10,534 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,354kB
3. 7.652 444.761 ↓ 102.3 10,534 1

Nested Loop Semi Join (cost=503.73..8,862.11 rows=103 width=70) (actual time=8.382..444.761 rows=10,534 loops=1)

4. 1.329 66.611 ↓ 42.9 10,897 1

Nested Loop (cost=500.43..7,164.58 rows=254 width=78) (actual time=8.232..66.611 rows=10,897 loops=1)

5. 0.852 8.834 ↓ 2.7 128 1

Hash Left Join (cost=500.01..905.65 rows=48 width=62) (actual time=4.568..8.834 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,428
6. 3.464 3.464 ↑ 1.0 9,556 1

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

7. 1.311 4.518 ↑ 1.0 9,556 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 506kB
8. 3.207 3.207 ↑ 1.0 9,556 1

Seq Scan on org_organisatie pinstellin8_ (cost=0.00..380.56 rows=9,556 width=16) (actual time=0.003..3.207 rows=9,556 loops=1)

9. 56.448 56.448 ↑ 6.2 85 128

Index Scan using idx_90905c45fe82e03a on follow_up_radiologieverslag this_ (cost=0.42..125.12 rows=527 width=24) (actual time=0.009..0.441 rows=85 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 370.498 ↑ 1.0 1 10,897

Nested Loop (cost=3.29..6.67 rows=1 width=24) (actual time=0.034..0.034 rows=1 loops=10,897)

11. 0.000 326.910 ↑ 1.0 1 10,897

Nested Loop (cost=2.86..6.19 rows=1 width=32) (actual time=0.030..0.030 rows=1 loops=10,897)

  • Join Filter: (o.id = b.onderzoek)
12. 20.199 272.425 ↑ 1.0 1 10,897

Nested Loop (cost=2.42..5.67 rows=1 width=40) (actual time=0.024..0.025 rows=1 loops=10,897)

13. 0.000 207.043 ↑ 1.0 1 10,897

Nested Loop (cost=1.99..5.17 rows=1 width=32) (actual time=0.019..0.019 rows=1 loops=10,897)

14. 0.000 141.661 ↑ 1.0 1 10,897

Nested Loop (cost=1.42..4.47 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=10,897)

  • Join Filter: (this_.screening_ronde = u.screening_ronde)
15. 0.000 87.176 ↑ 1.0 1 10,897

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

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

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

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

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

  • Index Cond: (id = fur.screening_ronde)
  • Heap Fetches: 1,577
18. 54.505 54.505 ↑ 1.0 1 10,901

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

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

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

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

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

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

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

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

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

  • Index Cond: (laatste_beoordeling_met_uitslag = b.id)
  • Heap Fetches: 10,140
Planning time : 4.241 ms
Execution time : 450.150 ms