explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2nJA : onderbroken met status onderbroken

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 749.610 ↓ 10.0 10 1

Limit (cost=212,286.65..212,286.66 rows=1 width=8,849) (actual time=749.606..749.610 rows=10 loops=1)

2. 0.062 749.607 ↓ 10.0 10 1

Sort (cost=212,286.65..212,286.66 rows=1 width=8,849) (actual time=749.605..749.607 rows=10 loops=1)

  • Sort Key: this_.creatie_datum
  • Sort Method: quicksort Memory: 53kB
3. 0.020 749.545 ↓ 14.0 14 1

Nested Loop (cost=27,373.93..212,286.64 rows=1 width=8,849) (actual time=608.598..749.545 rows=14 loops=1)

4. 0.029 749.441 ↓ 14.0 14 1

Nested Loop (cost=27,373.50..212,285.94 rows=1 width=5,739) (actual time=608.576..749.441 rows=14 loops=1)

5. 0.013 749.342 ↓ 14.0 14 1

Nested Loop (cost=27,373.06..212,285.45 rows=1 width=4,567) (actual time=608.553..749.342 rows=14 loops=1)

6. 0.020 749.245 ↓ 14.0 14 1

Nested Loop (cost=27,372.63..212,284.97 rows=1 width=4,445) (actual time=608.534..749.245 rows=14 loops=1)

  • Join Filter: (uitnodigin5_.screening_ronde = ronde6_.id)
7. 0.044 749.129 ↓ 16.0 16 1

Nested Loop (cost=27,372.07..212,284.24 rows=1 width=4,248) (actual time=608.513..749.129 rows=16 loops=1)

8. 0.399 748.655 ↓ 43.0 86 1

Merge Join (cost=27,371.63..212,283.19 rows=2 width=4,185) (actual time=608.249..748.655 rows=86 loops=1)

  • Merge Cond: (be2_.parent = ce3_.id)
9. 0.059 742.563 ↓ 43.0 86 1

Nested Loop (cost=27,369.33..394,932.38 rows=2 width=2,096) (actual time=602.215..742.563 rows=86 loops=1)

10. 116.305 742.074 ↓ 86.0 86 1

Nested Loop (cost=27,368.77..394,923.80 rows=1 width=1,952) (actual time=602.186..742.074 rows=86 loops=1)

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

12. 26.756 621.270 ↓ 86.0 86 9,558

Materialize (cost=27,368.48..393,488.73 rows=1 width=943) (actual time=0.062..0.065 rows=86 loops=9,558)

13. 1.667 594.514 ↓ 86.0 86 1

Nested Loop (cost=27,368.48..393,488.73 rows=1 width=943) (actual time=592.494..594.514 rows=86 loops=1)

  • Join Filter: (this_.screenings_eenheid = se1_.id)
  • Rows Removed by Join Filter: 15,824
14. 0.107 0.107 ↑ 1.0 185 1

Index Scan using idx_41f560e871eff274 on screenings_eenheid se1_ (cost=0.14..43.88 rows=185 width=165) (actual time=0.007..0.107 rows=185 loops=1)

15. 0.445 592.740 ↓ 86.0 86 185

Materialize (cost=27,368.34..393,442.07 rows=1 width=778) (actual time=2.964..3.204 rows=86 loops=185)

16. 0.000 592.295 ↓ 86.0 86 1

Nested Loop (cost=27,368.34..393,442.07 rows=1 width=778) (actual time=548.384..592.295 rows=86 loops=1)

17. 17.165 601.971 ↓ 86.0 86 1

Gather (cost=27,367.90..393,433.61 rows=1 width=727) (actual time=548.356..601.971 rows=86 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
18. 538.762 584.806 ↓ 29.0 29 3 / 3

Parallel Bitmap Heap Scan on onderzoek this_ (cost=26,367.90..392,433.51 rows=1 width=727) (actual time=543.659..584.806 rows=29 loops=3)

  • Recheck Cond: (screenings_eenheid = ANY ('{363156739,363156725,363156726,363156726,363156735,363156810,363156809,363156728,363156796,363156794}'::bigint[]))
  • Filter: (is_doorgevoerd AND ((status)::text = 'ONDERBROKEN'::text))
  • Rows Removed by Filter: 460,506
  • Heap Blocks: exact=113,183
19. 46.044 46.044 ↓ 1.2 1,613,452 1 / 3

Bitmap Index Scan on idx_e3ac833f22f5e8a4 (cost=0.00..26,367.90 rows=1,374,875 width=0) (actual time=138.132..138.132 rows=1,613,452 loops=1)

  • Index Cond: (screenings_eenheid = ANY ('{363156739,363156725,363156726,363156726,363156735,363156810,363156809,363156728,363156796,363156794}'::bigint[]))
20. 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)
21. 0.430 0.430 ↑ 1.0 1 86

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

  • Index Cond: (onderzoek = this_.id)
22. 5.693 5.693 ↑ 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.010..5.693 rows=8,962 loops=1)

23. 0.430 0.430 ↓ 0.0 0 86

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

  • Index Cond: (id = afspraak4_.uitnodiging)
  • Filter: (afspraak4_.id = laatste_afspraak)
  • Rows Removed by Filter: 1
24. 0.096 0.096 ↑ 1.0 1 16

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=16)

  • Index Cond: (laatste_uitnodiging = afspraak4_.uitnodiging)
25. 0.084 0.084 ↑ 1.0 1 14

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=14)

  • Index Cond: (id = ronde6_.dossier)
26. 0.070 0.070 ↑ 1.0 1 14

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

  • Index Cond: (mamma_dossier = ronde6_.dossier)
  • Filter: ((dtype)::text = 'Client'::text)
27. 0.084 0.084 ↑ 1.0 1 14

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=14)

  • Index Cond: (patient = client8_.id)
  • Filter: ((overlijdensdatum IS NULL) AND (datum_vertrokken_uit_nederland IS NULL))
Planning time : 5.641 ms
Execution time : 760.202 ms