explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HM9r

Settings
# exclusive inclusive rows x rows loops node
1. 0.177 872,575.038 ↓ 10.0 10 1

Limit (cost=155,925.88..155,925.88 rows=1 width=16) (actual time=872,574.856..872,575.038 rows=10 loops=1)

2. 4.671 872,574.861 ↓ 10.0 10 1

Sort (cost=155,925.88..155,925.88 rows=1 width=16) (actual time=872,574.853..872,574.861 rows=10 loops=1)

  • Sort Key: this_.creatie_datum
  • Sort Method: top-N heapsort Memory: 25kB
3. 13.755 872,570.190 ↓ 6,056.0 6,056 1

Nested Loop (cost=1,015.96..155,925.87 rows=1 width=16) (actual time=45,323.562..872,570.190 rows=6,056 loops=1)

4. 16.669 872,526.155 ↓ 6,056.0 6,056 1

Nested Loop (cost=1,015.53..155,925.32 rows=1 width=24) (actual time=45,323.547..872,526.155 rows=6,056 loops=1)

5. 13.847 872,479.206 ↓ 6,056.0 6,056 1

Nested Loop (cost=1,015.09..155,924.74 rows=1 width=24) (actual time=45,323.531..872,479.206 rows=6,056 loops=1)

6. 15.972 872,429.023 ↓ 6,056.0 6,056 1

Nested Loop (cost=1,014.66..155,924.25 rows=1 width=32) (actual time=45,323.515..872,429.023 rows=6,056 loops=1)

7. 115.677 872,297.721 ↓ 6,070.0 6,070 1

Nested Loop (cost=1,014.23..155,341.61 rows=1 width=32) (actual time=45,323.442..872,297.721 rows=6,070 loops=1)

  • Join Filter: (uitnodigin5_.screening_ronde = ronde6_.id)
8. 148.416 871,767.824 ↓ 82,844.0 82,844 1

Nested Loop (cost=1,013.79..155,341.07 rows=1 width=40) (actual time=45,323.170..871,767.824 rows=82,844 loops=1)

9. 103.240 871,205.188 ↓ 3.3 82,844 1

Hash Join (cost=1,013.35..142,212.28 rows=25,096 width=32) (actual time=45,323.146..871,205.188 rows=82,844 loops=1)

  • Hash Cond: (this_.screenings_eenheid = se2_.id)
10. 103.725 871,101.699 ↓ 3.3 82,844 1

Merge Join (cost=1,004.28..142,135.78 rows=25,096 width=40) (actual time=45,322.887..871,101.699 rows=82,844 loops=1)

  • Merge Cond: (beoordelin11_.parent = centraleee12_.id)
11. 154.542 870,990.372 ↓ 3.3 82,844 1

Nested Loop (cost=1,002.29..2,521,933.94 rows=25,096 width=48) (actual time=45,310.287..870,990.372 rows=82,844 loops=1)

12. 447,793.226 870,338.766 ↓ 5.1 82,844 1

Nested Loop (cost=1,001.72..2,502,442.99 rows=16,256 width=40) (actual time=45,310.260..870,338.766 rows=82,844 loops=1)

  • Join Filter: (beoordelin1_.beoordelings_eenheid = beoordelin11_.id)
  • Rows Removed by Join Filter: 766141312
13. 69.718 69.718 ↑ 1.0 9,249 1

Index Scan using idx_d21c031ac4ab08aa on org_organisatie beoordelin11_ (cost=0.29..1,105.17 rows=9,249 width=16) (actual time=0.012..69.718 rows=9,249 loops=1)

14. 421,871.446 422,475.822 ↓ 5.1 82,844 9,249

Materialize (cost=1,001.44..246,102.29 rows=16,256 width=40) (actual time=0.001..45.678 rows=82,844 loops=9,249)

15. 0.000 604.376 ↓ 5.1 82,844 1

