explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u6lN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,356,789.956 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.29..18.70 rows=1 width=25) (actual time=1,356,789.956..1,356,789.956 rows=0 loops=1)

2. 184,074.397 1,356,789.956 ↓ 0.0 0 1

Nested Loop (cost=0.86..10.25 rows=1 width=12) (actual time=1,356,789.956..1,356,789.956 rows=0 loops=1)

  • Join Filter: ((tc.tarifachat_id <> t.tarifachat_id) AND (t.tarifachat_typetarif = tc.tarifachat_typetarif) AND (t.tarifachat_refachat_id = tc.tarifachat_refachat_id) AND (COALESCE(t.tarifachat_quantite, '-1'::double precision) = COALESCE(tc.tarifachat_quantite, '-1'::double precision)) AND (COALESCE(t.tarifachat_profiltarifachat_id, '-1'::integer) = COALESCE(tc.tarifachat_profiltarifachat_id, '-1'::integer)) AND (COALESCE(t.tarifachat_promoachat_id, '-1'::integer) = COALESCE(tc.tarifachat_promoachat_id, '-1'::integer)) AND (((tc.tarifachat_prixcalcule = 2) AND (t.tarifachat_prixcalcule = 2)) OR ((tc.tarifachat_prixcalcule = ANY ('{0,3}'::integer[])) AND (t.tarifachat_prixcalcule = ANY ('{0,3}'::integer[])))) AND (((tc.tarifachat_debut >= t.tarifachat_debut) AND (tc.tarifachat_debut <= t.tarifachat_fin)) OR ((tc.tarifachat_fin >= t.tarifachat_debut) AND (tc.tarifachat_fin <= t.tarifachat_fin)) OR ((t.tarifachat_debut >= tc.tarifachat_debut) AND (t.tarifachat_fin <= tc.tarifachat_fin))))
  • Rows Removed by Join Filter: 3499787281
3. 65.861 65.861 ↓ 59,159.0 59,159 1

Index Scan using tarifachat_dossier_id_sk on tarifachat t (cost=0.43..5.10 rows=1 width=56) (actual time=0.043..65.861 rows=59,159 loops=1)

  • Index Cond: (tarifachat_dossier_id = 189)
  • Filter: (tarifachat_etat = 0)
4. 1,172,649.698 1,172,649.698 ↓ 59,159.0 59,159 59,159

Index Scan using tarifachat_dossier_id_sk on tarifachat tc (cost=0.43..5.10 rows=1 width=52) (actual time=0.009..19.822 rows=59,159 loops=59,159)

  • Index Cond: (tarifachat_dossier_id = 189)
  • Filter: (tarifachat_etat = 0)
5. 0.000 0.000 ↓ 0.0 0

Index Scan using article_pk on article (cost=0.43..8.45 rows=1 width=17) (never executed)

  • Index Cond: (article_id = t.tarifachat_article_id)