explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a7Wj

Settings
# exclusive inclusive rows x rows loops node
1. 0.477 5,662.304 ↑ 1.0 1,000 1

Limit (cost=0.43..58,341.72 rows=1,000 width=121) (actual time=29.010..5,662.304 rows=1,000 loops=1)

2. 5,661.827 5,661.827 ↑ 37.0 1,000 1

Index Scan using i_t_xml_file_ers3_creation_dt on t_xml_file_ers3 (cost=0.43..2,161,428.40 rows=37,048 width=121) (actual time=29.008..5,661.827 rows=1,000 loops=1)

  • Filter: (((xpath('name()'::text, (xpath('/ers:OPS/ers:DAT/ers:ERS/ers:LOG/*'::text, xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[]))[1], '{}'::text[]))[1])::text = 'ers:RTP'::text)
  • Rows Removed by Filter: 93710