explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gXGf

Settings
# exclusive inclusive rows x rows loops node
1. 3.956 212.541 ↑ 1.0 1 1

Aggregate (cost=629.22..629.23 rows=1 width=4) (actual time=212.541..212.541 rows=1 loops=1)

2. 91.822 208.585 ↓ 70.0 22,674 1

Nested Loop (cost=2.29..628.41 rows=324 width=4) (actual time=10.691..208.585 rows=22,674 loops=1)

3. 2.930 44.285 ↓ 35.4 36,239 1

Nested Loop (cost=1.87..106.61 rows=1,023 width=37) (actual time=0.201..44.285 rows=36,239 loops=1)

4. 0.062 0.096 ↓ 51.0 51 1

Hash Join (cost=1.45..4.17 rows=1 width=33) (actual time=0.035..0.096 rows=51 loops=1)

  • Hash Cond: ((caracteris2_.id_lieustockage)::text = (lieustocka3_.id)::text)
5. 0.014 0.014 ↑ 1.0 52 1

Seq Scan on dm5_caracteristiquelieustock caracteris2_ (cost=0.00..2.52 rows=52 width=66) (actual time=0.002..0.014 rows=52 loops=1)

6. 0.008 0.020 ↓ 34.0 34 1

Hash (cost=1.44..1.44 rows=1 width=138) (actual time=0.020..0.020 rows=34 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
7. 0.012 0.012 ↓ 34.0 34 1

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

  • Filter: ((id_etablissement)::text = '1'::text)
  • Rows Removed by Filter: 1
8. 41.259 41.259 ↑ 1.1 711 51

Index Scan using x_dm5_quantitestock_01 on dm5_quantitestock quantitest0_ (cost=0.42..94.50 rows=793 width=70) (actual time=0.053..0.809 rows=711 loops=51)

  • Index Cond: ((id_caracteristiquelieustock)::text = (caracteris2_.id)::text)
  • Filter: ((datefinvalidite IS NULL) AND (quantite_valeur <> '0'::numeric))
  • Rows Removed by Filter: 963
9. 72.478 72.478 ↑ 1.0 1 36,239

Index Scan using dm5_caracteristiquearticlestock_pkey on dm5_caracteristiquearticlestock caracteris1_ (cost=0.42..0.50 rows=1 width=33) (actual time=0.002..0.002 rows=1 loops=36,239)

  • Index Cond: ((id)::text = (quantitest0_.id_caracteristiquearticlestock)::text)
  • Filter: ((id_article)::text = '4028804c60b8e3d40160bc1427195dcc'::text)
  • Rows Removed by Filter: 0