explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.944 161.664 ↑ 1.0 1,000 1

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

2. 9.023 159.720 ↑ 4.1 1,000 1

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

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

Nested Loop Left Join (cost=1.71..70,060.85 rows=4,147 width=277) (actual time=0.185..150.697 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. 11.878 105.216 ↑ 1.2 3,460 1

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

5. 15.235 72.578 ↑ 1.2 3,460 1

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

6. 26.203 26.203 ↑ 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.095..26.203 rows=3,460 loops=1)

  • Index Cond: (jou_alerte_bl = true)
  • Filter: (jou_alerte_bl IS TRUE)
7. 31.140 31.140 ↑ 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.008..0.009 rows=1 loops=3,460)

  • Index Cond: (xmlf_cdn = t_journal_ers3.xmlf_cdn)
8. 20.760 20.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.006..0.006 rows=0 loops=3,460)

  • Index Cond: (xmlf_cdn = t_journal_ers3.xmlf_cdn)
9. 27.680 27.680 ↓ 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.008..0.008 rows=0 loops=3,460)

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