explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XJFH

Settings
# exclusive inclusive rows x rows loops node
1. 4.344 227.319 ↑ 1.0 1 1

Aggregate (cost=712.95..712.96 rows=1 width=4) (actual time=227.318..227.319 rows=1 loops=1)

2. 93.823 222.975 ↓ 72.5 26,093 1

Nested Loop (cost=2.29..712.05 rows=360 width=4) (actual time=9.550..222.975 rows=26,093 loops=1)

3. 3.093 47.050 ↓ 35.4 41,051 1

Nested Loop (cost=1.87..120.30 rows=1,158 width=37) (actual time=0.089..47.050 rows=41,051 loops=1)

4. 0.055 0.097 ↓ 51.0 51 1

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

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

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

6. 0.006 0.014 ↓ 34.0 34 1

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

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

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

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

Index Scan using x_dm5_quantitestock_01 on dm5_quantitestock quantitest0_ (cost=0.42..107.33 rows=879 width=70) (actual time=0.062..0.860 rows=805 loops=51)

  • Index Cond: ((id_caracteristiquelieustock)::text = (caracteris2_.id)::text)
  • Filter: ((datefinvalidite IS NULL) AND (quantite_valeur <> '0'::numeric))
  • Rows Removed by Filter: 1138
9. 82.102 82.102 ↑ 1.0 1 41,051

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=41,051)

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