explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ddfu

Settings
# exclusive inclusive rows x rows loops node
1. 0.610 8,024.173 ↑ 1.0 1,000 1

Limit (cost=0.43..58,341.72 rows=1,000 width=121) (actual time=31.532..8,024.173 rows=1,000 loops=1)

2. 8,023.563 8,023.563 ↑ 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=31.529..8,023.563 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