explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T1pU

Settings
# exclusive inclusive rows x rows loops node
1. 12.411 1,619.685 ↑ 104.9 91 1

HashAggregate (cost=406,002.71..406,098.19 rows=9,548 width=70) (actual time=1,619.603..1,619.685 rows=91 loops=1)

  • Group Key: instelling.id
2. 0.000 1,607.274 ↓ 2.3 46,197 1

Nested Loop Semi Join (cost=483.25..405,900.38 rows=20,466 width=70) (actual time=35.981..1,607.274 rows=46,197 loops=1)

3. 14.691 70.387 ↑ 1.0 48,035 1

Hash Join (cost=479.83..15,889.69 rows=50,190 width=78) (actual time=35.770..70.387 rows=48,035 loops=1)

  • Hash Cond: (this_.aangemaakt_in = instelling.id)
4. 51.121 51.121 ↑ 1.0 48,035 1

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

  • Filter: ((ingevoerd_op IS NULL) AND (aangemaakt_op <= (now() - '30 days'::interval)))
  • Rows Removed by Filter: 413,797
5. 1.354 4.575 ↑ 1.0 9,548 1

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

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

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

7. 9.190 1,537.120 ↑ 1.0 1 48,035

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

8. 0.000 1,296.945 ↑ 1.0 1 48,035

Nested Loop (cost=2.86..7.09 rows=1 width=16) (actual time=0.027..0.027 rows=1 loops=48,035)

9. 47.875 1,104.805 ↑ 1.0 1 48,035

Nested Loop (cost=2.42..6.61 rows=1 width=24) (actual time=0.023..0.023 rows=1 loops=48,035)

  • Join Filter: (o.id = b.onderzoek)
10. 31.453 864.630 ↑ 1.0 1 48,035

Nested Loop (cost=1.99..6.09 rows=1 width=32) (actual time=0.018..0.018 rows=1 loops=48,035)

11. 0.000 624.455 ↑ 1.0 1 48,035

Nested Loop (cost=1.55..5.59 rows=1 width=24) (actual time=0.013..0.013 rows=1 loops=48,035)

12. 0.000 384.280 ↑ 1.0 1 48,035

Nested Loop (cost=0.98..4.87 rows=1 width=24) (actual time=0.008..0.008 rows=1 loops=48,035)

  • Join Filter: (this_.screening_ronde = u.screening_ronde)
13. 144.105 144.105 ↑ 1.0 1 48,035

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=48,035)

  • Index Cond: (screening_ronde = this_.screening_ronde)
  • Heap Fetches: 48,063
14. 240.315 240.315 ↑ 1.0 1 48,063

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

  • Index Cond: (screening_ronde = fur.screening_ronde)
15. 240.850 240.850 ↑ 2.0 1 48,170

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

  • Index Cond: (uitnodiging = u.id)
16. 208.722 208.722 ↑ 1.0 1 69,574

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

  • Index Cond: (id = a.onderzoek)
  • Heap Fetches: 48,075
17. 192.300 192.300 ↑ 1.0 1 48,075

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

  • Index Cond: (onderzoek = a.onderzoek)
18. 192.324 192.324 ↑ 1.0 1 48,081

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=48,081)

  • Index Cond: (laatste_beoordeling_met_uitslag = b.id)
  • Heap Fetches: 46,197
19. 230.985 230.985 ↑ 1.0 1 46,197

Index Only Scan using screening_ronde_pkey on screening_ronde sr (cost=0.56..0.67 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=46,197)

  • Index Cond: (id = u.screening_ronde)
  • Heap Fetches: 46,197
Planning time : 3.302 ms
Execution time : 1,619.873 ms