explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xKE8

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

Delete on declinaison_article (cost=1.11..83,258.20 rows=1 width=18) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=1.11..83,258.20 rows=1 width=18) (actual rows= loops=)

  • Join Filter: (declinaison_article.elg_num_elt_gestion_elg = da.elg_num_elt_gestion_elg)
3. 0.000 0.000 ↓ 0.0

Index Scan using idx_vag on declinaison_article (cost=0.56..2.77 rows=1 width=27) (actual rows= loops=)

  • Index Cond: (((vag_val_grille_vag)::text = '9 MN'::text) AND (tgr_num_type_grille_vag = '519'::bigint))
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..83,255.41 rows=1 width=41) (actual rows= loops=)

  • Join Filter: (fs.elg_num_elt_gestion_elg = da.elg_num_elt_gestion_elg)
5. 0.000 0.000 ↓ 0.0

Index Scan using idx_vag on declinaison_article da (cost=0.56..2.77 rows=1 width=27) (actual rows= loops=)

  • Index Cond: (((vag_val_grille_vag)::text = '9 MN'::text) AND (tgr_num_type_grille_vag = '519'::bigint))
6. 0.000 0.000 ↓ 0.0

Seq Scan on flat_structure fs (cost=0.00..83,252.46 rows=14 width=14) (actual rows= loops=)

  • Filter: ((fst_modele_r3)::text = '8041532'::text)