explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AwmR

Settings
# exclusive inclusive rows x rows loops node
1. 4.591 26.198 ↑ 1.0 1,430 1

GroupAggregate (cost=1,325.29..1,361.06 rows=1,431 width=56) (actual time=21.395..26.198 rows=1,430 loops=1)

  • Group Key: personne.id, civilite.abreviation
2. 0.878 21.607 ↓ 1.0 1,434 1

Sort (cost=1,325.29..1,328.87 rows=1,431 width=41) (actual time=21.343..21.607 rows=1,434 loops=1)

  • Sort Key: personne.id, civilite.abreviation
  • Sort Method: quicksort Memory: 165kB
3. 0.417 20.729 ↓ 1.0 1,434 1

Hash Left Join (cost=975.91..1,250.28 rows=1,431 width=41) (actual time=17.053..20.729 rows=1,434 loops=1)

  • Hash Cond: (trv_civilite.id = civilite.idvaleur)
4. 0.373 18.022 ↓ 1.0 1,434 1

Hash Left Join (cost=884.38..1,133.70 rows=1,431 width=40) (actual time=14.746..18.022 rows=1,434 loops=1)

  • Hash Cond: (categorie.idcategorie = trv_categorie.id)
5. 0.384 16.486 ↓ 1.0 1,434 1

Hash Left Join (cost=837.98..1,067.63 rows=1,431 width=27) (actual time=13.564..16.486 rows=1,434 loops=1)

  • Hash Cond: (personne.idcivilite = trv_civilite.id)
6. 1.867 15.006 ↓ 1.0 1,434 1

Hash Right Join (cost=791.58..1,001.55 rows=1,431 width=27) (actual time=12.445..15.006 rows=1,434 loops=1)

  • Hash Cond: (categorie.idpersonne = personne.id)
7. 0.873 0.873 ↑ 1.0 9,794 1

Seq Scan on ref_pers_categorie categorie (cost=0.00..158.94 rows=9,794 width=8) (actual time=0.026..0.873 rows=9,794 loops=1)

8. 1.172 12.266 ↑ 1.0 1,430 1

Hash (cost=773.70..773.70 rows=1,430 width=23) (actual time=12.266..12.266 rows=1,430 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 97kB
9. 5.448 11.094 ↑ 1.0 1,430 1

Hash Join (cost=66.08..773.70 rows=1,430 width=23) (actual time=2.020..11.094 rows=1,430 loops=1)

  • Hash Cond: (personne.id = attribs.idpersonne)
10. 3.676 3.676 ↑ 1.0 9,790 1

Seq Scan on ref_personne personne (cost=0.00..619.90 rows=9,790 width=23) (actual time=0.030..3.676 rows=9,790 loops=1)

11. 0.681 1.970 ↑ 1.0 1,430 1

Hash (cost=48.20..48.20 rows=1,430 width=4) (actual time=1.970..1.970 rows=1,430 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 67kB
12. 1.289 1.289 ↑ 1.0 1,430 1

Seq Scan on ref_pers_attributions attribs (cost=0.00..48.20 rows=1,430 width=4) (actual time=0.016..1.289 rows=1,430 loops=1)

  • Filter: (idattribution = 204)
  • Rows Removed by Filter: 1146
13. 0.490 1.096 ↑ 1.0 1,440 1

Hash (cost=28.40..28.40 rows=1,440 width=4) (actual time=1.096..1.096 rows=1,440 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 67kB
14. 0.606 0.606 ↑ 1.0 1,440 1

Seq Scan on trv_valeur trv_civilite (cost=0.00..28.40 rows=1,440 width=4) (actual time=0.013..0.606 rows=1,440 loops=1)

15. 0.625 1.163 ↑ 1.0 1,440 1

Hash (cost=28.40..28.40 rows=1,440 width=21) (actual time=1.163..1.163 rows=1,440 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 77kB
16. 0.538 0.538 ↑ 1.0 1,440 1

Seq Scan on trv_valeur trv_categorie (cost=0.00..28.40 rows=1,440 width=21) (actual time=0.078..0.538 rows=1,440 loops=1)

17. 0.727 2.290 ↑ 1.0 1,440 1

Hash (cost=73.54..73.54 rows=1,440 width=9) (actual time=2.290..2.290 rows=1,440 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 79kB
18. 1.563 1.563 ↑ 1.0 1,440 1

Seq Scan on trv_valeur_trad civilite (cost=0.00..73.54 rows=1,440 width=9) (actual time=0.060..1.563 rows=1,440 loops=1)

  • Filter: (idlangue = 1)
  • Rows Removed by Filter: 2283
Planning time : 3.039 ms
Execution time : 26.493 ms