explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pQNu : subquery 2

Settings
# exclusive inclusive rows x rows loops node
1. 1.123 679.985 ↑ 11.0 23 1

GroupAggregate (cost=10,605.81..10,610.22 rows=252 width=70) (actual time=678.481..679.985 rows=23 loops=1)

  • Group Key: instelling.id
2. 3.609 678.862 ↓ 42.1 10,603 1

Sort (cost=10,605.81..10,606.44 rows=252 width=70) (actual time=678.396..678.862 rows=10,603 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,360kB
3. 8.116 675.253 ↓ 42.1 10,603 1

Nested Loop Semi Join (cost=483.67..10,595.76 rows=252 width=70) (actual time=7.958..675.253 rows=10,603 loops=1)

4. 1.769 67.472 ↓ 43.3 10,903 1

Nested Loop (cost=480.25..7,080.12 rows=252 width=78) (actual time=7.819..67.472 rows=10,903 loops=1)

5. 1.663 5.671 ↓ 2.7 128 1

Hash Left Join (cost=479.83..865.37 rows=48 width=62) (actual time=3.038..5.671 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,420
6. 1.019 1.019 ↑ 1.0 9,548 1

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

7. 0.917 2.989 ↑ 1.0 9,548 1

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

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

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

9. 60.032 60.032 ↑ 6.2 85 128

Index Scan using idx_90905c45fe82e03a on follow_up_radiologieverslag this_ (cost=0.42..124.24 rows=523 width=24) (actual time=0.351..0.469 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: 724
10. 1.500 599.665 ↑ 1.0 1 10,903

Nested Loop (cost=3.42..13.94 rows=1 width=8) (actual time=0.055..0.055 rows=1 loops=10,903)

  • Join Filter: (b.onderzoek = o.id)
11. 39.791 545.150 ↑ 1.0 1 10,903

Nested Loop (cost=2.98..13.43 rows=1 width=24) (actual time=0.050..0.050 rows=1 loops=10,903)

12. 5.400 447.023 ↓ 5.0 5 10,903

Nested Loop (cost=2.56..12.98 rows=1 width=32) (actual time=0.037..0.041 rows=5 loops=10,903)

13. 10.895 250.769 ↑ 1.0 1 10,903

Nested Loop (cost=2.00..9.10 rows=1 width=32) (actual time=0.023..0.023 rows=1 loops=10,903)

14. 17.028 196.254 ↑ 1.0 1 10,903

Nested Loop (cost=1.56..8.62 rows=1 width=32) (actual time=0.018..0.018 rows=1 loops=10,903)

15. 10.759 130.836 ↑ 1.0 1 10,903

Nested Loop (cost=1.13..8.11 rows=1 width=16) (actual time=0.011..0.012 rows=1 loops=10,903)

16. 54.515 54.515 ↑ 1.0 1 10,903

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

  • Index Cond: (screening_ronde = this_.screening_ronde)
17. 65.562 65.562 ↑ 2.0 1 10,927

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

  • Index Cond: (uitnodiging = u.id)
18. 48.390 48.390 ↑ 1.0 1 16,130

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

  • Index Cond: (onderzoek = a.onderzoek)
19. 43.620 43.620 ↑ 1.0 1 10,905

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

  • Index Cond: (laatste_beoordeling_met_uitslag = b.id)
20. 190.854 190.854 ↑ 17.8 6 10,603

Index Scan using idx_e9c7ada36de37ecb on screening_ronde sr (cost=0.56..2.80 rows=107 width=16) (actual time=0.015..0.018 rows=6 loops=10,603)

  • Index Cond: (dossier = d.id)
21. 58.336 58.336 ↓ 0.0 0 58,336

Index Only Scan using idx_90905c45f999889 on follow_up_radiologieverslag fur (cost=0.42..0.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=58,336)

  • Index Cond: (screening_ronde = sr.id)
  • Heap Fetches: 10,603
22. 53.015 53.015 ↑ 1.0 1 10,603

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

  • Index Cond: (id = a.onderzoek)
  • Heap Fetches: 10,603
Planning time : 2.546 ms
Execution time : 680.099 ms