explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1QwL : onderbroken vanuit dossier

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

Limit (cost=395,436.54..395,436.54 rows=1 width=8,849) (actual time=779.899..779.902 rows=10 loops=1)

2. 0.119 779.899 ↓ 10.0 10 1

Sort (cost=395,436.54..395,436.54 rows=1 width=8,849) (actual time=779.897..779.899 rows=10 loops=1)

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

Nested Loop (cost=27,371.64..395,436.53 rows=1 width=8,849) (actual time=677.145..779.780 rows=14 loops=1)

4. 0.079 779.610 ↓ 14.0 14 1

Nested Loop (cost=27,371.20..395,435.82 rows=1 width=5,739) (actual time=677.122..779.610 rows=14 loops=1)

5. 4.632 779.377 ↓ 14.0 14 1

Nested Loop (cost=27,370.77..395,435.25 rows=1 width=4,567) (actual time=677.089..779.377 rows=14 loops=1)

  • Join Filter: (be2_.parent = ce3_.id)
  • Rows Removed by Join Filter: 117,208
6. 56.729 730.085 ↓ 14.0 14 1

Nested Loop (cost=27,370.77..394,935.24 rows=1 width=2,478) (actual time=673.208..730.085 rows=14 loops=1)

  • Join Filter: (se1_.beoordelings_eenheid = be2_.id)
  • Rows Removed by Join Filter: 133,798
7. 4.296 4.296 ↓ 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.020..4.296 rows=9,558 loops=1)

8. 0.000 669.060 ↓ 14.0 14 9,558

Materialize (cost=27,370.48..393,500.17 rows=1 width=1,469) (actual time=0.070..0.070 rows=14 loops=9,558)

9. 0.879 669.403 ↓ 14.0 14 1

Nested Loop (cost=27,370.48..393,500.17 rows=1 width=1,469) (actual time=668.333..669.403 rows=14 loops=1)

  • Join Filter: (this_.screenings_eenheid = se1_.id)
  • Rows Removed by Join Filter: 2,576
10. 0.119 0.119 ↑ 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.119 rows=185 loops=1)

11. 0.199 668.405 ↓ 14.0 14 185

Materialize (cost=27,370.34..393,453.52 rows=1 width=1,304) (actual time=3.516..3.613 rows=14 loops=185)

12. 0.031 668.206 ↓ 14.0 14 1

Nested Loop (cost=27,370.34..393,453.51 rows=1 width=1,304) (actual time=650.498..668.206 rows=14 loops=1)

13. 0.034 668.091 ↓ 14.0 14 1

Nested Loop (cost=27,369.90..393,445.06 rows=1 width=1,253) (actual time=650.484..668.091 rows=14 loops=1)

14. 0.000 667.959 ↓ 14.0 14 1

Nested Loop (cost=27,369.47..393,443.46 rows=1 width=1,131) (actual time=650.464..667.959 rows=14 loops=1)

15. 17.759 678.272 ↓ 16.0 16 1

Gather (cost=27,368.90..393,442.71 rows=1 width=934) (actual time=622.696..678.272 rows=16 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
16. 0.038 660.513 ↓ 5.0 5 3 / 3

Nested Loop (cost=26,368.90..392,442.61 rows=1 width=934) (actual time=625.069..660.513 rows=5 loops=3)

17. 0.077 660.217 ↓ 29.0 29 3 / 3

Nested Loop (cost=26,368.47..392,442.10 rows=1 width=871) (actual time=617.832..660.217 rows=29 loops=3)

18. 597.118 659.739 ↓ 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=617.772..659.739 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=97,745
19. 62.621 62.621 ↓ 1.2 1,613,467 1 / 3

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

  • Index Cond: (screenings_eenheid = ANY ('{363156739,363156725,363156726,363156726,363156735,363156810,363156809,363156728,363156796,363156794}'::bigint[]))
20. 0.401 0.401 ↑ 1.0 1 86 / 3

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

  • Index Cond: (onderzoek = this_.id)
21. 0.258 0.258 ↓ 0.0 0 86 / 3

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

  • Index Cond: (laatste_afspraak = afspraak4_.id)
22. 0.112 0.112 ↑ 1.0 1 16

Index Scan using uk_rr5qvofjbl0debxhwhs5fqr9x on screening_ronde ronde6_ (cost=0.56..0.75 rows=1 width=197) (actual time=0.007..0.007 rows=1 loops=16)

  • Index Cond: (laatste_uitnodiging = uitnodigin5_.id)
  • Filter: ((status)::text = 'LOPEND'::text)
23. 0.098 0.098 ↑ 1.0 1 14

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

  • Index Cond: (laatste_screening_ronde = ronde6_.id)
24. 0.084 0.084 ↑ 1.0 1 14

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

  • Index Cond: (id = this_.mammografie)
25. 44.660 44.660 ↑ 1.1 8,373 14

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

26. 0.154 0.154 ↑ 1.0 1 14

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

  • Index Cond: (mamma_dossier = dossier7_.id)
  • Filter: ((dtype)::text = 'Client'::text)
27. 0.112 0.112 ↑ 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.008..0.008 rows=1 loops=14)

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