Gather (cost=1,001.44..246,021.01 rows=16,256 width=40) (actual time=0.952..604.376 rows=82,844 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
16. 280.295 663.393 ↓ 4.1 27,615 3

Nested Loop (cost=1.44..243,395.41 rows=6,773 width=40) (actual time=0.125..663.393 rows=27,615 loops=3)

17. 296.148 383.090 ↓ 4.1 27,615 3

Nested Loop (cost=1.00..238,724.59 rows=6,773 width=48) (actual time=0.082..383.090 rows=27,615 loops=3)

18. 86.933 86.933 ↑ 1.2 27,615 3

Parallel Index Scan using idx_mamma_beoordeling_status on beoordeling beoordelin1_ (cost=0.56..25,169.15 rows=32,614 width=24) (actual time=0.044..86.933 rows=27,615 loops=3)

  • Index Cond: ((status)::text = 'UITSLAG_ONGUNSTIG'::text)
  • Filter: (beoordelings_eenheid = ANY ('{363151622,363151620,363151618}'::bigint[]))
  • Rows Removed by Filter: 107718
19. 0.009 0.009 ↑ 1.0 1 82,844

Index Scan using uk_i514b8e20fu0de7ngbar2ksop on onderzoek this_ (cost=0.44..6.55 rows=1 width=40) (actual time=0.009..0.009 rows=1 loops=82,844)

  • Index Cond: (laatste_beoordeling = beoordelin1_.id)
  • Filter: (screenings_eenheid = ANY ('{363156742,363156725,363156733,363156734,363156749,363156747,363156740,363156754,363156756,363156752,363156729,363156757,363156737,363156743,363156739,363156727,363156753,363156789,363156735,363156755,363156732,363156726,363156746,363156724,363156731,363156730,363156744,363156736,363156751,363156728,363156738,363156741}'::bigint[]))
20. 0.008 0.008 ↑ 1.0 1 82,844

Index Only Scan using mammografie_pkey on mammografie mammografi3_ (cost=0.44..0.69 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=82,844)

  • Index Cond: (id = this_.mammografie)
  • Heap Fetches: 82844
21. 497.064 497.064 ↑ 1.0 1 82,844

Index Scan using uk_6257saqij0lyo0j8hl1mht33n on afspraak afspraak4_ (cost=0.56..1.20 rows=1 width=24) (actual time=0.006..0.006 rows=1 loops=82,844)

  • Index Cond: (onderzoek = this_.id)
22. 7.602 7.602 ↑ 1.0 8,946 1

Index Only Scan using org_organisatie_pkey on org_organisatie centraleee12_ (cost=0.29..963.05 rows=9,249 width=8) (actual time=0.019..7.602 rows=8,946 loops=1)

  • Heap Fetches: 8946
23. 0.112 0.249 ↑ 1.0 181 1

Hash (cost=6.81..6.81 rows=181 width=8) (actual time=0.248..0.249 rows=181 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
24. 0.137 0.137 ↑ 1.0 181 1

Seq Scan on screenings_eenheid se2_ (cost=0.00..6.81 rows=181 width=8) (actual time=0.008..0.137 rows=181 loops=1)

25. 414.220 414.220 ↑ 1.0 1 82,844

Index Scan using uitnodiging_pkey on uitnodiging uitnodigin5_ (cost=0.44..0.51 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=82,844)

  • Index Cond: (id = afspraak4_.uitnodiging)
  • Filter: (afspraak4_.id = laatste_afspraak)
26. 414.220 414.220 ↓ 0.0 0 82,844

Index Scan using uk_rr5qvofjbl0debxhwhs5fqr9x on screening_ronde ronde6_ (cost=0.44..0.53 rows=1 width=32) (actual time=0.005..0.005 rows=0 loops=82,844)

  • Index Cond: (laatste_uitnodiging = afspraak4_.uitnodiging)
  • Filter: (follow_up_conclusie_status IS NULL)
  • Rows Removed by Filter: 1
27. 42.490 115.330 ↑ 1.0 1 6,070

Index Only Scan using dossier_pkey on dossier dossier7_ (cost=0.43..582.63 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=6,070)

  • Index Cond: (id = ronde6_.dossier)
  • Filter: ((SubPlan 1) = 0)
  • Rows Removed by Filter: 0
  • Heap Fetches: 6070
28.          

SubPlan (for Index Only Scan)

29. 12.140 72.840 ↑ 1.0 1 6,070

Aggregate (cost=582.15..582.16 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=6,070)

30. 5.685 60.700 ↓ 0.0 0 6,070

Nested Loop (cost=1.44..582.07 rows=33 width=0) (actual time=0.010..0.010 rows=0 loops=6,070)

31. 5.575 54.630 ↓ 0.0 0 6,070

Nested Loop (cost=0.88..562.60 rows=27 width=8) (actual time=0.009..0.009 rows=0 loops=6,070)

32. 48.560 48.560 ↓ 0.0 0 6,070

Index Scan using idx_e9c7ada36de37ecb on screening_ronde r2_ (cost=0.44..334.04 rows=27 width=8) (actual time=0.008..0.008 rows=0 loops=6,070)

  • Index Cond: (dossier = dossier7_.id)
  • Filter: (creatie_datum > ronde6_.creatie_datum)
  • Rows Removed by Filter: 5
33. 0.495 0.495 ↑ 1.0 1 55

Index Scan using idx_70765babf999889 on uitnodiging u1_ (cost=0.44..8.46 rows=1 width=16) (actual time=0.008..0.009 rows=1 loops=55)

  • Index Cond: (screening_ronde = r2_.id)
34. 0.385 0.385 ↓ 0.0 0 55

Index Only Scan using idx_20d39191b0d90981 on afspraak a_ (cost=0.56..0.70 rows=2 width=8) (actual time=0.007..0.007 rows=0 loops=55)

  • Index Cond: (uitnodiging = u1_.id)
  • Heap Fetches: 17
35. 36.336 36.336 ↑ 1.0 1 6,056

Index Scan using idx_c362607491fe939 on pat_patient client8_ (cost=0.43..0.48 rows=1 width=16) (actual time=0.005..0.006 rows=1 loops=6,056)

  • Index Cond: (mamma_dossier = ronde6_.dossier)
  • Filter: ((dtype)::text = 'Client'::text)
36. 30.280 30.280 ↑ 1.0 1 6,056

Index Scan using pat_persoon_patientid on pat_persoon persoon9_ (cost=0.43..0.58 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=6,056)

  • Index Cond: (patient = client8_.id)
37. 30.280 30.280 ↑ 1.0 1 6,056

Index Only Scan using org_adres_pkey on org_adres adres10_ (cost=0.43..0.55 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=6,056)

  • Index Cond: (id = persoon9_.gba_adres)
  • Heap Fetches: 6056
Planning time : 8.879 ms
Execution time : 872,576.452 ms