1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
"Hash Join (cost=1.79..2.98 rows=1 width=73)"
" Output: a.societe, a.devise, a.client, a.datefacture, devise.societe, devise.devise, devise.datedebuttaux, devise.tauxchange, (COALESCE(lead((devise.datedebuttaux - 1)) OVER (?), to_date('29999-01-01'::text, 'yyyy-mm-dd'::text)))"
" Hash Cond: ((a.societe = devise.societe) AND (a.devise = devise.devise))"
" Join Filter: ((a.datefacture >= devise.datedebuttaux) AND (a.datefacture <= (COALESCE(lead((devise.datedebuttaux - 1)) OVER (?), to_date('29999-01-01'::text, 'yyyy-mm-dd'::text)))))"
" -> Seq Scan on public.facturation a (cost=0.00..1.10 rows=10 width=37)"
" Output: a.societe, a.devise, a.client, a.datefacture"
" -> Hash (cost=1.64..1.64 rows=10 width=36)"
" Output: devise.societe, devise.devise, devise.datedebuttaux, devise.tauxchange, (COALESCE(lead((devise.datedebuttaux - 1)) OVER (?), to_date('29999-01-01'::text, 'yyyy-mm-dd'::text)))"
" -> WindowAgg (cost=1.27..1.54 rows=10 width=32)"
" Output: devise.societe, devise.devise, devise.datedebuttaux, devise.tauxchange, COALESCE(lead((devise.datedebuttaux - 1)) OVER (?), to_date('29999-01-01'::text, 'yyyy-mm-dd'::text))"
" -> Sort (cost=1.27..1.29 rows=10 width=32)"
" Output: devise.societe, devise.devise, devise.datedebuttaux, devise.tauxchange"
" Sort Key: devise.societe, devise.devise, devise.datedebuttaux"
" -> Seq Scan on public.devise (cost=0.00..1.10 rows=10 width=32)"
" Output: devise.societe, devise.devise, devise.datedebuttaux, devise.tauxchange" |
Partager