explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oT3s : avec xpath

Settings
# exclusive inclusive rows x rows loops node
1. 1.102 28,521.764 ↓ 3.4 859 1

Limit (cost=0.43..2,314.90 rows=253 width=32) (actual time=0.517..28,521.764 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. 28,520.662 28,520.662 ↓ 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=0.516..28,520.662 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[])