explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QVL : avec xpath

Settings
# exclusive inclusive rows x rows loops node
1. 0.516 3,520.579 ↓ 3.4 859 1

Limit (cost=0.43..2,314.90 rows=253 width=32) (actual time=6.598..3,520.579 rows=859 loops=1)

  • Output: (((xpath('/ers:OPS/@AD'::text, t_xml_file_ers3.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text), (((xpath('/ers:OPS/@FR'::text, t_xml_file_ers3.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/sch (...)
2. 3,520.063 3,520.063 ↓ 3.4 859 1

Index Scan using i_t_xml_file_ers3_xpath_marquage_ext_journaux_bord on ers3.t_xml_file_ers3 (cost=0.43..2,314.90 rows=253 width=32) (actual time=6.598..3,520.063 rows=859 loops=1)

  • Output: ((xpath('/ers:OPS/@AD'::text, t_xml_file_ers3.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text, ((xpath('/ers:OPS/@FR'::text, t_xml_file_ers3.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/ (...)
  • Index Cond: (((xpath('/ers:OPS/ers:DAT/ers:ERS/ers:LOG/@XR'::text, t_xml_file_ers3.xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1])::text = 'ST146960'::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[])