explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m31K : onderbroken

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

Limit (cost=205,002.01..205,002.02 rows=1 width=8,849) (actual time=315.762..315.762 rows=0 loops=1)

2. 0.015 315.760 ↓ 0.0 0 1

Sort (cost=205,002.01..205,002.02 rows=1 width=8,849) (actual time=315.760..315.760 rows=0 loops=1)

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

Nested Loop (cost=22,353.03..205,002.00 rows=1 width=8,849) (actual time=315.745..315.745 rows=0 loops=1)

4. 0.001 315.744 ↓ 0.0 0 1

Nested Loop (cost=22,352.60..205,001.30 rows=1 width=5,739) (actual time=315.744..315.744 rows=0 loops=1)

5. 0.008 315.743 ↓ 0.0 0 1

Nested Loop (cost=22,352.16..205,000.81 rows=1 width=4,567) (actual time=315.743..315.743 rows=0 loops=1)

6. 0.001 315.735 ↓ 0.0 0 1

Nested Loop (cost=22,351.73..205,000.33 rows=1 width=4,445) (actual time=315.735..315.735 rows=0 loops=1)

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

Nested Loop (cost=22,351.17..204,999.60 rows=1 width=4,248) (actual time=315.734..315.734 rows=0 loops=1)

8. 0.002 315.734 ↓ 0.0 0 1

Merge Join (cost=22,350.73..204,998.55 rows=2 width=4,185) (actual time=315.734..315.734 rows=0 loops=1)

  • Merge Cond: (be2_.parent = ce3_.id)
9. 0.000 315.732 ↓ 0.0 0 1

Nested Loop (cost=22,348.43..385,384.00 rows=2 width=2,096) (actual time=315.732..315.732 rows=0 loops=1)

10. 0.000 315.732 ↓ 0.0 0 1

Nested Loop (cost=22,347.87..385,375.41 rows=1 width=1,952) (actual time=315.732..315.732 rows=0 loops=1)

  • Join Filter: (se1_.beoordelings_eenheid = be2_.id)
11. 4.401 4.401 ↓ 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.029..4.401 rows=9,557 loops=1)

12. 4.989 315.381 ↓ 0.0 0 9,557

Materialize (cost=22,347.58..383,940.35 rows=1 width=943) (actual time=0.033..0.033 rows=0 loops=9,557)

13. 0.025 310.392 ↓ 0.0 0 1

Nested Loop (cost=22,347.58..383,940.34 rows=1 width=943) (actual time=310.392..310.392 rows=0 loops=1)

  • Join Filter: (this_.screenings_eenheid = se1_.id)
14. 0.122 0.122 ↑ 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.015..0.122 rows=185 loops=1)

15. 0.001 310.245 ↓ 0.0 0 185

Materialize (cost=22,347.44..383,893.74 rows=1 width=778) (actual time=1.677..1.677 rows=0 loops=185)

16. 0.000 310.244 ↓ 0.0 0 1

Nested Loop (cost=22,347.44..383,893.73 rows=1 width=778) (actual time=310.244..310.244 rows=0 loops=1)

17. 22.017 315.909 ↓ 0.0 0 1

Gather (cost=22,347.00..383,885.28 rows=1 width=727) (actual time=310.243..315.909 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
18. 263.605 293.892 ↓ 0.0 0 3 / 3

Parallel Bitmap Heap Scan on onderzoek this_ (cost=21,347.00..382,885.18 rows=1 width=727) (actual time=293.892..293.892 rows=0 loops=3)

  • Recheck Cond: (screenings_eenheid = ANY ('{363156740,363156744,363156741,363156737,363156738,363156727,363156731}'::bigint[]))
  • Filter: (is_doorgevoerd AND ((status)::text = 'ACTIEF'::text))
  • Rows Removed by Filter: 400,219
  • Heap Blocks: exact=44,049
19. 30.287 30.287 ↓ 1.2 1,291,927 1 / 3

Bitmap Index Scan on idx_e3ac833f22f5e8a4 (cost=0.00..21,347.00 rows=1,109,328 width=0) (actual time=90.860..90.860 rows=1,291,927 loops=1)

  • Index Cond: (screenings_eenheid = ANY ('{363156740,363156744,363156741,363156737,363156738,363156727,363156731}'::bigint[]))
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))
Planning time : 7.221 ms
Execution time : 322.416 ms