explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TCHg

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

Finalize Aggregate (cost=98,968.17..98,968.18 rows=1 width=64) (actual rows= loops=)

2.          

Initplan (for Finalize Aggregate)

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.22..3.18 rows=1 width=2) (actual rows= loops=)

  • Hash Cond: (val.idliste = lis.id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on spn_valeur val (cost=0.00..1.94 rows=5 width=10) (actual rows= loops=)

  • Filter: ((code)::text = 'CREE'::text)
5. 0.000 0.000 ↓ 0.0

Hash (cost=1.21..1.21 rows=1 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on spn_liste_valeurs lis (cost=0.00..1.21 rows=1 width=8) (actual rows= loops=)

  • Filter: ((code)::text = 'ETAT_VOL'::text)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..3.16 rows=1 width=2) (actual rows= loops=)

  • Join Filter: (val_1.idliste = lis_1.id)
8. 0.000 0.000 ↓ 0.0

Seq Scan on spn_valeur val_1 (cost=0.00..1.94 rows=1 width=10) (actual rows= loops=)

  • Filter: ((code)::text = 'CALCULE'::text)
9. 0.000 0.000 ↓ 0.0

Seq Scan on spn_liste_valeurs lis_1 (cost=0.00..1.21 rows=1 width=8) (actual rows= loops=)

  • Filter: ((code)::text = 'ETAT_CALCUL_VOL'::text)
10. 0.000 0.000 ↓ 0.0

Gather (cost=98,961.59..98,961.80 rows=2 width=64) (actual rows= loops=)

  • Workers Planned: 2
  • Params Evaluated: $0, $1
11. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=97,961.59..97,961.60 rows=1 width=64) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash Join (cost=127.03..96,923.32 rows=207,653 width=4) (actual rows= loops=)

  • Hash Cond: (arc.idcompagnie = com.id)
13. 0.000 0.000 ↓ 0.0

Hash Join (cost=124.71..96,254.62 rows=237,858 width=12) (actual rows= loops=)

  • Hash Cond: (fda.idarchive = arc.id)
14. 0.000 0.000 ↓ 0.0

Hash Join (cost=86.32..95,589.59 rows=237,858 width=8) (actual rows= loops=)

  • Hash Cond: (vol.idfichiercreat = fda.id)
15. 0.000 0.000 ↓ 0.0

Parallel Index Scan using spn_vol_idetatcalcul_idx on spn_vol vol (cost=0.43..94,878.23 rows=237,858 width=12) (actual rows= loops=)

  • Index Cond: (idetatcalcul = $1)
  • Filter: (idetat = $0)
16. 0.000 0.000 ↓ 0.0

Hash (cost=55.95..55.95 rows=2,395 width=12) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on spn_fichier_data fda (cost=0.00..55.95 rows=2,395 width=12) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash (cost=23.73..23.73 rows=1,173 width=12) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on spn_archive arc (cost=0.00..23.73 rows=1,173 width=12) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash (cost=1.63..1.63 rows=55 width=8) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on spn_compagnie com (cost=0.00..1.63 rows=55 width=8) (actual rows= loops=)