explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D9nqO

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

Hash Join (cost=21,569.69..22,486.52 rows=2 width=124) (actual rows= loops=)

  • Hash Cond: (dg.code_commune = data.code_commune)
2. 0.000 0.000 ↓ 0.0

Seq Scan on dim_geographie dg (cost=0.00..785.67 rows=34,967 width=14) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=21,569.67..21,569.67 rows=2 width=67) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=21,543.11..21,569.67 rows=2 width=67) (actual rows= loops=)

  • Hash Cond: (dz.zonage_libelle = data.zonage_avicca)
5. 0.000 0.000 ↓ 0.0

Seq Scan on dim_zonage dz (cost=0.00..22.00 rows=1,200 width=40) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=21,543.10..21,543.10 rows=1 width=66) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Gather (cost=21,517.02..21,543.10 rows=1 width=66) (actual rows= loops=)

  • Workers Planned: 2
8. 0.000 0.000 ↓ 0.0

Merge Join (cost=20,517.02..20,543.00 rows=1 width=66) (actual rows= loops=)

  • Merge Cond: ((data.acteur_avicca = di.acteur_rip) AND (data.prestataire_avicca = di.prestataire_rip) AND (data.operateur_zipri_avicca = di.operateur_zipri))
9. 0.000 0.000 ↓ 0.0

Sort (cost=20,472.70..20,477.66 rows=1,987 width=71) (actual rows= loops=)

  • Sort Key: data.acteur_avicca, data.prestataire_avicca, data.operateur_zipri_avicca
10. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.67..20,363.84 rows=1,987 width=71) (actual rows= loops=)

  • Hash Cond: ((data.annee = dt.annee) AND (data.trimestre = dt.trimestre_numero) AND (CASE WHEN (data.trimestre = 1) THEN 1 WHEN (data.trimestre = 2) THEN 4 WHEN (data.trimestre = 3) THEN 7 WHEN (data.trimestre = 4) THEN 10 ELSE NULL::integer END = dt.mois_numero))
11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on donnees_avicca data (cost=0.00..8,904.85 rows=132,585 width=71) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=1.97..1.97 rows=97 width=20) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on dim_temps dt (cost=0.00..1.97 rows=97 width=20) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Sort (cost=44.32..45.85 rows=610 width=104) (actual rows= loops=)

  • Sort Key: di.acteur_rip, di.prestataire_rip, di.operateur_zipri
15. 0.000 0.000 ↓ 0.0

Seq Scan on dim_intervenant di (cost=0.00..16.10 rows=610 width=104) (actual rows= loops=)