explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v9Qk : onderbroken vanuit SE

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,478.617 ↓ 0.0 0 1

Limit (cost=240,064.48..240,064.49 rows=1 width=8,849) (actual time=1,478.616..1,478.617 rows=0 loops=1)

2. 0.006 1,478.615 ↓ 0.0 0 1

Sort (cost=240,064.48..240,064.49 rows=1 width=8,849) (actual time=1,478.615..1,478.615 rows=0 loops=1)

  • Sort Key: this_.creatie_datum
  • Sort Method: quicksort Memory: 25kB
3. 0.001 1,478.609 ↓ 0.0 0 1

Nested Loop (cost=1,006.03..240,064.47 rows=1 width=8,849) (actual time=1,478.608..1,478.609 rows=0 loops=1)

4. 0.001 1,478.608 ↓ 0.0 0 1

Nested Loop (cost=1,005.60..240,063.77 rows=1 width=5,739) (actual time=1,478.608..1,478.608 rows=0 loops=1)

5. 0.000 1,478.607 ↓ 0.0 0 1

Nested Loop (cost=1,005.16..240,063.28 rows=1 width=4,567) (actual time=1,478.607..1,478.607 rows=0 loops=1)

6. 0.001 1,478.607 ↓ 0.0 0 1

Nested Loop (cost=1,004.73..240,062.80 rows=1 width=4,445) (actual time=1,478.607..1,478.607 rows=0 loops=1)

  • Join Filter: (uitnodigin5_.screening_ronde = ronde6_.id)
7. 0.000 1,478.606 ↓ 0.0 0 1

Nested Loop (cost=1,004.17..240,062.07 rows=1 width=4,248) (actual time=1,478.606..1,478.606 rows=0 loops=1)

8. 0.001 1,478.606 ↓ 0.0 0 1

Merge Join (cost=1,003.73..240,061.02 rows=2 width=4,185) (actual time=1,478.606..1,478.606 rows=0 loops=1)

  • Merge Cond: (be2_.parent = ce3_.id)
9. 0.001 1,478.605 ↓ 0.0 0 1

Nested Loop (cost=1,001.43..476,855.94 rows=2 width=2,096) (actual time=1,478.605..1,478.605 rows=0 loops=1)

10. 2.489 1,478.604 ↓ 0.0 0 1

Nested Loop (cost=1,000.87..476,847.35 rows=1 width=1,952) (actual time=1,478.604..1,478.604 rows=0 loops=1)

  • Join Filter: (se1_.beoordelings_eenheid = be2_.id)
11. 4.183 4.183 ↓ 1.0 9,558 1

Index Scan using idx_d21c031ac4ab08aa on org_organisatie be2_ (cost=0.29..1,291.73 rows=9,556 width=1,009) (actual time=0.014..4.183 rows=9,558 loops=1)

12. 0.000 1,471.932 ↓ 0.0 0 9,558

Materialize (cost=1,000.58..475,412.29 rows=1 width=943) (actual time=0.154..0.154 rows=0 loops=9,558)

13. 0.001 1,473.518 ↓ 0.0 0 1

Nested Loop (cost=1,000.58..475,412.28 rows=1 width=943) (actual time=1,473.518..1,473.518 rows=0 loops=1)

14. 0.002 1,473.517 ↓ 0.0 0 1

Nested Loop (cost=1,000.14..475,403.83 rows=1 width=892) (actual time=1,473.516..1,473.517 rows=0 loops=1)

  • Join Filter: (se1_.id = this_.screenings_eenheid)
15. 0.092 0.092 ↑ 1.0 7 1

Index Scan using idx_41f560e871eff274 on screenings_eenheid se1_ (cost=0.14..45.45 rows=7 width=165) (actual time=0.010..0.092 rows=7 loops=1)

  • Filter: (id = ANY ('{363156740,363156744,363156741,363156737,363156738,363156727,363156731}'::bigint[]))
  • Rows Removed by Filter: 178
16. 0.000 1,473.423 ↓ 0.0 0 7

Materialize (cost=1,000.00..475,358.27 rows=1 width=727) (actual time=210.489..210.489 rows=0 loops=7)

17. 37.804 1,506.613 ↓ 0.0 0 1

Gather (cost=1,000.00..475,358.27 rows=1 width=727) (actual time=1,473.419..1,506.613 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
18. 1,468.809 1,468.809 ↓ 0.0 0 3 / 3

Parallel Seq Scan on onderzoek this_ (cost=0.00..474,358.17 rows=1 width=727) (actual time=1,468.809..1,468.809 rows=0 loops=3)

  • Filter: (is_doorgevoerd AND ((status)::text = 'ACTIEF'::text))
  • Rows Removed by Filter: 7,847,288
19. 0.000 0.000 ↓ 0.0 0

Index Scan using mammografie_pkey on mammografie mammografi10_ (cost=0.44..8.46 rows=1 width=51) (never executed)

  • Index Cond: (id = this_.mammografie)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using uk_6257saqij0lyo0j8hl1mht33n on afspraak afspraak4_ (cost=0.56..8.58 rows=1 width=144) (never executed)

  • Index Cond: (onderzoek = this_.id)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using org_organisatie_pkey on org_organisatie ce3_ (cost=0.29..1,108.43 rows=9,556 width=2,089) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Index Scan using uitnodiging_pkey on uitnodiging uitnodigin5_ (cost=0.44..0.51 rows=1 width=63) (never executed)

  • Index Cond: (id = afspraak4_.uitnodiging)
  • Filter: (afspraak4_.id = laatste_afspraak)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using uk_rr5qvofjbl0debxhwhs5fqr9x on screening_ronde ronde6_ (cost=0.56..0.72 rows=1 width=197) (never executed)

  • Index Cond: (laatste_uitnodiging = afspraak4_.uitnodiging)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using dossier_pkey on dossier dossier7_ (cost=0.43..0.48 rows=1 width=122) (never executed)

  • Index Cond: (id = ronde6_.dossier)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_c362607491fe939 on pat_patient client8_ (cost=0.43..0.48 rows=1 width=1,172) (never executed)

  • Index Cond: (mamma_dossier = ronde6_.dossier)
  • Filter: ((dtype)::text = 'Client'::text)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using uk_cdqjphlm9rn901o1eo7rvnjkv on pat_persoon persoon9_ (cost=0.43..0.71 rows=1 width=3,110) (never executed)

  • Index Cond: (patient = client8_.id)
  • Filter: ((overlijdensdatum IS NULL) AND (datum_vertrokken_uit_nederland IS NULL))
Planning time : 5.460 ms
Execution time : 1,512.162 ms