explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SkiH

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1,320.395 ↓ 0.0 0 1

Limit (cost=28,443.84..28,443.85 rows=1 width=8,360) (actual time=1,320.395..1,320.395 rows=0 loops=1)

2. 0.008 1,320.392 ↓ 0.0 0 1

Sort (cost=28,443.84..28,443.85 rows=1 width=8,360) (actual time=1,320.392..1,320.392 rows=0 loops=1)

  • Sort Key: this_.creatie_datum
  • Sort Method: quicksort Memory: 25kB
3. 0.002 1,320.384 ↓ 0.0 0 1

Nested Loop (cost=1,005.90..28,443.83 rows=1 width=8,360) (actual time=1,320.384..1,320.384 rows=0 loops=1)

4. 0.001 1,320.382 ↓ 0.0 0 1

Nested Loop (cost=1,005.47..28,443.25 rows=1 width=5,249) (actual time=1,320.382..1,320.382 rows=0 loops=1)

5. 0.001 1,320.381 ↓ 0.0 0 1

Nested Loop (cost=1,005.03..28,442.77 rows=1 width=4,077) (actual time=1,320.381..1,320.381 rows=0 loops=1)

6. 0.001 1,320.380 ↓ 0.0 0 1

Nested Loop (cost=1,004.60..28,442.30 rows=1 width=3,953) (actual time=1,320.380..1,320.380 rows=0 loops=1)

  • Join Filter: (uitnodigin5_.screening_ronde = ronde6_.id)
7. 0.001 1,320.379 ↓ 0.0 0 1

Nested Loop (cost=1,004.04..28,441.63 rows=1 width=3,742) (actual time=1,320.379..1,320.379 rows=0 loops=1)

8. 0.002 1,320.378 ↓ 0.0 0 1

Nested Loop (cost=1,003.60..28,433.28 rows=1 width=3,691) (actual time=1,320.378..1,320.378 rows=0 loops=1)

9. 0.692 1,320.284 ↑ 7.0 23 1

Merge Join (cost=1,003.04..28,330.59 rows=160 width=3,628) (actual time=1,312.344..1,320.284 rows=23 loops=1)

  • Merge Cond: (be2_.parent = ce3_.id)
10. 0.033 1,316.742 ↑ 7.0 23 1

Nested Loop (cost=1,000.85..467,852.83 rows=160 width=1,540) (actual time=1,308.814..1,316.742 rows=23 loops=1)

11. 0.364 1,316.617 ↑ 4.5 23 1

Nested Loop (cost=1,000.28..466,966.61 rows=104 width=1,396) (actual time=1,308.787..1,316.617 rows=23 loops=1)

  • Join Filter: (se1_.id = this_.screenings_eenheid)
  • Rows Removed by Join Filter: 2,889
12. 6.837 8.583 ↑ 1.0 7 1

Nested Loop (cost=0.29..2,220.25 rows=7 width=1,172) (actual time=0.951..8.583 rows=7 loops=1)

  • Join Filter: (se1_.beoordelings_eenheid = be2_.id)
  • Rows Removed by Join Filter: 66,829
13. 1.746 1.746 ↑ 1.0 9,548 1

Index Scan using idx_d21c031ac4ab08aa on org_organisatie be2_ (cost=0.29..1,208.23 rows=9,548 width=1,009) (actual time=0.014..1.746 rows=9,548 loops=1)

14. 0.000 0.000 ↑ 1.0 7 9,548

Materialize (cost=0.00..9.50 rows=7 width=163) (actual time=0.000..0.000 rows=7 loops=9,548)

15. 0.065 0.065 ↑ 1.0 7 1

Seq Scan on screenings_eenheid se1_ (cost=0.00..9.47 rows=7 width=163) (actual time=0.017..0.065 rows=7 loops=1)

  • Filter: (id = ANY ('{363156740,363156744,363156741,363156737,363156738,363156727,363156731}'::bigint[]))
  • Rows Removed by Filter: 178
16. 0.000 1,307.670 ↑ 6.6 416 7

Materialize (cost=1,000.00..464,465.10 rows=2,744 width=224) (actual time=180.882..186.810 rows=416 loops=7)

17. 25.165 1,328.281 ↑ 6.6 416 1

Gather (cost=1,000.00..464,451.38 rows=2,744 width=224) (actual time=1,266.164..1,328.281 rows=416 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
18. 1,303.116 1,303.116 ↑ 8.2 139 3 / 3

Parallel Seq Scan on onderzoek this_ (cost=0.00..463,176.98 rows=1,143 width=224) (actual time=1,261.075..1,303.116 rows=139 loops=3)

  • Filter: (is_doorgevoerd AND ((status)::text = 'ONDERBROKEN'::text))
  • Rows Removed by Filter: 7,837,701
19. 0.092 0.092 ↑ 1.0 1 23

Index Scan using uk_6257saqij0lyo0j8hl1mht33n on afspraak afspraak4_ (cost=0.56..8.52 rows=1 width=144) (actual time=0.004..0.004 rows=1 loops=23)

  • Index Cond: (onderzoek = this_.id)
20. 2.850 2.850 ↑ 1.1 8,946 1

Index Scan using org_organisatie_pkey on org_organisatie ce3_ (cost=0.29..1,045.33 rows=9,548 width=2,088) (actual time=0.011..2.850 rows=8,946 loops=1)

21. 0.092 0.092 ↓ 0.0 0 23

Index Scan using uk_qcjvqmh0amxm2yrll8vg004vx on uitnodiging uitnodigin5_ (cost=0.56..0.63 rows=1 width=63) (actual time=0.004..0.004 rows=0 loops=23)

  • Index Cond: (laatste_afspraak = afspraak4_.id)
  • Filter: (afspraak4_.uitnodiging = id)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using mammografie_pkey on mammografie mammografi10_ (cost=0.44..8.35 rows=1 width=51) (never executed)

  • Index Cond: (id = this_.mammografie)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using uk_rr5qvofjbl0debxhwhs5fqr9x on screening_ronde ronde6_ (cost=0.56..0.66 rows=1 width=211) (never executed)

  • Index Cond: (laatste_uitnodiging = afspraak4_.uitnodiging)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using dossier_pkey on dossier dossier7_ (cost=0.43..0.47 rows=1 width=124) (never executed)

  • Index Cond: (id = ronde6_.dossier)
25. 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)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using pat_persoon_patientid on pat_persoon persoon9_ (cost=0.43..0.58 rows=1 width=3,111) (never executed)

  • Index Cond: (patient = client8_.id)
  • Filter: ((overlijdensdatum IS NULL) AND (datum_vertrokken_uit_nederland IS NULL))
Planning time : 9.214 ms
Execution time : 1,342.035 ms