explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uvgB

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

Subquery Scan on vmessageem0_ (cost=5,310,033.51..5,319,794.56 rows=150,170 width=572) (actual rows= loops=)

  • Output: vmessageem0_.meser_cdn, vmessageem0_.meser_origine_lb, vmessageem0_.meser_status_lb, vmessageem0_.meser_declaration_dt, vmessageem0_.meser_typers_lb, vmessageem0_.meser_tymes_lb, vmessageem0_.meser_cfr_rfa, vmessageem0_.meser_marqext_lb, vmessageem0_.meser_creation_dt, vmessageem0_.meser_domaine_lb, vmessageem0_.meser_emet_lb, vmessageem0_.meser_dest_lb, vmessageem0_.meser_file_name_lb, vmessageem0_.meser_on_lb, vmessageem0_.meser_uuid_lb, vmessageem0_.meser_tripid_lb, vmessageem0_.meser_salesid_lb, vmessageem0_.meser_xml_contenu_txt, vmessageem0_.meser_ack_cdn, vmessageem0_.meser_version_ers_lb, vmessageem0_.meser_ret_cdn
2. 0.000 0.000 ↓ 0.0

Unique (cost=5,310,033.51..5,318,292.86 rows=150,170 width=274) (actual rows= loops=)

  • Output: ('ERS3'::text), (concat('xmlf_'::text, t_xml_file_ers3_log.xmlf_cdn)), (CASE WHEN (t_xml_file_ers3_log.ret_cdn IS NULL) THEN 'MANQ'::text WHEN ((t_ret.ret_rs_lb)::text ~~ '000'::text) THEN 'ACQT'::text WHEN ((t_ret.ret_rs_lb)::text <> '000'::text) THEN 'NACQT'::text ELSE NULL::text END), t_ret.ret_cdn, (NULL::integer), t_ops.ops_odot_dt, ("left"((t_xml_file_ers3_log.xmlf_on_lb)::text, 3)), t_xml_file_ers3_log.xmlf_type_message, (((xpath('//ers:ERS/ers:LOG/@IR'::text, t_xml_file_ers3_log.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text), (((xpath('//ers:ERS/ers:LOG/@XR'::text, t_xml_file_ers3_log.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text), t_xml_file_ers3_log.xmlf_creation_dt, ('FA'::text), t_ops.ops_fr_lb, t_ops.ops_ad_lb, t_ops.ops_version_ers_lb, t_xml_file_ers3_log.xmlf_file_name_lb, t_xml_file_ers3_log.xmlf_on_lb, (NULL::text), (NULL::text), (NULL::text), t_xml_file_ers3_log.xmlf_contenu_txt
3. 0.000 0.000 ↓ 0.0

Sort (cost=5,310,033.51..5,310,408.94 rows=150,170 width=274) (actual rows= loops=)

  • Output: ('ERS3'::text), (concat('xmlf_'::text, t_xml_file_ers3_log.xmlf_cdn)), (CASE WHEN (t_xml_file_ers3_log.ret_cdn IS NULL) THEN 'MANQ'::text WHEN ((t_ret.ret_rs_lb)::text ~~ '000'::text) THEN 'ACQT'::text WHEN ((t_ret.ret_rs_lb)::text <> '000'::text) THEN 'NACQT'::text ELSE NULL::text END), t_ret.ret_cdn, (NULL::integer), t_ops.ops_odot_dt, ("left"((t_xml_file_ers3_log.xmlf_on_lb)::text, 3)), t_xml_file_ers3_log.xmlf_type_message, (((xpath('//ers:ERS/ers:LOG/@IR'::text, t_xml_file_ers3_log.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text), (((xpath('//ers:ERS/ers:LOG/@XR'::text, t_xml_file_ers3_log.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text), t_xml_file_ers3_log.xmlf_creation_dt, ('FA'::text), t_ops.ops_fr_lb, t_ops.ops_ad_lb, t_ops.ops_version_ers_lb, t_xml_file_ers3_log.xmlf_file_name_lb, t_xml_file_ers3_log.xmlf_on_lb, (NULL::text), (NULL::text), (NULL::text), t_xml_file_ers3_log.xmlf_contenu_txt
  • Sort Key: ('ERS3'::text), (concat('xmlf_'::text, t_xml_file_ers3_log.xmlf_cdn)), (CASE WHEN (t_xml_file_ers3_log.ret_cdn IS NULL) THEN 'MANQ'::text WHEN ((t_ret.ret_rs_lb)::text ~~ '000'::text) THEN 'ACQT'::text WHEN ((t_ret.ret_rs_lb)::text <> '000'::text) THEN 'NACQT'::text ELSE NULL::text END), t_ret.ret_cdn, (NULL::integer), t_ops.ops_odot_dt, ("left"((t_xml_file_ers3_log.xmlf_on_lb)::text, 3)), t_xml_file_ers3_log.xmlf_type_message, (((xpath('//ers:ERS/ers:LOG/@IR'::text, t_xml_file_ers3_log.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text), (((xpath('//ers:ERS/ers:LOG/@XR'::text, t_xml_file_ers3_log.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text), t_xml_file_ers3_log.xmlf_creation_dt, ('FA'::text), t_ops.ops_fr_lb, t_ops.ops_ad_lb, t_ops.ops_version_ers_lb, t_xml_file_ers3_log.xmlf_file_name_lb, t_xml_file_ers3_log.xmlf_on_lb, (NULL::text), (NULL::text), (NULL::text), t_xml_file_ers3_log.xmlf_contenu_txt
4. 0.000 0.000 ↓ 0.0

Append (cost=0.87..5,280,402.72 rows=150,170 width=274) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.87..374,988.30 rows=9,984 width=777) (actual rows= loops=)

  • Output: 'ERS3'::text, concat('xmlf_'::text, t_xml_file_ers3_log.xmlf_cdn), CASE WHEN (t_xml_file_ers3_log.ret_cdn IS NULL) THEN 'MANQ'::text WHEN ((t_ret.ret_rs_lb)::text ~~ '000'::text) THEN 'ACQT'::text WHEN ((t_ret.ret_rs_lb)::text <> '000'::text) THEN 'NACQT'::text ELSE NULL::text END, t_ret.ret_cdn, NULL::integer, t_ops.ops_odot_dt, "left"((t_xml_file_ers3_log.xmlf_on_lb)::text, 3), t_xml_file_ers3_log.xmlf_type_message, ((xpath('//ers:ERS/ers:LOG/@IR'::text, t_xml_file_ers3_log.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text, ((xpath('//ers:ERS/ers:LOG/@XR'::text, t_xml_file_ers3_log.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text, t_xml_file_ers3_log.xmlf_creation_dt, 'FA'::text, t_ops.ops_fr_lb, t_ops.ops_ad_lb, t_ops.ops_version_ers_lb, t_xml_file_ers3_log.xmlf_file_name_lb, t_xml_file_ers3_log.xmlf_on_lb, NULL::text, NULL::text, NULL::text, t_xml_file_ers3_log.xmlf_contenu_txt
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.44..315,368.94 rows=9,984 width=765) (actual rows= loops=)

  • Output: t_xml_file_ers3_log.xmlf_cdn, t_xml_file_ers3_log.ret_cdn, t_xml_file_ers3_log.xmlf_on_lb, t_xml_file_ers3_log.xmlf_type_message, t_xml_file_ers3_log.xmlf_contenu_xml, t_xml_file_ers3_log.xmlf_creation_dt, t_xml_file_ers3_log.xmlf_file_name_lb, t_xml_file_ers3_log.xmlf_contenu_txt, t_ops.ops_odot_dt, t_ops.ops_fr_lb, t_ops.ops_ad_lb, t_ops.ops_version_ers_lb
7. 0.000 0.000 ↓ 0.0

Seq Scan on ers3.t_xml_file_ers3_log (cost=0.00..253,396.38 rows=9,984 width=746) (actual rows= loops=)

  • Output: t_xml_file_ers3_log.xmlf_flux_cdn, t_xml_file_ers3_log.xmlf_cdn, t_xml_file_ers3_log.xmlf_file_name_lb, t_xml_file_ers3_log.xmlf_on_lb, t_xml_file_ers3_log.xmlf_creation_dt, t_xml_file_ers3_log.xmlf_contenu_txt, t_xml_file_ers3_log.xmlf_datesys_dt, t_xml_file_ers3_log.xmlf_creation_flux_dt, t_xml_file_ers3_log.ret_cdn, t_xml_file_ers3_log.xmlf_contenu_xml, t_xml_file_ers3_log.xmlf_json, t_xml_file_ers3_log.xmlf_type_message, t_xml_file_ers3_log.xmlf_active
  • Filter: ((concat('xmlf_'::text, t_xml_file_ers3_log.xmlf_cdn) = 'xmlf_7000021549965'::text) OR (concat('xmlf_'::text, t_xml_file_ers3_log.xmlf_cdn) = 'xmlf_7000021549967'::text))
8. 0.000 0.000 ↓ 0.0

Index Scan using i_t_ops_xmlf_cdn on ers3.t_ops (cost=0.44..6.20 rows=1 width=27) (actual rows= loops=)

  • Output: t_ops.ops_cdn, t_ops.opr_rfa, t_ops.ops_ad_lb, t_ops.ops_fr_lb, t_ops.ops_on_lb, t_ops.ops_od_dt, t_ops.ops_ot_lb, t_ops.ops_ts_lb, t_ops.ops_odot_dt, t_ops.ops_creation_dt, t_ops.ops_type_mes_lb, t_ops.fd_cdn, t_ops.ops_conversion_dt, t_ops.ops_eav_lb, t_ops.ops_evl_lb, t_ops.ops_version_ers_lb, t_ops.ops_act_deb_da_dt, t_ops.ops_act_fin_da_dt, t_ops.ops_act_deb_ti_lb, t_ops.ops_act_fin_ti_lb, t_ops.ops_act_deb_dati_dt, t_ops.ops_act_fin_dati_dt, t_ops.ret_cdn, t_ops.rsp_cdn, t_ops.xmlf_cdn
  • Index Cond: (t_ops.xmlf_cdn = t_xml_file_ers3_log.xmlf_cdn)
9. 0.000 0.000 ↓ 0.0

Index Scan using pk_t_ret on ers3.t_ret (cost=0.43..5.95 rows=1 width=12) (actual rows= loops=)

  • Output: t_ret.ret_cdn, t_ret.ops_cdn, t_ret.ers_cdn, t_ret.ret_rs_lb, t_ret.ret_on_lb, t_ret.ret_re_lb, t_ret.ops_cdn_acquit, t_ret.ret_ir_acquit, t_ret.ret_na_acquit, t_ret.ret_rc_acquit, t_ret.ret_xr_acquit, t_ret.ret_ir_acquit_lb, t_ret.ret_xr_acquit_lb, t_ret.ret_rc_acquit_lb, t_ret.ret_na_acquit_lb
  • Index Cond: (t_ret.ret_cdn = t_xml_file_ers3_log.ret_cdn)
10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=483,796.30..3,911,932.43 rows=103,333 width=163) (actual rows= loops=)

  • Output: 'ERS3'::text, concat('xmlf_'::text, t_xml_file_ers3_sal.xmlf_cdn), CASE WHEN (t_xml_file_ers3_sal.ret_cdn IS NULL) THEN 'MANQ'::text WHEN ((t_ret_1.ret_rs_lb)::text ~~ '000'::text) THEN 'ACQT'::text WHEN ((t_ret_1.ret_rs_lb)::text <> '000'::text) THEN 'NACQT'::text ELSE NULL::text END, t_ret_1.ret_cdn, NULL::integer, t_ops_1.ops_odot_dt, "left"((t_xml_file_ers3_sal.xmlf_on_lb)::text, 3), t_xml_file_ers3_sal.xmlf_type_message, ((xpath('//ers:ERS/ers:SAL/@IR'::text, t_xml_file_ers3_sal.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text, ((xpath('//ers:ERS/ers:SAL/@XR'::text, t_xml_file_ers3_sal.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text, t_xml_file_ers3_sal.xmlf_creation_dt, 'SN'::text, t_ops_1.ops_fr_lb, t_ops_1.ops_ad_lb, t_ops_1.ops_version_ers_lb, t_xml_file_ers3_sal.xmlf_file_name_lb, t_xml_file_ers3_sal.xmlf_on_lb, NULL::text, NULL::text, NULL::text, t_xml_file_ers3_sal.xmlf_contenu_txt
11. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=483,795.86..3,289,212.59 rows=103,333 width=144) (actual rows= loops=)

  • Output: t_xml_file_ers3_sal.xmlf_cdn, t_xml_file_ers3_sal.ret_cdn, t_xml_file_ers3_sal.xmlf_on_lb, t_xml_file_ers3_sal.xmlf_type_message, t_xml_file_ers3_sal.xmlf_contenu_xml, t_xml_file_ers3_sal.xmlf_creation_dt, t_xml_file_ers3_sal.xmlf_file_name_lb, t_xml_file_ers3_sal.xmlf_contenu_txt, t_ret_1.ret_rs_lb, t_ret_1.ret_cdn
  • Hash Cond: (t_xml_file_ers3_sal.ret_cdn = t_ret_1.ret_cdn)
12. 0.000 0.000 ↓ 0.0

Seq Scan on ers3.t_xml_file_ers3_sal (cost=0.00..2,745,755.66 rows=103,333 width=132) (actual rows= loops=)

  • Output: t_xml_file_ers3_sal.xmlf_cdn, t_xml_file_ers3_sal.ret_cdn, t_xml_file_ers3_sal.xmlf_on_lb, t_xml_file_ers3_sal.xmlf_type_message, t_xml_file_ers3_sal.xmlf_contenu_xml, t_xml_file_ers3_sal.xmlf_creation_dt, t_xml_file_ers3_sal.xmlf_file_name_lb, t_xml_file_ers3_sal.xmlf_contenu_txt
  • Filter: ((concat('xmlf_'::text, t_xml_file_ers3_sal.xmlf_cdn) = 'xmlf_7000021549965'::text) OR (concat('xmlf_'::text, t_xml_file_ers3_sal.xmlf_cdn) = 'xmlf_7000021549967'::text))
13. 0.000 0.000 ↓ 0.0

Hash (cost=292,818.27..292,818.27 rows=10,986,527 width=12) (actual rows= loops=)

  • Output: t_ret_1.ret_rs_lb, t_ret_1.ret_cdn
14. 0.000 0.000 ↓ 0.0

Seq Scan on ers3.t_ret t_ret_1 (cost=0.00..292,818.27 rows=10,986,527 width=12) (actual rows= loops=)

  • Output: t_ret_1.ret_rs_lb, t_ret_1.ret_cdn
15. 0.000 0.000 ↓ 0.0

Index Scan using i_t_ops_xmlf_cdn on ers3.t_ops t_ops_1 (cost=0.44..6.00 rows=1 width=27) (actual rows= loops=)

  • Output: t_ops_1.ops_cdn, t_ops_1.opr_rfa, t_ops_1.ops_ad_lb, t_ops_1.ops_fr_lb, t_ops_1.ops_on_lb, t_ops_1.ops_od_dt, t_ops_1.ops_ot_lb, t_ops_1.ops_ts_lb, t_ops_1.ops_odot_dt, t_ops_1.ops_creation_dt, t_ops_1.ops_type_mes_lb, t_ops_1.fd_cdn, t_ops_1.ops_conversion_dt, t_ops_1.ops_eav_lb, t_ops_1.ops_evl_lb, t_ops_1.ops_version_ers_lb, t_ops_1.ops_act_deb_da_dt, t_ops_1.ops_act_fin_da_dt, t_ops_1.ops_act_deb_ti_lb, t_ops_1.ops_act_fin_ti_lb, t_ops_1.ops_act_deb_dati_dt, t_ops_1.ops_act_fin_dati_dt, t_ops_1.ret_cdn, t_ops_1.rsp_cdn, t_ops_1.xmlf_cdn
  • Index Cond: (t_ops_1.xmlf_cdn = t_xml_file_ers3_sal.xmlf_cdn)
16. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.87..991,536.55 rows=36,827 width=449) (actual rows= loops=)

  • Output: 'ERS3'::text, concat('xmlf_'::text, t_xml_file_ers3_autre.xmlf_cdn), CASE WHEN (t_xml_file_ers3_autre.ret_cdn IS NULL) THEN 'MANQ'::text WHEN ((t_ret_2.ret_rs_lb)::text ~~ '000'::text) THEN 'ACQT'::text WHEN ((t_ret_2.ret_rs_lb)::text <> '000'::text) THEN 'NACQT'::text ELSE NULL::text END, t_ret_2.ret_cdn, NULL::integer, t_ops_2.ops_odot_dt, "left"((t_xml_file_ers3_autre.xmlf_on_lb)::text, 3), t_xml_file_ers3_autre.xmlf_type_message, CASE WHEN xpath_exists('//ers:ERS/ers:LOG/@IR'::text, t_xml_file_ers3_autre.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]) THEN ((xpath('//ers:ERS/ers:LOG/@IR'::text, t_xml_file_ers3_autre.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text WHEN xpath_exists('//ers:ERS/ers:SAL/@IR'::text, t_xml_file_ers3_autre.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]) THEN ((xpath('//ers:ERS/ers:SAL/@IR'::text, t_xml_file_ers3_autre.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text ELSE NULL::text END, CASE WHEN xpath_exists('//ers:ERS/ers:LOG/@XR'::text, t_xml_file_ers3_autre.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]) THEN ((xpath('//ers:ERS/ers:LOG/@XR'::text, t_xml_file_ers3_autre.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text WHEN xpath_exists('//ers:ERS/ers:SAL/@XR'::text, t_xml_file_ers3_autre.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]) THEN ((xpath('//ers:ERS/ers:SAL/@XR'::text, t_xml_file_ers3_autre.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text ELSE NULL::text END, t_xml_file_ers3_autre.xmlf_creation_dt, CASE WHEN (((t_xml_file_ers3_autre.xmlf_type_message)::text = 'QUE_SAL'::text) OR ((t_xml_file_ers3_autre.xmlf_type_message)::text = 'RSP'::text)) THEN 'FA'::text ELSE NULL::text END, t_ops_2.ops_fr_lb, t_ops_2.ops_ad_lb, t_ops_2.ops_version_ers_lb, t_xml_file_ers3_autre.xmlf_file_name_lb, t_xml_file_ers3_autre.xmlf_on_lb, NULL::text, NULL::text, NULL::text, t_xml_file_ers3_autre.xmlf_contenu_txt
17. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.44..786,135.11 rows=36,827 width=437) (actual rows= loops=)

  • Output: t_xml_file_ers3_autre.xmlf_cdn, t_xml_file_ers3_autre.ret_cdn, t_xml_file_ers3_autre.xmlf_on_lb, t_xml_file_ers3_autre.xmlf_type_message, t_xml_file_ers3_autre.xmlf_contenu_xml, t_xml_file_ers3_autre.xmlf_creation_dt, t_xml_file_ers3_autre.xmlf_file_name_lb, t_xml_file_ers3_autre.xmlf_contenu_txt, t_ops_2.ops_odot_dt, t_ops_2.ops_fr_lb, t_ops_2.ops_ad_lb, t_ops_2.ops_version_ers_lb
18. 0.000 0.000 ↓ 0.0

Seq Scan on ers3.t_xml_file_ers3_autre (cost=0.00..573,308.56 rows=36,827 width=418) (actual rows= loops=)

  • Output: t_xml_file_ers3_autre.xmlf_flux_cdn, t_xml_file_ers3_autre.xmlf_cdn, t_xml_file_ers3_autre.xmlf_file_name_lb, t_xml_file_ers3_autre.xmlf_on_lb, t_xml_file_ers3_autre.xmlf_creation_dt, t_xml_file_ers3_autre.xmlf_contenu_txt, t_xml_file_ers3_autre.xmlf_datesys_dt, t_xml_file_ers3_autre.xmlf_creation_flux_dt, t_xml_file_ers3_autre.ret_cdn, t_xml_file_ers3_autre.xmlf_contenu_xml, t_xml_file_ers3_autre.xmlf_json, t_xml_file_ers3_autre.xmlf_type_message, t_xml_file_ers3_autre.xmlf_active
  • Filter: ((concat('xmlf_'::text, t_xml_file_ers3_autre.xmlf_cdn) = 'xmlf_7000021549965'::text) OR (concat('xmlf_'::text, t_xml_file_ers3_autre.xmlf_cdn) = 'xmlf_7000021549967'::text))
19. 0.000 0.000 ↓ 0.0

Index Scan using i_t_ops_xmlf_cdn on ers3.t_ops t_ops_2 (cost=0.44..5.77 rows=1 width=27) (actual rows= loops=)

  • Output: t_ops_2.ops_cdn, t_ops_2.opr_rfa, t_ops_2.ops_ad_lb, t_ops_2.ops_fr_lb, t_ops_2.ops_on_lb, t_ops_2.ops_od_dt, t_ops_2.ops_ot_lb, t_ops_2.ops_ts_lb, t_ops_2.ops_odot_dt, t_ops_2.ops_creation_dt, t_ops_2.ops_type_mes_lb, t_ops_2.fd_cdn, t_ops_2.ops_conversion_dt, t_ops_2.ops_eav_lb, t_ops_2.ops_evl_lb, t_ops_2.ops_version_ers_lb, t_ops_2.ops_act_deb_da_dt, t_ops_2.ops_act_fin_da_dt, t_ops_2.ops_act_deb_ti_lb, t_ops_2.ops_act_fin_ti_lb, t_ops_2.ops_act_deb_dati_dt, t_ops_2.ops_act_fin_dati_dt, t_ops_2.ret_cdn, t_ops_2.rsp_cdn, t_ops_2.xmlf_cdn
  • Index Cond: (t_ops_2.xmlf_cdn = t_xml_file_ers3_autre.xmlf_cdn)
20. 0.000 0.000 ↓ 0.0

Index Scan using pk_t_ret on ers3.t_ret t_ret_2 (cost=0.43..5.53 rows=1 width=12) (actual rows= loops=)

  • Output: t_ret_2.ret_cdn, t_ret_2.ops_cdn, t_ret_2.ers_cdn, t_ret_2.ret_rs_lb, t_ret_2.ret_on_lb, t_ret_2.ret_re_lb, t_ret_2.ops_cdn_acquit, t_ret_2.ret_ir_acquit, t_ret_2.ret_na_acquit, t_ret_2.ret_rc_acquit, t_ret_2.ret_xr_acquit, t_ret_2.ret_ir_acquit_lb, t_ret_2.ret_xr_acquit_lb, t_ret_2.ret_rc_acquit_lb, t_ret_2.ret_na_acquit_lb
  • Index Cond: (t_ret_2.ret_cdn = t_xml_file_ers3_autre.ret_cdn)
21. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 4 (cost=0.00..444.00 rows=26 width=430) (actual rows= loops=)

  • Output: 'FLUX'::text, "*SELECT* 4".meser_cdn, "*SELECT* 4".meser_status_lb, NULL::bigint, "*SELECT* 4".meser_ack_cdn, "*SELECT* 4".meser_declaration_dt, "*SELECT* 4".meser_typers_lb, "*SELECT* 4".meser_tymes_lb, "*SELECT* 4".meser_cfr_rfa, "*SELECT* 4".meser_marqext_lb, "*SELECT* 4".meser_creation_dt, "*SELECT* 4".meser_domaine_lb, "*SELECT* 4".meser_emet_lb, "*SELECT* 4".meser_dest_lb, NULL::character varying, "*SELECT* 4".meser_file_name_lb, NULL::character varying, "*SELECT* 4".meser_uuid_lb, "*SELECT* 4".meser_tripid_lb, "*SELECT* 4".meser_salesid_lb, "*SELECT* 4".meser_xml_contenu_txt
22. 0.000 0.000 ↓ 0.0

Seq Scan on ers3.t_xml_file_uncefact (cost=0.00..443.74 rows=26 width=430) (actual rows= loops=)

  • Output: 'FLUX'::text, concat('xmlfu_'::text, t_xml_file_uncefact.xmlfu_cdn), CASE WHEN (t_xml_file_uncefact.xmlfu_ok_metier_lb IS NULL) THEN 'MANQ'::text WHEN ((t_xml_file_uncefact.xmlfu_ok_metier_lb)::text = 'ACQU'::text) THEN 'ACQT'::text WHEN ((t_xml_file_uncefact.xmlfu_ok_metier_lb)::text = 'INFO'::text) THEN 'ACQT'::text WHEN ((t_xml_file_uncefact.xmlfu_ok_metier_lb)::text = 'WCNV'::text) THEN 'WACQT'::text WHEN ((t_xml_file_uncefact.xmlfu_ok_metier_lb)::text = 'WBRU'::text) THEN 'WACQT'::text WHEN ((t_xml_file_uncefact.xmlfu_ok_metier_lb)::text = 'ECNV'::text) THEN 'NACQT'::text WHEN ((t_xml_file_uncefact.xmlfu_ok_metier_lb)::text = 'EBRU'::text) THEN 'NACQT'::text WHEN ((t_xml_file_uncefact.xmlfu_ok_metier_lb)::text = 'ERRT'::text) THEN 'NACQT'::text WHEN ((t_xml_file_uncefact.xmlfu_ok_metier_lb)::text = 'ERRI'::text) THEN 'NACQT'::text ELSE NULL::text END, NULL::bigint, t_xml_file_uncefact.xmlfu_ack_cdn, (((xpath('//rsm:FLUXSalesReportMessage/rsm:FLUXReportDocument/ram:CreationDateTime/udt:DateTime/text()'::text, t_xml_file_uncefact.xmlfu_contenu_xml, '{{rsm,urn:un:unece:uncefact:data:standard:FLUXResponseMessage:6},{ram,urn:un:unece:uncefact:data:standard:ReusableAggregateBusinessInformationEntity:20},{udt,urn:un:unece:uncefact:data:standard:UnqualifiedDataType:20}}'::text[]))[1])::text)::date, t_xml_file_uncefact.xmlfu_typers_lb, t_xml_file_uncefact.xmlfu_typmes_lb, ((xpath('//ram:RelatedVesselTransportMeans/ram:ID[@schemeID="CFR"]/text()'::text, t_xml_file_uncefact.xmlfu_contenu_xml, '{{ram,urn:un:unece:uncefact:data:standard:ReusableAggregateBusinessInformationEntity:20}}'::text[]))[1])::text, ((xpath('//ram:RelatedVesselTransportMeans/ram:ID[@schemeID="EXT_MARK"]/text()'::text, t_xml_file_uncefact.xmlfu_contenu_xml, '{{ram,urn:un:unece:uncefact:data:standard:ReusableAggregateBusinessInformationEntity:20}}'::text[]))[1])::text, t_xml_file_uncefact.xmlfu_creation_dt, t_xml_file_uncefact.xmlfu_typfasn_lb, t_xml_file_uncefact.xmlfu_emet_lb, t_xml_file_uncefact.xmlfu_dest_lb, NULL::character varying, t_xml_file_uncefact.xmlfu_file_name_lb, NULL::character varying, t_xml_file_uncefact.xmlfu_uuid_lb, ((xpath('//ram:SpecifiedFishingTrip/ram:ID[@schemeID="EU_TRIP_ID"]/text()'::text, t_xml_file_uncefact.xmlfu_contenu_xml, '{{ram,urn:un:unece:uncefact:data:standard:ReusableAggregateBusinessInformationEntity:20}}'::text[]))[1])::text, ((xpath('//ram:IncludedSalesDocument/ram:ID[@schemeID="EU_SALES_ID"]/text()'::text, t_xml_file_uncefact.xmlfu_contenu_xml, '{{ram,urn:un:unece:uncefact:data:standard:ReusableAggregateBusinessInformationEntity:20}}'::text[]))[1])::text, t_xml_file_uncefact.xmlfu_contenu_txt
  • Filter: ((concat('xmlfu_'::text, t_xml_file_uncefact.xmlfu_cdn) = 'xmlf_7000021549965'::text) OR (concat('xmlfu_'::text, t_xml_file_uncefact.xmlfu_cdn) = 'xmlf_7000021549967'::text))