explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6CEY

Settings
# exclusive inclusive rows x rows loops node
1. 15.819 16,392.296 ↓ 16.4 558 1

Nested Loop (cost=1.28..105,519.06 rows=34 width=1,242) (actual time=0.123..16,392.296 rows=558 loops=1)

2. 25.506 15,306.772 ↓ 15.6 30,563 1

Nested Loop (cost=0.85..102,036.42 rows=1,960 width=1,031) (actual time=0.100..15,306.772 rows=30,563 loops=1)

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

  • Index Cond: ((code)::text = 'C06U'::text)
4. 15,281.235 15,281.235 ↓ 3.3 30,563 1

Index Scan using ligne_bon_livraison_article_id_idx on ligne_bon_livraison lignebonli0_ (cost=0.57..101,934.50 rows=9,362 width=280) (actual time=0.062..15,281.235 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. 1,069.705 1,069.705 ↓ 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.035..0.035 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 : 1.244 ms
Execution time : 16,393.650 ms