#	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

"Limit  (cost=0.43..58341.72 rows=1000 width=121) (actual time=31.532..8024.173 rows=1000 loops=1)"
"  ->  Index Scan using i_t_xml_file_ers3_creation_dt on t_xml_file_ers3  (cost=0.43..2161428.40 rows=37048 width=121) (actual time=31.529..8023.563 rows=1000 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"
"Planning time: 0.586 ms"
"Execution time: 8024.566 ms"

Per node type stats

node type	count	sum of times	% of query
Index Scan	1	8,023.563 ms	100.0 %
Limit	1	0.610 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
t_xml_file_ers3	1	8,023.563 ms	100.0 %
Index Scan	1	8,023.563 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ddfu

Color mode:

Visible columns:

Per node type stats

Per table stats