explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lrK7

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=183,401.61..183,808.35 rows=162,696 width=102) (actual rows= loops=)

  • Sort Key: l.codepr, (CASE WHEN l.avec_taille THEN l.taillepr ELSE '0'::character varying END)
2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=127,381.22..158,791.33 rows=162,696 width=102) (actual rows= loops=)

  • Group Key: l.codepr, l.nompr, l.avec_taille, (CASE WHEN ((l.codfamille)::text = 'COMPOSANTS'::text) THEN 1 WHEN ((l.famille_base)::text = 'COMPOSANTS'::text) THEN 1 WHEN (substr((l.codepr)::text, 1, 1) = '*'::text) THEN 1 ELSE 0 END), (CASE WHEN l. (...)
3. 0.000 0.000 ↓ 0.0

Sort (cost=127,381.22..128,185.68 rows=321,785 width=73) (actual rows= loops=)

  • Sort Key: l.codepr, l.nompr, l.avec_taille, (CASE WHEN ((l.codfamille)::text = 'COMPOSANTS'::text) THEN 1 WHEN ((l.famille_base)::text = 'COMPOSANTS'::text) THEN 1 WHEN (substr((l.codepr)::text, 1, 1) = '*'::text) THEN 1 ELSE 0 END), (CASE WH (...)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=7,700.40..83,643.75 rows=321,785 width=73) (actual rows= loops=)

  • Hash Cond: (l.id_comannde = c.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on linecde l (cost=0.00..66,464.44 rows=811,523 width=50) (actual rows= loops=)

  • Filter: ((codfamille)::text <> 'REMA/RQUE'::text)
6. 0.000 0.000 ↓ 0.0

Hash (cost=7,104.00..7,104.00 rows=47,712 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using idx_cmdeadet_bechir on commande c (cost=0.42..7,104.00 rows=47,712 width=8) (actual rows= loops=)

  • Index Cond: ((datecde >= '2019-01-01'::date) AND (datecde <= '2019-12-31'::date))