explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mOy6 : onderbroken met exists

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

Limit (cost=240,078.17..240,078.18 rows=1 width=8,849) (actual time=1,811.853..1,811.853 rows=0 loops=1)

2. 0.006 1,811.851 ↓ 0.0 0 1

Sort (cost=240,078.17..240,078.18 rows=1 width=8,849) (actual time=1,811.851..1,811.851 rows=0 loops=1)

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

Nested Loop (cost=1,006.03..240,078.16 rows=1 width=8,849) (actual time=1,811.845..1,811.845 rows=0 loops=1)

  • Join Filter: (this_.screenings_eenheid = screenings_eenheid.id)
4. 0.001 1,811.844 ↓ 0.0 0 1

Nested Loop (cost=1,006.03..240,065.00 rows=1 width=8,849) (actual time=1,811.844..1,811.844 rows=0 loops=1)

5. 0.001 1,811.843 ↓ 0.0 0 1

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

6. 0.000 1,811.842 ↓ 0.0 0 1

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

7. 0.001 1,811.842 ↓ 0.0 0 1

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

  • Join Filter: (uitnodigin5_.screening_ronde = ronde6_.id)
8. 0.001 1,811.841 ↓ 0.0 0 1

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

9. 0.001 1,811.840 ↓ 0.0 0 1

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

  • Merge Cond: (be2_.parent = ce3_.id)
10. 0.002 1,811.839 ↓ 0.0 0 1

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

11. 1.459 1,811.837 ↓ 0.0 0 1

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

  • Join Filter: (se1_.beoordelings_eenheid = be2_.id)
12. 4.105 4.105 ↓ 1.0 9,557 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.018..4.105 rows=9,557 loops=1)

13. 0.000 1,806.273 ↓ 0.0 0 9,557

Materialize (cost=1,000.58..475,413.34 rows=1 width=943) (actual time=0.189..0.189 rows=0 loops=9,557)

14. 0.077 1,806.884 ↓ 0.0 0 1

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

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

Index Scan using idx_41f560e871eff274 on screenings_eenheid se1_ (cost=0.14..43.84 rows=185 width=165) (actual time=0.008..0.097 rows=185 loops=1)

16. 0.000 1,806.710 ↓ 0.0 0 185

Materialize (cost=1,000.44..475,366.73 rows=1 width=778) (actual time=9.766..9.766 rows=0 loops=185)

17. 0.000 1,806.766 ↓ 0.0 0 1

Nested Loop (cost=1,000.44..475,366.72 rows=1 width=778) (actual time=1,806.766..1,806.766 rows=0 loops=1)

18. 47.553 1,848.927 ↓ 0.0 0 1

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

  • Workers Planned: 2
  • Workers Launched: 2
19. 1,801.374 1,801.374 ↓ 0.0 0 3 / 3

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

  • Filter: (is_doorgevoerd AND ((status)::text = 'ACTIEF'::text))
  • Rows Removed by Filter: 7,847,273
20. 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)
21. 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)
22. 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)

23. 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)
24. 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)
25. 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)
26. 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)
27. 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))
28. 0.000 0.000 ↓ 0.0 0

Seq Scan on screenings_eenheid (cost=0.00..10.85 rows=185 width=8) (never executed)

Planning time : 9.678 ms
Execution time : 1,854.520 ms