explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wYVu : onderbroken vanuit dossier

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

Limit (cost=395,435.29..395,435.29 rows=1 width=8,642) (actual time=704.244..704.248 rows=10 loops=1)

2. 0.139 704.245 ↓ 10.0 10 1

Sort (cost=395,435.29..395,435.29 rows=1 width=8,642) (actual time=704.242..704.245 rows=10 loops=1)

  • Sort Key: this_.creatie_datum
  • Sort Method: quicksort Memory: 63kB
3. 0.066 704.106 ↓ 19.0 19 1

Nested Loop (cost=27,370.63..395,435.28 rows=1 width=8,642) (actual time=583.545..704.106 rows=19 loops=1)

4. 0.086 703.888 ↓ 19.0 19 1

Nested Loop (cost=27,370.20..395,434.57 rows=1 width=5,532) (actual time=583.522..703.888 rows=19 loops=1)

5. 6.234 703.593 ↓ 19.0 19 1

Nested Loop (cost=27,369.76..395,434.00 rows=1 width=4,360) (actual time=583.491..703.593 rows=19 loops=1)

  • Join Filter: (be2_.parent = ce3_.id)
  • Rows Removed by Join Filter: 159,416
6. 50.867 638.060 ↓ 19.0 19 1

Nested Loop (cost=27,369.76..394,933.99 rows=1 width=2,271) (actual time=579.829..638.060 rows=19 loops=1)

  • Join Filter: (se1_.beoordelings_eenheid = be2_.id)
  • Rows Removed by Join Filter: 181,583
7. 4.155 4.155 ↓ 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.155 rows=9,558 loops=1)

8. 6.466 583.038 ↓ 19.0 19 9,558

Materialize (cost=27,369.48..393,498.92 rows=1 width=1,262) (actual time=0.060..0.061 rows=19 loops=9,558)

9. 0.926 576.572 ↓ 19.0 19 1

Nested Loop (cost=27,369.48..393,498.92 rows=1 width=1,262) (actual time=575.588..576.572 rows=19 loops=1)

  • Join Filter: (this_.screenings_eenheid = se1_.id)
  • Rows Removed by Join Filter: 3,496
10. 0.111 0.111 ↑ 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.010..0.111 rows=185 loops=1)

11. 0.071 575.535 ↓ 19.0 19 185

Materialize (cost=27,369.33..393,452.27 rows=1 width=1,097) (actual time=2.988..3.111 rows=19 loops=185)

12. 0.036 575.464 ↓ 19.0 19 1

Nested Loop (cost=27,369.33..393,452.26 rows=1 width=1,097) (actual time=552.783..575.464 rows=19 loops=1)

13. 0.030 575.314 ↓ 19.0 19 1

Nested Loop (cost=27,368.90..393,443.81 rows=1 width=1,046) (actual time=552.768..575.314 rows=19 loops=1)

14. 0.000 575.151 ↓ 19.0 19 1

Nested Loop (cost=27,368.46..393,442.21 rows=1 width=924) (actual time=552.748..575.151 rows=19 loops=1)

15. 15.571 584.653 ↓ 86.0 86 1

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

  • Workers Planned: 2
  • Workers Launched: 2
16. 524.292 569.082 ↓ 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=530.058..569.082 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,508
  • Heap Blocks: exact=103,802
17. 44.790 44.790 ↓ 1.2 1,613,469 1 / 3

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

  • Index Cond: (screenings_eenheid = ANY ('{363156739,363156725,363156726,363156726,363156735,363156810,363156809,363156728,363156796,363156794}'::bigint[]))
18. 0.430 0.430 ↓ 0.0 0 86

Index Scan using idx_e9c7ada3349d53aa on screening_ronde ronde6_ (cost=0.56..8.58 rows=1 width=197) (actual time=0.005..0.005 rows=0 loops=86)

  • Index Cond: (laatste_onderzoek = this_.id)
  • Filter: ((status)::text = 'LOPEND'::text)
  • Rows Removed by Filter: 0
19. 0.133 0.133 ↑ 1.0 1 19

Index Scan using uk_fyrlkwowr1i9a56t2meln38gf on dossier dossier7_ (cost=0.43..1.60 rows=1 width=122) (actual time=0.007..0.007 rows=1 loops=19)

  • Index Cond: (laatste_screening_ronde = ronde6_.id)
20. 0.114 0.114 ↑ 1.0 1 19

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

  • Index Cond: (id = this_.mammografie)
21. 59.299 59.299 ↑ 1.1 8,391 19

Seq Scan on org_organisatie ce3_ (cost=0.00..380.56 rows=9,556 width=2,089) (actual time=0.003..3.121 rows=8,391 loops=19)

22. 0.209 0.209 ↑ 1.0 1 19

Index Scan using idx_c362607491fe939 on pat_patient client8_ (cost=0.43..0.56 rows=1 width=1,172) (actual time=0.010..0.011 rows=1 loops=19)

  • Index Cond: (mamma_dossier = dossier7_.id)
  • Filter: ((dtype)::text = 'Client'::text)
23. 0.152 0.152 ↑ 1.0 1 19

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

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