explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1y3x

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.313 ↑ 2.0 1 1

Append (cost=0.00..49.38 rows=2 width=83) (actual time=0.049..0.313 rows=1 loops=1)

2. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.04 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
3. 0.006 0.311 ↑ 1.0 1 1

Subquery Scan on *SELECT* 2 (cost=0.00..49.32 rows=1 width=166) (actual time=0.047..0.311 rows=1 loops=1)

4. 0.305 0.305 ↑ 1.0 1 1

Seq Scan on t_xml_file_uncefact (cost=0.00..49.31 rows=1 width=166) (actual time=0.042..0.305 rows=1 loops=1)

  • Filter: ((xmlfu_creation_dt >= '2018-06-15 09:20:38.165+02'::timestamp with time zone) AND ((xmlfu_file_name_lb)::text = 'SRCFRA20180620125857_20180620125915.xml'::text))
  • Rows Removed by Filter: 351
Planning time : 1.256 ms
Execution time : 0.453 ms