explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3PB5 : Optimization for: Optimization for: Optimization for: plan #JdVQ; plan #5cqY; plan #umMl

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.012 0.088 ↑ 1.0 5 1

Limit (cost=0.43..0.86 rows=5 width=233) (actual time=0.063..0.088 rows=5 loops=1)

2. 0.013 0.076 ↑ 6,822,221.2 5 1

Nested Loop (cost=0.43..2,895,138.68 rows=34,111,106 width=233) (actual time=0.060..0.076 rows=5 loops=1)

3. 0.004 0.016 ↑ 1,893,971.0 1 1

Append (cost=0.00..512,243.88 rows=1,893,971 width=63) (actual time=0.016..0.016 rows=1 loops=1)

4. 0.002 0.012 ↑ 1,697,001.0 1 1

Subquery Scan on *SELECT* 1 (cost=0.00..455,156.02 rows=1,697,001 width=62) (actual time=0.012..0.012 rows=1 loops=1)

5. 0.010 0.010 ↑ 1,697,001.0 1 1

Seq Scan on t_xml_file_ers3_sal (cost=0.00..438,186.01 rows=1,697,001 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (xmlf_cdn IS NOT NULL)
6. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2 (cost=0.00..44,129.12 rows=175,006 width=76) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Seq Scan on t_xml_file_ers3_log (cost=0.00..42,379.06 rows=175,006 width=44) (never executed)

  • Filter: (xmlf_cdn IS NOT NULL)
8. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3 (cost=0.43..12,958.74 rows=21,964 width=62) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using i_t_xml_file_ers3_autre_type_message on t_xml_file_ers3_autre (cost=0.43..12,739.10 rows=21,964 width=30) (never executed)

  • Index Cond: ((xmlf_type_message)::text = ANY ('{QUE_SAL,RSP}'::text[]))
  • Filter: (xmlf_cdn IS NOT NULL)
10. 0.047 0.047 ↑ 3.6 5 1

Index Scan using i_t_journal_ers3_xmlf_cdn on t_journal_ers3 (cost=0.43..1.08 rows=18 width=178) (actual time=0.039..0.047 rows=5 loops=1)

  • Index Cond: (xmlf_cdn = "*SELECT* 1".xmlf_cdn)
Planning time : 0.740 ms