explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6IHo : onderbroken met status onderbroken

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,491.969 ↓ 10.0 10 1

Limit (cost=240,066.88..240,066.88 rows=1 width=8,849) (actual time=1,491.966..1,491.969 rows=10 loops=1)

2. 0.078 1,491.967 ↓ 10.0 10 1

Sort (cost=240,066.88..240,066.88 rows=1 width=8,849) (actual time=1,491.965..1,491.967 rows=10 loops=1)

  • Sort Key: this_.creatie_datum
  • Sort Method: quicksort Memory: 55kB
3. 0.029 1,491.889 ↓ 15.0 15 1

Nested Loop (cost=1,006.03..240,066.87 rows=1 width=8,849) (actual time=1,426.577..1,491.889 rows=15 loops=1)

4. 0.024 1,491.770 ↓ 15.0 15 1

Nested Loop (cost=1,005.60..240,066.16 rows=1 width=5,739) (actual time=1,426.555..1,491.770 rows=15 loops=1)

5. 0.022 1,491.656 ↓ 15.0 15 1

Nested Loop (cost=1,005.16..240,065.67 rows=1 width=4,567) (actual time=1,426.535..1,491.656 rows=15 loops=1)

6. 0.028 1,491.544 ↓ 15.0 15 1

Nested Loop (cost=1,004.73..240,065.19 rows=1 width=4,445) (actual time=1,426.519..1,491.544 rows=15 loops=1)

  • Join Filter: (uitnodigin5_.screening_ronde = ronde6_.id)
7. 0.006 1,491.414 ↓ 17.0 17 1

Nested Loop (cost=1,004.17..240,064.46 rows=1 width=4,248) (actual time=1,426.497..1,491.414 rows=17 loops=1)

8. 0.401 1,490.892 ↓ 43.0 86 1

Merge Join (cost=1,003.73..240,063.41 rows=2 width=4,185) (actual time=1,426.246..1,490.892 rows=86 loops=1)

  • Merge Cond: (be2_.parent = ce3_.id)
9. 0.029 1,484.574 ↓ 43.0 86 1

Nested Loop (cost=1,001.43..476,860.72 rows=2 width=2,096) (actual time=1,419.993..1,484.574 rows=86 loops=1)

10. 36.207 1,484.029 ↓ 86.0 86 1

Nested Loop (cost=1,000.87..476,852.14 rows=1 width=1,952) (actual time=1,419.967..1,484.029 rows=86 loops=1)

  • Join Filter: (se1_.beoordelings_eenheid = be2_.id)
  • Rows Removed by Join Filter: 821,902
11. 4.564 4.564 ↓ 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.018..4.564 rows=9,558 loops=1)

12. 27.249 1,443.258 ↓ 86.0 86 9,558

Materialize (cost=1,000.58..475,417.07 rows=1 width=943) (actual time=0.144..0.151 rows=86 loops=9,558)

13. 0.053 1,416.009 ↓ 86.0 86 1

Nested Loop (cost=1,000.58..475,417.07 rows=1 width=943) (actual time=1,371.484..1,416.009 rows=86 loops=1)

14. 0.455 1,415.526 ↓ 86.0 86 1

Nested Loop (cost=1,000.14..475,408.61 rows=1 width=892) (actual time=1,371.453..1,415.526 rows=86 loops=1)

  • Join Filter: (se1_.id = this_.screenings_eenheid)
  • Rows Removed by Join Filter: 3,730
15. 0.100 0.100 ↑ 1.1 9 1

Index Scan using idx_41f560e871eff274 on screenings_eenheid se1_ (cost=0.14..46.15 rows=10 width=165) (actual time=0.021..0.100 rows=9 loops=1)

  • Filter: (id = ANY ('{363156739,363156725,363156726,363156726,363156735,363156810,363156809,363156728,363156796,363156794}'::bigint[]))
  • Rows Removed by Filter: 176
16. 0.000 1,414.971 ↓ 424.0 424 9

Materialize (cost=1,000.00..475,362.32 rows=1 width=727) (actual time=150.580..157.219 rows=424 loops=9)

17. 27.195 1,430.721 ↓ 424.0 424 1

Gather (cost=1,000.00..475,362.31 rows=1 width=727) (actual time=1,355.218..1,430.721 rows=424 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
18. 1,403.526 1,403.526 ↓ 141.0 141 3 / 3

Parallel Seq Scan on onderzoek this_ (cost=0.00..474,362.21 rows=1 width=727) (actual time=1,343.269..1,403.526 rows=141 loops=3)

  • Filter: (is_doorgevoerd AND ((status)::text = 'ONDERBROKEN'::text))
  • Rows Removed by Filter: 7,847,165
19. 0.430 0.430 ↑ 1.0 1 86

Index Scan using mammografie_pkey on mammografie mammografi10_ (cost=0.44..8.46 rows=1 width=51) (actual time=0.005..0.005 rows=1 loops=86)

  • Index Cond: (id = this_.mammografie)
20. 0.516 0.516 ↑ 1.0 1 86

Index Scan using uk_6257saqij0lyo0j8hl1mht33n on afspraak afspraak4_ (cost=0.56..8.58 rows=1 width=144) (actual time=0.006..0.006 rows=1 loops=86)

  • Index Cond: (onderzoek = this_.id)
21. 5.917 5.917 ↑ 1.1 8,962 1

Index Scan using org_organisatie_pkey on org_organisatie ce3_ (cost=0.29..1,108.43 rows=9,556 width=2,089) (actual time=0.011..5.917 rows=8,962 loops=1)

22. 0.516 0.516 ↓ 0.0 0 86

Index Scan using uitnodiging_pkey on uitnodiging uitnodigin5_ (cost=0.44..0.51 rows=1 width=63) (actual time=0.006..0.006 rows=0 loops=86)

  • Index Cond: (id = afspraak4_.uitnodiging)
  • Filter: (afspraak4_.id = laatste_afspraak)
  • Rows Removed by Filter: 1
23. 0.102 0.102 ↑ 1.0 1 17

Index Scan using uk_rr5qvofjbl0debxhwhs5fqr9x on screening_ronde ronde6_ (cost=0.56..0.72 rows=1 width=197) (actual time=0.006..0.006 rows=1 loops=17)

  • Index Cond: (laatste_uitnodiging = afspraak4_.uitnodiging)
24. 0.090 0.090 ↑ 1.0 1 15

Index Scan using dossier_pkey on dossier dossier7_ (cost=0.43..0.48 rows=1 width=122) (actual time=0.006..0.006 rows=1 loops=15)

  • Index Cond: (id = ronde6_.dossier)
25. 0.090 0.090 ↑ 1.0 1 15

Index Scan using idx_c362607491fe939 on pat_patient client8_ (cost=0.43..0.48 rows=1 width=1,172) (actual time=0.006..0.006 rows=1 loops=15)

  • Index Cond: (mamma_dossier = ronde6_.dossier)
  • Filter: ((dtype)::text = 'Client'::text)
26. 0.090 0.090 ↑ 1.0 1 15

Index Scan using uk_cdqjphlm9rn901o1eo7rvnjkv on pat_persoon persoon9_ (cost=0.43..0.71 rows=1 width=3,110) (actual time=0.006..0.006 rows=1 loops=15)

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