explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FTJY

Settings
# exclusive inclusive rows x rows loops node
1. 1.410 1.410 ↑ 1.0 1 1

Index Scan using i_t_xml_file_ers3_xpath_id_message on ers3.t_xml_file_ers3 (cost=0.56..6.62 rows=1 width=855) (actual time=1.405..1.410 rows=1 loops=1)

  • Output: t_xml_file_ers3.xmlf_cdn, t_xml_file_ers3.xmlf_flux_cdn, t_xml_file_ers3.xmlf_creation_dt, t_xml_file_ers3.xmlf_file_name_lb, ((xpath('/ers:OPS/@AD'::text, t_xml_file_ers3.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::t (...)
  • Index Cond: (((xpath('/ers:OPS/@ON'::text, t_xml_file_ers3.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text = 'OOF20180813053602'::text)
  • Filter: xpath_exists('/ers:OPS/ers:DAT/ers:ERS/ers:LOG'::text, t_xml_file_ers3.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[])