explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 49Ua

Settings
# exclusive inclusive rows x rows loops node
1. 5.235 7,520.422 ↑ 1.0 1 1

Aggregate (cost=80.31..80.32 rows=1 width=4) (actual time=7,520.422..7,520.422 rows=1 loops=1)

2. 92.987 7,515.187 ↓ 26,093.0 26,093 1

Nested Loop (cost=0.97..80.31 rows=1 width=4) (actual time=1,033.103..7,515.187 rows=26,093 loops=1)

  • Join Filter: ((caracteris2_.id_lieustockage)::text = (lieustocka3_.id)::text)
  • Rows Removed by Join Filter: 861069
3. 0.068 0.068 ↓ 34.0 34 1

Seq Scan on dm5_lieustockage lieustocka3_ (cost=0.00..1.44 rows=1 width=138) (actual time=0.011..0.068 rows=34 loops=1)

  • Filter: ((id_etablissement)::text = ($2)::text)
  • Rows Removed by Filter: 1
4. 1,871.224 7,422.132 ↓ 2,372.1 26,093 34

Nested Loop (cost=0.97..78.73 rows=11 width=37) (actual time=0.023..218.298 rows=26,093 loops=34)

5. 1,647.198 4,663.746 ↓ 2,372.1 26,093 34

Nested Loop (cost=0.83..76.89 rows=11 width=37) (actual time=0.020..137.169 rows=26,093 loops=34)

6. 264.996 264.996 ↓ 1,226.2 26,976 34

Index Scan using x_dm5_caracteristiquearticlestock_00 on dm5_caracteristiquearticlestock caracteris1_ (cost=0.42..23.04 rows=22 width=33) (actual time=0.012..7.794 rows=26,976 loops=34)

  • Index Cond: ((id_article)::text = ($1)::text)
7. 2,751.552 2,751.552 ↑ 1.0 1 917,184

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=917,184)

  • Index Cond: ((id_caracteristiquearticlestock)::text = (caracteris1_.id)::text)
  • Filter: ((datefinvalidite IS NULL) AND (quantite_valeur <> '0'::numeric))
  • Rows Removed by Filter: 0
8. 887.162 887.162 ↑ 1.0 1 887,162

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=887,162)

  • Index Cond: ((id)::text = (quantitest0_.id_caracteristiquelieustock)::text)