explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cZV5

Settings
# exclusive inclusive rows x rows loops node
1. 0.165 0.219 ↑ 38,041.0 1 1

Bitmap Heap Scan on ers3.t_xml_file_ers3 (cost=862.39..114,166.07 rows=38,041 width=812) (actual time=0.216..0.219 rows=1 loops=1)

  • Output: replace((((xmlf_json -> 'ers:OPS'::text) -> 'AD'::text))::text, '"'::text, ''::text), replace((((xmlf_json -> 'ers:OPS'::text) -> 'FR'::text))::text, '"'::text, ''::text), replace(((((((xmlf_json -> 'ers:OPS'::text) -> 'OD'::text))::text || ' ':: (...)
  • Recheck Cond: (replace((((t_xml_file_ers3.xmlf_json -> 'ers:OPS'::text) -> 'ON'::text))::text, '"'::text, ''::text) = 'OOF20180813053602'::text)
  • Heap Blocks: exact=1
2. 0.054 0.054 ↑ 38,041.0 1 1

Bitmap Index Scan on t_xml_file_ers3_ops_on (cost=0.00..852.88 rows=38,041 width=0) (actual time=0.054..0.054 rows=1 loops=1)

  • Index Cond: (replace((((t_xml_file_ers3.xmlf_json -> 'ers:OPS'::text) -> 'ON'::text))::text, '"'::text, ''::text) = 'OOF20180813053602'::text)