explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EXKu

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

Sort (cost=691,668.57..691,668.57 rows=1 width=169) (actual rows= loops=)

  • Sort Key: a.code_depot, a.id_commande
2. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=1.12..691,668.56 rows=1 width=169) (actual rows= loops=)

  • Join Filter: (((b.code_editeur)::text = (a.code_editeur)::text) AND (b.date_parution = a.date_parution) AND ((b.code_depot)::text = (a.code_depot)::text) AND (b.id_destinataire = a.id_destinataire))
3. 0.000 0.000 ↓ 0.0

Index Scan using idx_commande_unique on commande a (cost=0.56..345,912.74 rows=1 width=169) (actual rows= loops=)

  • Index Cond: ((code_titre)::text = 'PO'::text)
  • Filter: (((code_editeur)::text = 'PO'::text) AND ((statut_commande)::text = 'TO_DELIVER'::text) AND (date_parution = '2020-01-25'::date) AND (date_part('dow'::text, (date_parution)::timestamp without time zone) = '6'::double precision))
4. 0.000 0.000 ↓ 0.0

Index Scan using idx_commande_unique on commande b (cost=0.56..345,755.71 rows=5 width=19) (actual rows= loops=)

  • Index Cond: ((code_titre)::text = 'TP'::text)" Filter: (((code_editeur)::text = 'PO'::text) AND (date_parution = '2020-01-25'::date) AND ((statut_commande)::text = 'TO_DELIVER'::text))