explain.depesz.com

PostgreSQL's explain analyze made readable

Result: weavn

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 26,013.760 ↑ 1.0 1 1

Sort (cost=3,364,662.96..3,364,662.97 rows=1 width=7,956) (actual time=26,013.759..26,013.760 rows=1 loops=1)

  • Sort Key: persoon1_.achternaam
  • Sort Method: quicksort Memory: 26kB
2. 0.004 26,013.743 ↑ 1.0 1 1

Nested Loop Left Join (cost=637,035.27..3,364,662.95 rows=1 width=7,956) (actual time=26,013.721..26,013.743 rows=1 loops=1)

3. 0.004 26,013.729 ↑ 1.0 1 1

Nested Loop (cost=637,034.83..3,364,662.14 rows=1 width=6,774) (actual time=26,013.707..26,013.729 rows=1 loops=1)

4. 0.005 26,013.711 ↓ 2.0 2 1

Nested Loop Left Join (cost=637,034.40..3,364,661.63 rows=1 width=6,655) (actual time=26,013.691..26,013.711 rows=2 loops=1)

5. 0.000 26,013.686 ↓ 2.0 2 1

Nested Loop (cost=637,033.96..3,364,661.09 rows=1 width=6,627) (actual time=26,013.673..26,013.686 rows=2 loops=1)

6. 114.257 26,109.919 ↓ 2.0 2 1

Gather (cost=637,033.53..3,364,660.56 rows=1 width=5,455) (actual time=26,013.652..26,109.919 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 1,570.505 25,995.662 ↑ 1.0 1 3

Merge Left Join (cost=636,033.53..3,363,660.46 rows=1 width=5,455) (actual time=23,516.199..25,995.662 rows=1 loops=3)

  • Merge Cond: (persoon1_.tijdelijk_gba_adres = tijdelijkg3_.id)
  • Filter: ((((gbaadres2_.postcode)::text = '2172DB'::text) OR ((tijdelijkg3_.postcode)::text = '2172DB'::text)) AND (((gbaadres2_.huisletter IS NULL) AND (gbaadres2_.huisnummer_toevoeging IS NULL) AND ((gbaadres2_.postcode)::text = '2172DB'::text) AND (gbaadres2_.huisnummer = 2)) OR ((tijdelijkg3_.huisletter IS NULL) AND (tijdelijkg3_.huisnummer_toevoeging IS NULL) AND ((tijdelijkg3_.postcode)::text = '2172DB'::text) AND (tijdelijkg3_.huisnummer = 2))))
  • Rows Removed by Filter: 2999900
8. 11,583.514 14,777.279 ↑ 1.3 2,999,901 3

Nested Loop (cost=0.87..2,655,609.13 rows=3,762,922 width=4,130) (actual time=0.168..14,777.279 rows=2,999,901 loops=3)

9. 3,193.762 3,193.762 ↑ 1.3 2,999,901 3

Parallel Index Scan using idx_94231601163b34d9 on pat_persoon persoon1_ (cost=0.43..508,356.94 rows=3,762,922 width=2,711) (actual time=0.072..3,193.762 rows=2,999,901 loops=3)

  • Filter: ((overlijdensdatum IS NULL) AND (datum_vertrokken_uit_nederland IS NULL))
  • Rows Removed by Filter: 536213
10. 0.003 0.003 ↑ 1.0 1 8,999,703

Index Scan using org_adres_pkey on org_adres gbaadres2_ (cost=0.43..0.57 rows=1 width=1,419) (actual time=0.003..0.003 rows=1 loops=8,999,703)

  • Index Cond: (id = persoon1_.gba_adres)
11. 9,647.878 9,647.878 ↑ 1.1 10,358,395 3

Index Scan using org_adres_pkey on org_adres tijdelijkg3_ (cost=0.43..671,387.79 rows=10,898,731 width=1,325) (actual time=0.047..9,647.878 rows=10,358,395 loops=3)

12. 0.026 0.026 ↑ 1.0 1 2

Index Scan using pat_patient_pkey on pat_patient this_ (cost=0.43..0.53 rows=1 width=1,172) (actual time=0.013..0.013 rows=1 loops=2)

  • Index Cond: (id = persoon1_.patient)
  • Filter: (((dtype)::text = 'Client'::text) AND ((gba_status)::text = 'INDICATIE_AANWEZIG'::text))
13. 0.020 0.020 ↑ 1.0 1 2

Index Scan using gba_mutatie_pkey on gba_mutatie laatstegba6_ (cost=0.44..0.54 rows=1 width=28) (actual time=0.010..0.010 rows=1 loops=2)

  • Index Cond: (this_.laatste_gba_mutatie = id)
14. 0.014 0.014 ↓ 0.0 0 2

Index Scan using dossier_pkey on dossier mammadossi4_ (cost=0.43..0.51 rows=1 width=119) (actual time=0.007..0.007 rows=0 loops=2)

  • Index Cond: (id = this_.mamma_dossier)
15. 0.010 0.010 ↑ 1.0 1 1

Index Scan using screening_ronde_pkey on screening_ronde laatstescr5_ (cost=0.44..0.81 rows=1 width=1,182) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (mammadossi4_.laatste_screening_ronde = id)