explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5ov8

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 179.552 ↑ 1.0 1 1

Limit (cost=6,246.28..6,246.29 rows=1 width=4) (actual time=179.551..179.552 rows=1 loops=1)

2. 8.507 179.548 ↑ 1.0 1 1

Aggregate (cost=6,246.28..6,246.29 rows=1 width=4) (actual time=179.548..179.548 rows=1 loops=1)

3. 32.127 171.041 ↓ 10.1 9,980 1

Nested Loop (cost=2.70..6,243.80 rows=991 width=4) (actual time=0.064..171.041 rows=9,980 loops=1)

4. 35.570 82.566 ↓ 4.5 14,087 1

Hash Join (cost=2.70..4,449.40 rows=3,150 width=37) (actual time=0.051..82.566 rows=14,087 loops=1)

  • Hash Cond: ((quantitest0_.id_caracteristiquelieustock)::text = (caracteris2_.id)::text)
5. 46.976 46.976 ↓ 1.0 41,245 1

Seq Scan on dm5_quantitestock quantitest0_ (cost=0.00..4,261.66 rows=40,944 width=70) (actual time=0.010..46.976 rows=41,245 loops=1)

  • Filter: (quantite_valeur <> 0::numeric)
  • Rows Removed by Filter: 59317
6. 0.005 0.020 ↑ 1.0 4 1

Hash (cost=2.65..2.65 rows=4 width=33) (actual time=0.020..0.020 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
7. 0.015 0.015 ↑ 1.0 4 1

Seq Scan on dm5_caracteristiquelieustock caracteris2_ (cost=0.00..2.65 rows=4 width=33) (actual time=0.005..0.015 rows=4 loops=1)

  • Filter: ((id_lieustockage)::text = '4028804c6004a54d016007729cba03ed'::text)
  • Rows Removed by Filter: 48
8. 56.348 56.348 ↑ 1.0 1 14,087

Index Scan using dm5_caracteristiquearticlestock_pkey on dm5_caracteristiquearticlestock caracteris1_ (cost=0.00..0.56 rows=1 width=33) (actual time=0.004..0.004 rows=1 loops=14,087)

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