explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.018 229.682 ↑ 1.0 5 1

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

2. 12.231 229.664 ↑ 6,822,221.2 5 1

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

3. 11.758 140.915 ↑ 321.8 5,886 1

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

4. 13.033 129.157 ↑ 288.3 5,886 1

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

5. 116.124 116.124 ↑ 288.3 5,886 1

Seq Scan on t_xml_file_ers3_sal (cost=0.00..438,186.01 rows=1,697,001 width=30) (actual time=0.011..116.124 rows=5,886 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. 76.518 76.518 ↓ 0.0 0 5,886

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.013..0.013 rows=0 loops=5,886)

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