explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bJw8 : onderbroken met status onderbroken

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

Limit (cost=1,172.98..1,172.98 rows=1 width=8,360) (actual time=0.942..0.942 rows=0 loops=1)

2. 0.006 0.940 ↓ 0.0 0 1

Sort (cost=1,172.98..1,172.98 rows=1 width=8,360) (actual time=0.940..0.940 rows=0 loops=1)

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

Nested Loop (cost=14.12..1,172.97 rows=1 width=8,360) (actual time=0.934..0.934 rows=0 loops=1)

4. 0.001 0.933 ↓ 0.0 0 1

Nested Loop (cost=13.68..1,172.39 rows=1 width=5,249) (actual time=0.933..0.933 rows=0 loops=1)

5. 0.000 0.932 ↓ 0.0 0 1

Nested Loop (cost=13.25..1,171.90 rows=1 width=4,077) (actual time=0.932..0.932 rows=0 loops=1)

6. 0.000 0.932 ↓ 0.0 0 1

Nested Loop (cost=12.82..1,171.43 rows=1 width=3,953) (actual time=0.932..0.932 rows=0 loops=1)

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

Nested Loop (cost=12.25..1,170.77 rows=1 width=3,742) (actual time=0.932..0.932 rows=0 loops=1)

8. 0.000 0.931 ↓ 0.0 0 1

Nested Loop (cost=11.97..1,170.34 rows=1 width=1,654) (actual time=0.931..0.931 rows=0 loops=1)

9. 0.001 0.931 ↓ 0.0 0 1

Nested Loop (cost=11.68..1,162.04 rows=1 width=645) (actual time=0.931..0.931 rows=0 loops=1)

10. 0.000 0.930 ↓ 0.0 0 1

Nested Loop (cost=11.25..1,153.69 rows=1 width=594) (actual time=0.930..0.930 rows=0 loops=1)

11. 0.027 0.843 ↑ 7.0 23 1

Nested Loop (cost=10.68..1,051.00 rows=160 width=531) (actual time=0.109..0.843 rows=23 loops=1)

12. 0.052 0.724 ↑ 4.5 23 1

Hash Join (cost=10.12..164.79 rows=104 width=387) (actual time=0.096..0.724 rows=23 loops=1)

  • Hash Cond: (this_.screenings_eenheid = se1_.id)
13. 0.625 0.625 ↑ 6.6 416 1

Index Scan using onderzoek_status_index on onderzoek this_ (cost=0.56..147.86 rows=2,743 width=224) (actual time=0.025..0.625 rows=416 loops=1)

  • Index Cond: ((status)::text = 'ONDERBROKEN'::text)
  • Filter: is_doorgevoerd
14. 0.007 0.047 ↑ 1.0 7 1

Hash (cost=9.47..9.47 rows=7 width=163) (actual time=0.046..0.047 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
15. 0.040 0.040 ↑ 1.0 7 1

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

  • Filter: (id = ANY ('{363156740,363156744,363156741,363156737,363156738,363156727,363156731}'::bigint[]))
  • Rows Removed by Filter: 178
16. 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)
17. 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)
18. 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)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using org_organisatie_pkey on org_organisatie be2_ (cost=0.29..8.30 rows=1 width=1,009) (never executed)

  • Index Cond: (id = se1_.beoordelings_eenheid)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using org_organisatie_pkey on org_organisatie ce3_ (cost=0.29..0.43 rows=1 width=2,088) (never executed)

  • Index Cond: (id = be2_.parent)
21. 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)
22. 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)
23. 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)
24. 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 : 7.579 ms
Execution time : 1.240 ms