explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.913 1,390.680 ↑ 1.0 1,000 1

Limit (cost=70,288.23..70,290.73 rows=1,000 width=277) (actual time=1,387.727..1,390.680 rows=1,000 loops=1)

2. 10.391 1,388.767 ↑ 4.1 1,000 1

Sort (cost=70,288.23..70,298.60 rows=4,147 width=277) (actual time=1,387.722..1,388.767 rows=1,000 loops=1)

  • Sort Key: t_journal_ers3.jou_creation_dt
  • Sort Method: top-N heapsort Memory: 495kB
3. 17.246 1,378.376 ↑ 1.3 3,300 1

Nested Loop Left Join (cost=1.71..70,060.85 rows=4,147 width=277) (actual time=1.414..1,378.376 rows=3,300 loops=1)

  • Filter: ((t_xml_file_ers3_log.xmlf_cdn IS NOT NULL) OR (t_xml_file_ers3_sal.xmlf_cdn IS NOT NULL) OR (t_xml_file_ers3_autre.xmlf_cdn IS NOT NULL))
  • Rows Removed by Filter: 160
4. 15.170 845.590 ↑ 1.2 3,460 1

Nested Loop Left Join (cost=1.28..46,482.60 rows=4,147 width=251) (actual time=1.206..845.590 rows=3,460 loops=1)

5. 16.763 463.660 ↑ 1.2 3,460 1

Nested Loop Left Join (cost=0.85..22,359.72 rows=4,147 width=221) (actual time=0.979..463.660 rows=3,460 loops=1)

6. 218.537 218.537 ↑ 1.2 3,460 1

Index Scan using i_t_journal_ers3_alerte_bl on t_journal_ers3 (cost=0.43..250.93 rows=4,147 width=178) (actual time=0.583..218.537 rows=3,460 loops=1)

  • Index Cond: (jou_alerte_bl = true)
  • Filter: jou_alerte_bl
7. 228.360 228.360 ↑ 1.0 1 3,460

Index Scan using i_t_xml_file_ers3_log_xmlf_cdn on t_xml_file_ers3_log (cost=0.42..5.32 rows=1 width=43) (actual time=0.065..0.066 rows=1 loops=3,460)

  • Index Cond: (xmlf_cdn = t_journal_ers3.xmlf_cdn)
8. 366.760 366.760 ↓ 0.0 0 3,460

Index Scan using i_t_xml_file_ers3_sal_xmlf_cdn on t_xml_file_ers3_sal (cost=0.43..5.81 rows=1 width=30) (actual time=0.106..0.106 rows=0 loops=3,460)

  • Index Cond: (xmlf_cdn = t_journal_ers3.xmlf_cdn)
9. 515.540 515.540 ↓ 0.0 0 3,460

Index Scan using i_t_xml_file_ers3_autre_xmlf_cdn on t_xml_file_ers3_autre (cost=0.43..5.67 rows=1 width=34) (actual time=0.148..0.149 rows=0 loops=3,460)

  • Index Cond: (xmlf_cdn = t_journal_ers3.xmlf_cdn)
Planning time : 5.013 ms