explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BBy2

Settings
# exclusive inclusive rows x rows loops node
1. 9.926 1,512.730 ↑ 104.9 91 1

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

  • Group Key: instelling.id
2. 0.000 1,502.804 ↓ 2.3 46,194 1

Nested Loop Semi Join (cost=483.25..405,900.38 rows=20,466 width=70) (actual time=35.707..1,502.804 rows=46,194 loops=1)

3. 12.993 66.957 ↑ 1.0 48,032 1

Hash Join (cost=479.83..15,889.69 rows=50,190 width=78) (actual time=35.537..66.957 rows=48,032 loops=1)

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

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

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

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

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

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

7. 55.384 1,440.960 ↑ 1.0 1 48,032

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

8. 0.000 1,200.800 ↑ 1.0 1 48,032

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

9. 0.000 1,008.672 ↑ 1.0 1 48,032

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

  • Join Filter: (o.id = b.onderzoek)
10. 0.000 816.544 ↑ 1.0 1 48,032

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

11. 47.357 624.416 ↑ 1.0 1 48,032

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

12. 47.920 336.224 ↑ 1.0 1 48,032

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (id = u.screening_ronde)
  • Heap Fetches: 46,194
Planning time : 3.638 ms
Execution time : 1,513.081 ms