explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NcYC : avec json

Settings
# exclusive inclusive rows x rows loops node
1. 0.359 532.502 ↑ 1.2 859 1

Limit (cost=0.45..3,036.17 rows=1,000 width=772) (actual time=0.193..532.502 rows=859 loops=1)

  • Output: (replace((((t_xml_file_ers3.xmlf_json -> 'ers:OPS'::text) -> 'AD'::text))::text, '"'::text, ''::text)), (replace((((t_xml_file_ers3.xmlf_json -> 'ers:OPS'::text) -> 'FR'::text))::text, '"'::text, ''::text))
2. 532.143 532.143 ↑ 44.3 859 1

Index Scan using t_xml_file_ers3_ops_dat_ers_log_xr on ers3.t_xml_file_ers3 (cost=0.45..115,527.83 rows=38,056 width=772) (actual time=0.191..532.143 rows=859 loops=1)

  • Output: replace((((t_xml_file_ers3.xmlf_json -> 'ers:OPS'::text) -> 'AD'::text))::text, '"'::text, ''::text), replace((((t_xml_file_ers3.xmlf_json -> 'ers:OPS'::text) -> 'FR'::text))::text, '"'::text, ''::text)
  • Index Cond: (replace(((((((t_xml_file_ers3.xmlf_json -> 'ers:OPS'::text) -> 'ers:DAT'::text) -> 'ers:ERS'::text) -> 'ers:LOG'::text) -> 'XR'::text))::text, '"'::text, ''::text) = 'ST146960'::text)