explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vgy5 : FAST

Settings
# exclusive inclusive rows x rows loops node
1. 4.511 264.749 ↑ 1.0 1 1

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

2. 48.428 260.238 ↓ 3,239.1 22,674 1

Nested Loop (cost=1.12..55.60 rows=7 width=4) (actual time=0.030..260.238 rows=22,674 loops=1)

3. 46.928 189.136 ↓ 3,239.1 22,674 1

Nested Loop (cost=0.97..54.00 rows=7 width=37) (actual time=0.024..189.136 rows=22,674 loops=1)

4. 41.029 119.534 ↓ 3,239.1 22,674 1

Nested Loop (cost=0.83..52.83 rows=7 width=37) (actual time=0.020..119.534 rows=22,674 loops=1)

5. 7.018 7.018 ↓ 1,588.6 23,829 1

Index Scan using x_dm5_caracteristiquearticlestock_00 on dm5_caracteristiquearticlestock caracteris1_ (cost=0.42..16.12 rows=15 width=33) (actual time=0.012..7.018 rows=23,829 loops=1)

  • Index Cond: ((id_article)::text = ($1)::text)
6. 71.487 71.487 ↑ 1.0 1 23,829

Index Scan using x_dm5_quantitestock_00 on dm5_quantitestock quantitest0_ (cost=0.42..2.44 rows=1 width=70) (actual time=0.002..0.003 rows=1 loops=23,829)

  • Index Cond: ((id_caracteristiquearticlestock)::text = (caracteris1_.id)::text)
  • Filter: ((datefinvalidite IS NULL) AND (quantite_valeur <> '0'::numeric))
  • Rows Removed by Filter: 0
7. 22.674 22.674 ↑ 1.0 1 22,674

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

  • Index Cond: ((id)::text = (quantitest0_.id_caracteristiquelieustock)::text)
8. 22.674 22.674 ↑ 1.0 1 22,674

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

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