explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7D4a

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 229,016.631 ↑ 1.0 1 1

Limit (cost=1.29..3,666.08 rows=1 width=264) (actual time=229,016.630..229,016.631 rows=1 loops=1)

  • Output: t_journal_ers3.xmlf_cdn, (COALESCE(t_xml_file_ers3_log.xmlf_file_name_lb, t_xml_file_ers3_sal.xmlf_file_name_lb, t_xml_file_ers3_autre.xmlf_file_name_lb)), t_journal_ers3.jou_cdn, t_journal_ers3.jou_cle_lb, t_journal_ers3.jou_creation_dt, t_journal_ers3.jou_alerte_bl, t_journal_ers3.jou_msg_lb, (CASE WHEN (t_xml_file_ers3_sal.xmlf_cdn IS NOT NULL) THEN 'SN'::text WHEN ((t_xml_file_ers3_log.xmlf_cdn IS NOT NULL) OR ((t_xml_file_ers3_autre.xmlf_type_message)::text = ANY ('{QUE_SAL,RSP}'::text[]))) THEN 'FA'::text ELSE NULL::text END)
2. 17,135.372 229,016.626 ↑ 210,499.0 1 1

Nested Loop Left Join (cost=1.29..771,433,724.05 rows=210,499 width=264) (actual time=229,016.626..229,016.626 rows=1 loops=1)

  • Output: t_journal_ers3.xmlf_cdn, COALESCE(t_xml_file_ers3_log.xmlf_file_name_lb, t_xml_file_ers3_sal.xmlf_file_name_lb, t_xml_file_ers3_autre.xmlf_file_name_lb), t_journal_ers3.jou_cdn, t_journal_ers3.jou_cle_lb, t_journal_ers3.jou_creation_dt, t_journal_ers3.jou_alerte_bl, t_journal_ers3.jou_msg_lb, CASE WHEN (t_xml_file_ers3_sal.xmlf_cdn IS NOT NULL) THEN 'SN'::text WHEN ((t_xml_file_ers3_log.xmlf_cdn IS NOT NULL) OR ((t_xml_file_ers3_autre.xmlf_type_message)::text = ANY ('{QUE_SAL,RSP}'::text[]))) THEN 'FA'::text ELSE NULL::text END
  • 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)) AND (CASE WHEN (t_xml_file_ers3_sal.xmlf_cdn IS NOT NULL) THEN 'SN'::text WHEN ((t_xml_file_ers3_log.xmlf_cdn IS NOT NULL) OR ((t_xml_file_ers3_autre.xmlf_type_message)::text = ANY ('{QUE_SAL,RSP}'::text[]))) THEN 'FA'::text ELSE NULL::text END = 'FA'::text))
  • Rows Removed by Filter: 25948273
3. 29,458.466 185,932.980 ↑ 1.6 25,948,274 1

Nested Loop Left Join (cost=0.86..514,651,055.20 rows=42,099,824 width=238) (actual time=22.717..185,932.980 rows=25,948,274 loops=1)

  • Output: t_journal_ers3.xmlf_cdn, t_journal_ers3.jou_cdn, t_journal_ers3.jou_cle_lb, t_journal_ers3.jou_creation_dt, t_journal_ers3.jou_alerte_bl, t_journal_ers3.jou_msg_lb, t_xml_file_ers3_log.xmlf_file_name_lb, t_xml_file_ers3_log.xmlf_cdn, t_xml_file_ers3_sal.xmlf_file_name_lb, t_xml_file_ers3_sal.xmlf_cdn
4. 31,679.295 130,526.240 ↑ 1.6 25,948,274 1

Nested Loop Left Join (cost=0.42..257,789,907.60 rows=42,099,824 width=208) (actual time=22.712..130,526.240 rows=25,948,274 loops=1)

  • Output: t_journal_ers3.xmlf_cdn, t_journal_ers3.jou_cdn, t_journal_ers3.jou_cle_lb, t_journal_ers3.jou_creation_dt, t_journal_ers3.jou_alerte_bl, t_journal_ers3.jou_msg_lb, t_xml_file_ers3_log.xmlf_file_name_lb, t_xml_file_ers3_log.xmlf_cdn
5. 72,898.671 72,898.671 ↑ 1.6 25,948,274 1

