explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wm5O

Settings
# exclusive inclusive rows x rows loops node
1. 0.395 877.292 ↑ 1.0 500 1

Limit (cost=1.30..7,467.77 rows=500 width=520) (actual time=5.882..877.292 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. 477.613 876.897 ↑ 70.9 500 1

Nested Loop (cost=1.30..529,269.63 rows=35,443 width=520) (actual time=5.880..876.897 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.851 331.784 ↑ 70.9 500 1

Nested Loop (cost=0.87..311,259.80 rows=35,443 width=442) (actual time=4.802..331.784 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. 237.420 237.420 ↑ 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.084..237.420 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. 92.513 92.513 ↓ 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.071..0.071 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. 67.500 67.500 ↑ 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.132..0.135 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 : 537.510 ms
Execution time : 877.655 ms