explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NCLM

Settings
# exclusive inclusive rows x rows loops node
1. 20.805 160.573 ↓ 16.4 558 1

Nested Loop (cost=1.28..105,550.15 rows=34 width=1,242) (actual time=0.068..160.573 rows=558 loops=1)

2. 15.042 78.642 ↓ 15.6 30,563 1

Nested Loop (cost=0.85..102,062.48 rows=1,961 width=1,031) (actual time=0.052..78.642 rows=30,563 loops=1)

3. 0.024 0.024 ↑ 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.023..0.024 rows=1 loops=1)

  • Index Cond: ((code)::text = 'C06U'::text)
4. 63.576 63.576 ↓ 3.3 30,563 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.023..63.576 rows=30,563 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: 4078
5. 61.126 61.126 ↓ 0.0 0 30,563

Index Scan using bon_livraison_pkey on bon_livraison bonlivrais1_ (cost=0.43..1.78 rows=1 width=211) (actual time=0.002..0.002 rows=0 loops=30,563)

  • 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
Planning time : 0.868 ms
Execution time : 160.717 ms