explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rpUG

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 2,826.028 ↑ 1.0 1 1

Aggregate (cost=21,502.26..21,502.27 rows=1 width=8) (actual time=2,826.027..2,826.028 rows=1 loops=1)

2. 2,826.024 2,826.024 ↓ 0.0 0 1

Seq Scan on xml_content (cost=0.00..21,501.01 rows=500 width=0) (actual time=2,826.024..2,826.024 rows=0 loops=1)

  • Filter: ((xpath('/info/car_info/car_no/text()'::text, content, '{}'::text[]))::text[] @> '{AK}'::text[])
  • Rows Removed by Filter: 100001
Planning time : 0.066 ms
Execution time : 2,826.048 ms