explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZpTG

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

Aggregate (cost=55.62..55.63 rows=1 width=4) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..55.60 rows=7 width=4) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.97..54.00 rows=7 width=37) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..52.83 rows=7 width=37) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using x_dm5_caracteristiquearticlestock_00 on dm5_caracteristiquearticlestock caracteris1_ (cost=0.42..16.12 rows=15 width=33) (actual rows= loops=)

  • Index Cond: ((id_article)::text = ($1)::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using x_dm5_quantitestock_00 on dm5_quantitestock quantitest0_ (cost=0.42..2.44 rows=1 width=70) (actual rows= loops=)

  • Index Cond: ((id_caracteristiquearticlestock)::text = (caracteris1_.id)::text)
  • Filter: ((datefinvalidite IS NULL) AND (quantite_valeur <> '0'::numeric))
7. 0.000 0.000 ↓ 0.0

Index Scan using dm5_caracteristiquelieustock_pkey on dm5_caracteristiquelieustock caracteris2_ (cost=0.14..0.16 rows=1 width=66) (actual rows= loops=)

  • Index Cond: ((id)::text = (quantitest0_.id_caracteristiquelieustock)::text)
8. 0.000 0.000 ↓ 0.0

Index Scan using dm5_lieustockage_pkey on dm5_lieustockage lieustocka3_ (cost=0.14..0.22 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((id)::text = (caracteris2_.id_lieustockage)::text)
  • Filter: ((id_etablissement)::text = ($2)::text)