explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oYJM

Settings
# exclusive inclusive rows x rows loops node
1. 0.099 29,064.897 ↑ 1.0 1,000 1

Limit (cost=102,279.02..102,281.52 rows=1,000 width=853) (actual time=29,064.621..29,064.897 rows=1,000 loops=1)

2. 113.347 29,064.798 ↑ 12.3 1,000 1

Sort (cost=102,279.02..102,309.89 rows=12,349 width=853) (actual time=29,064.618..29,064.798 rows=1,000 loops=1)

  • Sort Key: t_xml_file_ers3.xmlf_creation_dt
  • Sort Method: top-N heapsort Memory: 1942kB
3. 28,918.125 28,951.451 ↓ 5.5 68,357 1

Bitmap Heap Scan on t_xml_file_ers3 (cost=671.38..101,601.94 rows=12,349 width=853) (actual time=61.128..28,951.451 rows=68,357 loops=1)

  • Recheck Cond: (((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)
  • Filter: xpath_exists('/ers:OPS/ers:DAT/ers:ERS/ers:LOG'::text, xmlf_contenu_xml, '{{ers,http://ec.europa.eu/fisheries/schema/ers/v3}}'::text[])
  • Heap Blocks: exact=58884
4. 33.326 33.326 ↓ 1.9 68,639 1

Bitmap Index Scan on idx_t_xml_file_xpath_type_declaration (cost=0.00..668.30 rows=37,048 width=0) (actual time=33.326..33.326 rows=68,639 loops=1)

  • Index Cond: (((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)