explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tShD

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.121 ↓ 0.0 0 1

HashAggregate (cost=4,731,213.77..4,731,241.10 rows=2,733 width=189) (actual time=0.121..0.121 rows=0 loops=1)

  • Output: t_xml_file_ers3_log.xmlf_cdn, t_xml_file_ers3_log.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, ('FA'::text)
  • Group Key: t_xml_file_ers3_log.xmlf_cdn, t_xml_file_ers3_log.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, ('FA'::text)
2. 0.005 0.110 ↓ 0.0 0 1

Append (cost=0.42..4,731,159.11 rows=2,733 width=189) (actual time=0.110..0.110 rows=0 loops=1)

3. 0.002 0.073 ↓ 0.0 0 1

Nested Loop (cost=0.42..1,577,042.40 rows=911 width=200) (actual time=0.073..0.073 rows=0 loops=1)

  • Output: t_xml_file_ers3_log.xmlf_cdn, t_xml_file_ers3_log.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, 'FA'::text
4. 0.071 0.071 ↓ 0.0 0 1

Index Scan using i_t_xml_file_ers3_log_xmlf_cdn on ers3.t_xml_file_ers3_log (cost=0.42..6.44 rows=1 width=48) (actual time=0.071..0.071 rows=0 loops=1)

  • 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 = 77)
5. 0.000 0.000 ↓ 0.0 0

Seq Scan on ers3.t_journal_ers3 (cost=0.00..1,577,026.85 rows=911 width=160) (never executed)

  • 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
  • Filter: (t_journal_ers3.xmlf_cdn = 77)
6. 0.002 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.43..1,577,042.41 rows=911 width=182) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: t_xml_file_ers3_sal.xmlf_cdn, t_xml_file_ers3_sal.xmlf_file_name_lb, t_journal_ers3_1.jou_cdn, t_journal_ers3_1.jou_cle_lb, t_journal_ers3_1.jou_creation_dt, t_journal_ers3_1.jou_alerte_bl, t_journal_ers3_1.jou_msg_lb, 'SN'::text
7. 0.014 0.014 ↓ 0.0 0 1

Index Scan using i_t_xml_file_ers3_sal_xmlf_cdn on ers3.t_xml_file_ers3_sal (cost=0.43..6.45 rows=1 width=30) (actual time=0.014..0.014 rows=0 loops=1)

  • 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 = 77)
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on ers3.t_journal_ers3 t_journal_ers3_1 (cost=0.00..1,577,026.85 rows=911 width=160) (never executed)

  • Output: t_journal_ers3_1.jou_cdn, t_journal_ers3_1.ops_cdn, t_journal_ers3_1.jou_msg_lb, t_journal_ers3_1.jou_creation_dt, t_journal_ers3_1.jou_type_lb, t_journal_ers3_1.jou_cle_lb, t_journal_ers3_1.jou_alerte_bl, t_journal_ers3_1.jou_traite_bl, t_journal_ers3_1.xmlf_cdn, t_journal_ers3_1.jou_code_trait_lb
  • Filter: (t_journal_ers3_1.xmlf_cdn = 77)
9. 0.002 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.43..1,577,046.96 rows=911 width=186) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: t_xml_file_ers3_autre.xmlf_cdn, t_xml_file_ers3_autre.xmlf_file_name_lb, t_journal_ers3_2.jou_cdn, t_journal_ers3_2.jou_cle_lb, t_journal_ers3_2.jou_creation_dt, t_journal_ers3_2.jou_alerte_bl, t_journal_ers3_2.jou_msg_lb, CASE WHEN (((t_xml_file_ers3_autre.xmlf_type_message)::text = 'QUE_SAL'::text) OR ((t_xml_file_ers3_autre.xmlf_type_message)::text = 'RSP'::text)) THEN 'FA'::text ELSE NULL::text END
10. 0.014 0.014 ↓ 0.0 0 1

Index Scan using i_t_xml_file_ers3_autre_xmlf_cdn on ers3.t_xml_file_ers3_autre (cost=0.43..6.45 rows=1 width=34) (actual time=0.014..0.014 rows=0 loops=1)

  • 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 = 77)
11. 0.000 0.000 ↓ 0.0 0

Seq Scan on ers3.t_journal_ers3 t_journal_ers3_2 (cost=0.00..1,577,026.85 rows=911 width=160) (never executed)

  • Output: t_journal_ers3_2.jou_cdn, t_journal_ers3_2.ops_cdn, t_journal_ers3_2.jou_msg_lb, t_journal_ers3_2.jou_creation_dt, t_journal_ers3_2.jou_type_lb, t_journal_ers3_2.jou_cle_lb, t_journal_ers3_2.jou_alerte_bl, t_journal_ers3_2.jou_traite_bl, t_journal_ers3_2.xmlf_cdn, t_journal_ers3_2.jou_code_trait_lb
  • Filter: (t_journal_ers3_2.xmlf_cdn = 77)
Planning time : 0.790 ms
Execution time : 0.327 ms