explain.depesz.com

PostgreSQL's explain analyze made readable

Result: geRo

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 35,815.745 ↑ 2.0 1 1

Append (cost=0.87..172,739.19 rows=2 width=318) (actual time=35,815.529..35,815.745 rows=1 loops=1)

2. 0.000 35,815.439 ↓ 0.0 0 1

Nested Loop (cost=0.87..172,689.86 rows=1 width=471) (actual time=35,815.439..35,815.439 rows=0 loops=1)

3. 0.001 35,815.439 ↓ 0.0 0 1

Nested Loop (cost=0.43..172,686.02 rows=1 width=479) (actual time=35,815.439..35,815.439 rows=0 loops=1)

4. 35,815.438 35,815.438 ↓ 0.0 0 1

Seq Scan on t_xml_file_ers3_log (cost=0.00..172,679.55 rows=1 width=471) (actual time=35,815.438..35,815.438 rows=0 loops=1)

  • Filter: ((xmlf_creation_dt >= '2018-06-15 09:20:38.165+02'::timestamp with time zone) AND ((xmlf_file_name_lb)::text = 'SRCFRA20180620125857_20180620125915.xml'::text))
  • Rows Removed by Filter: 683183
5. 0.000 0.000 ↓ 0.0 0

Index Scan using i_t_ops_xmlf_cdn on t_ops (cost=0.43..6.46 rows=1 width=16) (never executed)

  • Index Cond: (xmlf_cdn = t_xml_file_ers3_log.xmlf_cdn)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using i_t_ers3_ops_cdn on t_ers3 (cost=0.43..3.79 rows=1 width=8) (never executed)

  • Index Cond: (ops_cdn = t_ops.ops_cdn)
  • Filter: (ers_modification_dt IS NULL)
7. 0.010 0.302 ↑ 1.0 1 1

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

8. 0.292 0.292 ↑ 1.0 1 1

Seq Scan on t_xml_file_uncefact (cost=0.00..49.31 rows=1 width=166) (actual time=0.076..0.292 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