explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X3jJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.311 294.706 ↑ 1.0 500 1

Limit (cost=1.30..7,467.77 rows=500 width=520) (actual time=1.114..294.706 rows=500 loops=1)

  • Output: t_xml_file_ers3_sal.xmlf_cdn, ((t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_SN'::text)), ((t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_WT'::text)), t_xml_file_ers3_sal.xmlf_flux_cdn, t_xml_file_ers3_sal.xmlf_file_name_lb, ((((((xpath('/ers:OPS/@OD'::text, t_xml_file_ers3_sal.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text || ' '::text) || ((xpath('/ers:OPS/@OT'::text, t_xml_file_ers3_sal.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text) || ':00'::text)), (((xpath('/ers:OPS/@ON'::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/@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), (((xpath('//ers:ERS/ers:SAL/@FS'::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/@NA'::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_type_message, t_xml_file_ers3_sal.xmlf_contenu_xml, t_xml_file_ers3_sal.ret_cdn, ((t_json_sal_xli.json_xli ->> 'type_SLI_TLI'::text)), ((t_json_sal_xli.json_xli ->> 'numeroMaree_ESPE_MR'::text)), ((t_json_sal_xli.json_xli ->> 'portDeVente_XLI_SL'::text)), ((t_json_sal_xli.json_xli ->> 'portDeDebarquement_SRC_PO'::text)), ((t_json_sal_xli.json_xli ->> 'dateDeDebarquement_SRC_DL'::text)), ((t_json_sal_xli.json_xli ->> 'dateDeVente_XLI_DA'::text)), ((t_json_sal_xli.json_xli ->> 'heureDeVente_ESLI_TI'::text))
2. 282.676 294.395 ↑ 70.9 500 1

Nested Loop (cost=1.30..529,269.63 rows=35,443 width=520) (actual time=1.112..294.395 rows=500 loops=1)

  • Output: t_xml_file_ers3_sal.xmlf_cdn, (t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_SN'::text), (t_json_sal_spe.json_xli_css_spe ->> 'espece_SPE_WT'::text), t_xml_file_ers3_sal.xmlf_flux_cdn, t_xml_file_ers3_sal.xmlf_file_name_lb, (((((xpath('/ers:OPS/@OD'::text, t_xml_file_ers3_sal.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text || ' '::text) || ((xpath('/ers:OPS/@OT'::text, t_xml_file_ers3_sal.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text) || ':00'::text), ((xpath('/ers:OPS/@ON'::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/@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, ((xpath('//ers:ERS/ers:SAL/@FS'::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/@NA'::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_type_message, t_xml_file_ers3_sal.xmlf_contenu_xml, t_xml_file_ers3_sal.ret_cdn, (t_json_sal_xli.json_xli ->> 'type_SLI_TLI'::text), (t_json_sal_xli.json_xli ->> 'numeroMaree_ESPE_MR'::text), (t_json_sal_xli.json_xli ->> 'portDeVente_XLI_SL'::text), (t_json_sal_xli.json_xli ->> 'portDeDebarquement_SRC_PO'::text), (t_json_sal_xli.json_xli ->> 'dateDeDebarquement_SRC_DL'::text), (t_json_sal_xli.json_xli ->> 'dateDeVente_XLI_DA'::text), (t_json_sal_xli.json_xli ->> 'heureDeVente_ESLI_TI'::text)
3. 1.559 8.719 ↑ 70.9 500 1

Nested Loop (cost=0.87..311,259.80 rows=35,443 width=442) (actual time=0.115..8.719 rows=500 loops=1)

  • Output: t_json_sal_xli.json_xli, t_json_sal_xli.xmlf_flux_cdn, t_json_sal_spe.json_xli_css_spe
4. 1.948 1.948 ↑ 27.3 1,303 1

Index Scan using i_t_json_sal_xli_portdevente_xli_sl on ers3.t_json_sal_xli (cost=0.43..101,372.12 rows=35,582 width=280) (actual time=0.099..1.948 rows=1,303 loops=1)

  • Output: t_json_sal_xli.t_json_sal_xli_cdn, t_json_sal_xli.json_xli, t_json_sal_xli.xmlf_flux_cdn
  • Index Cond: ((t_json_sal_xli.json_xli ->> 'portDeVente_XLI_SL'::text) = 'FRQUY'::text)
5. 5.212 5.212 ↓ 0.0 0 1,303

Index Scan using i_t_json_sal_spe_sal_xli_cdn on ers3.t_json_sal_spe (cost=0.43..5.89 rows=1 width=170) (actual time=0.004..0.004 rows=0 loops=1,303)

  • Output: t_json_sal_spe.t_json_sal_spe_cdn, t_json_sal_spe.json_xli_css_spe, t_json_sal_spe.xmlf_flux_cdn, t_json_sal_spe.t_json_sal_xli_cdn
  • Index Cond: (t_json_sal_spe.t_json_sal_xli_cdn = t_json_sal_xli.t_json_sal_xli_cdn)
6. 3.000 3.000 ↑ 1.0 1 500

Index Scan using pk_t_xml_file_ers3_sal on ers3.t_xml_file_ers3_sal (cost=0.43..6.09 rows=1 width=82) (actual time=0.005..0.006 rows=1 loops=500)

  • Output: t_xml_file_ers3_sal.xmlf_flux_cdn, t_xml_file_ers3_sal.xmlf_cdn, t_xml_file_ers3_sal.xmlf_file_name_lb, t_xml_file_ers3_sal.xmlf_on_lb, t_xml_file_ers3_sal.xmlf_creation_dt, t_xml_file_ers3_sal.xmlf_contenu_txt, t_xml_file_ers3_sal.xmlf_datesys_dt, t_xml_file_ers3_sal.xmlf_creation_flux_dt, t_xml_file_ers3_sal.ret_cdn, t_xml_file_ers3_sal.xmlf_contenu_xml, t_xml_file_ers3_sal.xmlf_json, t_xml_file_ers3_sal.xmlf_type_message, t_xml_file_ers3_sal.xmlf_active
  • Index Cond: (t_xml_file_ers3_sal.xmlf_flux_cdn = t_json_sal_xli.xmlf_flux_cdn)
Planning time : 1.640 ms
Execution time : 295.062 ms