explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fwt5 : radiologieverslag laatste onderzoek

Settings
# exclusive inclusive rows x rows loops node
1. 0.876 313.768 ↑ 2.2 24 1

GroupAggregate (cost=11,364.51..11,365.46 rows=54 width=70) (actual time=312.595..313.768 rows=24 loops=1)

  • Group Key: instelling.id
2. 3.672 312.892 ↓ 218.4 11,791 1

Sort (cost=11,364.51..11,364.65 rows=54 width=70) (actual time=312.490..312.892 rows=11,791 loops=1)

  • Sort Key: instelling.id
  • Sort Method: quicksort Memory: 1,487kB
3. 7.290 309.220 ↓ 218.4 11,791 1

Nested Loop (cost=502.30..11,362.96 rows=54 width=70) (actual time=7.309..309.220 rows=11,791 loops=1)

4. 9.981 266.557 ↓ 218.4 11,791 1

Nested Loop Semi Join (cost=501.87..11,337.74 rows=54 width=78) (actual time=7.297..266.557 rows=11,791 loops=1)

5. 2.160 208.068 ↓ 38.0 12,127 1

Nested Loop (cost=501.43..11,187.13 rows=319 width=86) (actual time=7.281..208.068 rows=12,127 loops=1)

6. 8.111 145.273 ↓ 38.0 12,127 1

Nested Loop (cost=501.00..11,024.06 rows=319 width=86) (actual time=7.263..145.273 rows=12,127 loops=1)

7. 1.243 76.527 ↓ 38.0 12,127 1

Nested Loop (cost=500.43..8,485.23 rows=319 width=78) (actual time=7.240..76.527 rows=12,127 loops=1)

8. 0.854 7.909 ↓ 2.2 125 1

Hash Left Join (cost=500.01..905.65 rows=58 width=62) (actual time=3.899..7.909 rows=125 loops=1)

  • Hash Cond: (instelling.parent = pinstellin8_.id)
  • Filter: ((instelling.parent = 60,096,047) OR (pinstellin8_.parent = 60,096,047))
  • Rows Removed by Filter: 9,433
9. 3.252 3.252 ↓ 1.0 9,558 1

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

10. 1.188 3.803 ↓ 1.0 9,558 1

Hash (cost=380.56..380.56 rows=9,556 width=16) (actual time=3.802..3.803 rows=9,558 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 506kB
11. 2.615 2.615 ↓ 1.0 9,558 1

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

12. 67.375 67.375 ↑ 5.6 97 125

Index Scan using idx_90905c45fe82e03a on follow_up_radiologieverslag this_ (cost=0.42..125.20 rows=548 width=24) (actual time=0.011..0.539 rows=97 loops=125)

  • Index Cond: (aangemaakt_in = instelling.id)
  • Filter: ((ingevoerd_op IS NULL) AND (aangemaakt_op <= (now() - '30 days'::interval)))
  • Rows Removed by Filter: 892
13. 60.635 60.635 ↑ 1.0 1 12,127

Index Scan using screening_ronde_pkey on screening_ronde sr (cost=0.56..7.96 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=12,127)

  • Index Cond: (id = this_.screening_ronde)
14. 60.635 60.635 ↑ 1.0 1 12,127

Index Scan using onderzoek_pkey on onderzoek o (cost=0.44..0.51 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=12,127)

  • Index Cond: (id = sr.laatste_onderzoek)
15. 48.508 48.508 ↑ 1.0 1 12,127

Index Only Scan using idx_54ba8fa1f8a62420 on dossier d_1 (cost=0.43..0.47 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=12,127)

  • Index Cond: (laatste_beoordeling_met_uitslag = o.laatste_beoordeling)
  • Heap Fetches: 10,759
16. 35.373 35.373 ↑ 1.0 1 11,791

Index Only Scan using dossier_pkey on dossier d (cost=0.43..0.47 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=11,791)

  • Index Cond: (id = sr.dossier)
  • Heap Fetches: 10,535
Planning time : 2.058 ms
Execution time : 313.985 ms