explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0wxS

Settings
# exclusive inclusive rows x rows loops node
1. 39.601 19,427.394 ↓ 41.3 1,403 1

Nested Loop (cost=1.28..105,550.15 rows=34 width=1,242) (actual time=0.469..19,427.394 rows=1,403 loops=1)

  • Buffers: shared hit=191941 read=39067 dirtied=474
2. 40.212 18,429.479 ↓ 23.3 45,634 1

Nested Loop (cost=0.85..102,062.48 rows=1,961 width=1,031) (actual time=0.442..18,429.479 rows=45,634 loops=1)

  • Buffers: shared hit=12795 read=35362 dirtied=464
3. 0.049 0.049 ↑ 1.0 1 1

Index Scan using uk_article_code on article article2_ (cost=0.29..8.30 rows=1 width=751) (actual time=0.047..0.049 rows=1 loops=1)

  • Index Cond: ((code)::text = 'C06T'::text)
  • Buffers: shared hit=3
4. 18,389.218 18,389.218 ↓ 4.9 45,634 1

Index Scan using ligne_bon_livraison_article_id_idx on ligne_bon_livraison lignebonli0_ (cost=0.57..101,960.53 rows=9,364 width=280) (actual time=0.386..18,389.218 rows=45,634 loops=1)

  • Index Cond: (article_id = article2_.id)
  • Filter: ((code_fournisseur IS NOT NULL) OR ((code_fournisseur IS NULL) AND (lower((fournisseur)::text) ~~ 'l''atelier du fromage'::text)))
  • Rows Removed by Filter: 4346
  • Buffers: shared hit=12792 read=35362 dirtied=464
5. 958.314 958.314 ↓ 0.0 0 45,634

Index Scan using bon_livraison_pkey on bon_livraison bonlivrais1_ (cost=0.43..1.78 rows=1 width=211) (actual time=0.021..0.021 rows=0 loops=45,634)

  • Index Cond: (id = lignebonli0_.bon_livraison_id)
  • Filter: ((date_livraison >= '2020-01-20'::date) AND ((type)::text = ANY ('{FACTURATION_MAGASIN_STANDARD,FACTURATION_MAGASIN_ASP,REGULARISATION_FACTURE,REGULARISATION_FACTURE_ASP}'::text[])))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=179146 read=3705 dirtied=10
Planning time : 1.530 ms
Execution time : 19,427.757 ms