explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bqLf

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=162,788.55..162,789.72 rows=10 width=89) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=162,786.22..162,800.22 rows=120 width=89) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=161,786.20..161,786.35 rows=60 width=89) (actual rows= loops=)

  • Sort Key: d7_.datedernieredemande DESC, p0_.nom, p0_.prenom, c3_.codepostal, a2_.libelle, l1_.idinterne
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=124,280.39..161,784.42 rows=60 width=89) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=124,279.96..161,753.37 rows=60 width=79) (actual rows= loops=)

  • Hash Cond: (l1_.idinterne = d7_.idlogement)
6. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=45,172.35..78,823.28 rows=60 width=71) (actual rows= loops=)

  • Hash Cond: (l1_.idadresse = a2_.id)
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on logement l1_ (cost=0.00..30,930.42 rows=725,405 width=48) (actual rows= loops=)

  • Filter: (idcopropriete IS NULL)
8. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=45,170.75..45,170.75 rows=128 width=27) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash Join (cost=735.71..45,170.75 rows=128 width=27) (actual rows= loops=)

  • Hash Cond: (a2_.idccp = c3_.id)
10. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on adresse a2_ (cost=0.00..40,370.90 rows=1,548,090 width=13) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=735.67..735.67 rows=3 width=22) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on communecp c3_ (cost=0.00..735.67 rows=3 width=22) (actual rows= loops=)

  • Filter: ((codepostal)::text ~~ '75%'::text)
13. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=65,510.05..65,510.05 rows=782,205 width=12) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dossier d7_ (cost=0.00..65,510.05 rows=782,205 width=12) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Scan using particulier_pkey on particulier p0_ (cost=0.43..0.52 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (idinterne = d7_.idparticulier)