explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jDMy : radiologieverslag laatste onderzoek

Settings
# exclusive inclusive rows x rows loops node
1. 0.911 264.847 ↑ 2.2 24 1

GroupAggregate (cost=11,339.29..11,340.24 rows=54 width=70) (actual time=263.668..264.847 rows=24 loops=1)

  • Group Key: instelling.id
2. 3.283 263.936 ↓ 218.4 11,791 1

Sort (cost=11,339.29..11,339.43 rows=54 width=70) (actual time=263.516..263.936 rows=11,791 loops=1)

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

Nested Loop Semi Join (cost=501.87..11,337.74 rows=54 width=70) (actual time=6.956..260.653 rows=11,791 loops=1)

4. 1.142 204.338 ↓ 38.0 12,127 1

Nested Loop (cost=501.43..11,187.13 rows=319 width=78) (actual time=6.939..204.338 rows=12,127 loops=1)

5. 6.663 142.561 ↓ 38.0 12,127 1

Nested Loop (cost=501.00..11,024.06 rows=319 width=78) (actual time=6.924..142.561 rows=12,127 loops=1)

6. 1.103 75.263 ↓ 38.0 12,127 1

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

7. 0.840 7.535 ↓ 2.2 125 1

Hash Left Join (cost=500.01..905.65 rows=58 width=62) (actual time=3.503..7.535 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
8. 3.238 3.238 ↓ 1.0 9,558 1

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

9. 1.033 3.457 ↓ 1.0 9,558 1

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

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

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

11. 66.625 66.625 ↑ 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.533 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
12. 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=16) (actual time=0.005..0.005 rows=1 loops=12,127)

  • Index Cond: (id = this_.screening_ronde)
13. 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)
14. 48.508 48.508 ↑ 1.0 1 12,127

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=12,127)

  • Index Cond: (laatste_beoordeling_met_uitslag = o.laatste_beoordeling)
  • Heap Fetches: 10,759
Planning time : 1.422 ms
Execution time : 264.931 ms