explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 86sy : onderbroken vanuit dossier

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

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

2. 0.111 655.932 ↓ 10.0 10 1

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

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

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

4. 0.060 655.664 ↓ 14.0 14 1

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

5. 4.510 655.478 ↓ 14.0 14 1

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

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

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

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

8. 4.752 554.364 ↓ 14.0 14 9,558

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

9. 0.803 549.612 ↓ 14.0 14 1

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

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

11. 0.189 548.710 ↓ 14.0 14 185

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

12. 0.024 548.521 ↓ 14.0 14 1

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

13. 0.035 548.413 ↓ 14.0 14 1

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

14. 0.000 548.294 ↓ 14.0 14 1

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

15. 16.433 557.940 ↓ 16.0 16 1

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

  • Workers Planned: 2
  • Workers Launched: 2
16. 0.032 541.507 ↓ 5.0 5 3 / 3

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

17. 0.097 541.217 ↓ 29.0 29 3 / 3

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

18. 497.099 540.747 ↓ 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=501.472..540.747 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,507
  • Heap Blocks: exact=106,286
19. 43.648 43.648 ↓ 1.2 1,613,463 1 / 3

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

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

Index Scan using uk_fyrlkwowr1i9a56t2meln38gf on dossier dossier7_ (cost=0.43..1.60 rows=1 width=122) (actual time=0.006..0.006 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. 41.832 41.832 ↑ 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.002..2.988 rows=8,373 loops=14)

26. 0.126 0.126 ↑ 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.009..0.009 rows=1 loops=14)

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

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