explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5il

Settings
# exclusive inclusive rows x rows loops node
1. 6.550 1,529.164 ↓ 91.0 91 1

GroupAggregate (cost=405,804.67..405,804.69 rows=1 width=70) (actual time=1,517.497..1,529.164 rows=91 loops=1)

  • Group Key: instelling.id
2. 21.256 1,522.614 ↓ 46,198.0 46,198 1

Sort (cost=405,804.67..405,804.67 rows=1 width=70) (actual time=1,517.232..1,522.614 rows=46,198 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 6,769kB
3. 0.000 1,501.358 ↓ 46,198.0 46,198 1

Nested Loop Semi Join (cost=483.25..405,804.66 rows=1 width=70) (actual time=35.301..1,501.358 rows=46,198 loops=1)

4. 14.608 67.988 ↑ 1.0 48,036 1

Hash Join (cost=479.83..15,889.69 rows=50,190 width=78) (actual time=35.151..67.988 rows=48,036 loops=1)

  • Hash Cond: (this_.aangemaakt_in = instelling.id)
5. 48.806 48.806 ↑ 1.0 48,036 1

Seq Scan on follow_up_radiologieverslag this_ (cost=0.00..15,278.06 rows=50,190 width=24) (actual time=30.537..48.806 rows=48,036 loops=1)

  • Filter: ((ingevoerd_op IS NULL) AND (aangemaakt_op <= (now() - '30 days'::interval)))
  • Rows Removed by Filter: 413,796
6. 1.373 4.574 ↑ 1.0 9,548 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 828kB
7. 3.201 3.201 ↑ 1.0 9,548 1

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

8. 47.876 1,441.080 ↑ 1.0 1 48,036

Nested Loop (cost=3.42..7.76 rows=1 width=24) (actual time=0.030..0.030 rows=1 loops=48,036)

  • Join Filter: ((d.laatste_beoordeling_met_uitslag = b.id) AND (o.id = b.onderzoek))
  • Rows Removed by Join Filter: 0
9. 0.000 1,200.900 ↑ 1.0 1 48,036

Nested Loop (cost=2.98..7.24 rows=1 width=48) (actual time=0.025..0.025 rows=1 loops=48,036)

10. 0.000 1,008.756 ↑ 1.0 1 48,036

Nested Loop (cost=2.54..6.74 rows=1 width=40) (actual time=0.020..0.021 rows=1 loops=48,036)

11. 47.631 768.576 ↑ 1.0 1 48,036

Nested Loop (cost=1.98..6.01 rows=1 width=40) (actual time=0.016..0.016 rows=1 loops=48,036)

12. 47.496 576.432 ↑ 1.0 1 48,036

Nested Loop (cost=1.55..5.55 rows=1 width=40) (actual time=0.012..0.012 rows=1 loops=48,036)

  • Join Filter: (fur.screening_ronde = sr.id)
13. 47.924 336.252 ↑ 1.0 1 48,036

Nested Loop (cost=0.98..4.86 rows=1 width=24) (actual time=0.007..0.007 rows=1 loops=48,036)

14. 96.072 96.072 ↑ 1.0 1 48,036

Index Only Scan using idx_90905c45f999889 on follow_up_radiologieverslag fur (cost=0.42..1.11 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=48,036)

  • Index Cond: (screening_ronde = this_.screening_ronde)
  • Heap Fetches: 48,064
15. 192.256 192.256 ↑ 1.0 1 48,064

Index Scan using idx_70765babf999889 on uitnodiging u (cost=0.56..3.74 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=48,064)

  • Index Cond: (screening_ronde = fur.screening_ronde)
16. 192.684 192.684 ↑ 1.0 1 48,171

Index Scan using screening_ronde_pkey on screening_ronde sr (cost=0.56..0.67 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=48,171)

  • Index Cond: (id = u.screening_ronde)
17. 144.513 144.513 ↑ 1.0 1 48,171

Index Scan using dossier_pkey on dossier d (cost=0.43..0.47 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=48,171)

  • Index Cond: (id = sr.dossier)
18. 240.855 240.855 ↑ 2.0 1 48,171

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

  • Index Cond: (uitnodiging = u.id)
19. 208.725 208.725 ↑ 1.0 1 69,575

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=69,575)

  • Index Cond: (id = a.onderzoek)
  • Heap Fetches: 48,076
20. 192.304 192.304 ↑ 1.0 1 48,076

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

  • Index Cond: (onderzoek = a.onderzoek)
Planning time : 7.852 ms
Execution time : 1,530.060 ms