Seq Scan on ers3.t_journal_ers3 (cost=0.00..1,471,699.24 rows=42,099,824 width=160) (actual time=22.691..72,898.671 rows=25,948,274 loops=1)

  • Output: t_journal_ers3.jou_cdn, t_journal_ers3.ops_cdn, t_journal_ers3.jou_msg_lb, t_journal_ers3.jou_creation_dt, t_journal_ers3.jou_type_lb, t_journal_ers3.jou_cle_lb, t_journal_ers3.jou_alerte_bl, t_journal_ers3.jou_traite_bl, t_journal_ers3.xmlf_cdn, t_journal_ers3.jou_code_trait_lb
6. 25,948.274 25,948.274 ↓ 0.0 0 25,948,274

Index Scan using i_t_xml_file_ers3_log_xmlf_cdn on ers3.t_xml_file_ers3_log (cost=0.42..6.08 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=25,948,274)

  • Output: t_xml_file_ers3_log.xmlf_flux_cdn, t_xml_file_ers3_log.xmlf_cdn, t_xml_file_ers3_log.xmlf_file_name_lb, t_xml_file_ers3_log.xmlf_on_lb, t_xml_file_ers3_log.xmlf_creation_dt, t_xml_file_ers3_log.xmlf_contenu_txt, t_xml_file_ers3_log.xmlf_datesys_dt, t_xml_file_ers3_log.xmlf_creation_flux_dt, t_xml_file_ers3_log.ret_cdn, t_xml_file_ers3_log.xmlf_contenu_xml, t_xml_file_ers3_log.xmlf_json, t_xml_file_ers3_log.xmlf_type_message, t_xml_file_ers3_log.xmlf_active
  • Index Cond: (t_xml_file_ers3_log.xmlf_cdn = t_journal_ers3.xmlf_cdn)
7. 25,948.274 25,948.274 ↓ 0.0 0 25,948,274

Index Scan using i_t_xml_file_ers3_sal_xmlf_cdn on ers3.t_xml_file_ers3_sal (cost=0.43..6.09 rows=1 width=30) (actual time=0.001..0.001 rows=0 loops=25,948,274)

  • Output: t_xml_file_ers3_sal.xmlf_flux_cdn, t_xml_file_ers3_sal.xmlf_cdn, t_xml_file_ers3_sal.xmlf_file_name_lb, t_xml_file_ers3_sal.xmlf_on_lb, t_xml_file_ers3_sal.xmlf_creation_dt, t_xml_file_ers3_sal.xmlf_contenu_txt, t_xml_file_ers3_sal.xmlf_datesys_dt, t_xml_file_ers3_sal.xmlf_creation_flux_dt, t_xml_file_ers3_sal.ret_cdn, t_xml_file_ers3_sal.xmlf_contenu_xml, t_xml_file_ers3_sal.xmlf_json, t_xml_file_ers3_sal.xmlf_type_message, t_xml_file_ers3_sal.xmlf_active
  • Index Cond: (t_xml_file_ers3_sal.xmlf_cdn = t_journal_ers3.xmlf_cdn)
8. 25,948.274 25,948.274 ↓ 0.0 0 25,948,274

Index Scan using i_t_xml_file_ers3_autre_xmlf_cdn on ers3.t_xml_file_ers3_autre (cost=0.43..6.08 rows=1 width=34) (actual time=0.001..0.001 rows=0 loops=25,948,274)

  • Output: t_xml_file_ers3_autre.xmlf_flux_cdn, t_xml_file_ers3_autre.xmlf_cdn, t_xml_file_ers3_autre.xmlf_file_name_lb, t_xml_file_ers3_autre.xmlf_on_lb, t_xml_file_ers3_autre.xmlf_creation_dt, t_xml_file_ers3_autre.xmlf_contenu_txt, t_xml_file_ers3_autre.xmlf_datesys_dt, t_xml_file_ers3_autre.xmlf_creation_flux_dt, t_xml_file_ers3_autre.ret_cdn, t_xml_file_ers3_autre.xmlf_contenu_xml, t_xml_file_ers3_autre.xmlf_json, t_xml_file_ers3_autre.xmlf_type_message, t_xml_file_ers3_autre.xmlf_active
  • Index Cond: (t_xml_file_ers3_autre.xmlf_cdn = t_journal_ers3.xmlf_cdn)
Planning time : 252.192 ms
Execution time : 229,017.372 ms