explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JdVQ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 721,720.639 ↑ 1.0 1 1

Limit (cost=11,623,364.05..11,623,364.09 rows=1 width=849) (actual time=721,720.637..721,720.639 rows=1 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)
2. 0.003 721,720.635 ↑ 15,955,042.0 1 1

Unique (cost=11,623,364.05..11,982,352.50 rows=15,955,042 width=200) (actual time=721,720.635..721,720.635 rows=1 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)
3. 12,098.023 721,720.632 ↑ 15,955,042.0 1 1

Sort (cost=11,623,364.05..11,663,251.66 rows=15,955,042 width=200) (actual time=721,720.632..721,720.632 rows=1 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)
  • Sort 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)
  • Sort Method: external merge Disk: 286568kB
4. 2,033.165 709,622.609 ↑ 13.1 1,220,368 1

Append (cost=264,248.53..7,096,915.99 rows=15,955,042 width=200) (actual time=185,511.857..709,622.609 rows=1,220,368 loops=1)

5. 102,750.695 356,154.690 ↑ 13.0 1,220,356 1

Hash Join (cost=264,248.53..4,321,397.89 rows=15,875,663 width=200) (actual time=185,511.856..356,154.690 rows=1,220,356 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
  • Hash Cond: (t_journal_ers3.xmlf_cdn = t_xml_file_ers3_log.xmlf_cdn)
6. 208,028.604 208,028.604 ↑ 1.0 41,986,180 1

Seq Scan on ers3.t_journal_ers3 (cost=0.00..1,471,759.88 rows=42,106,788 width=160) (actual time=0.009..208,028.604 rows=41,986,180 loops=1)

  • Output: 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_journal_ers3.xmlf_cdn
7. 1,554.595 45,375.391 ↓ 1.0 999,424 1

Hash (cost=242,976.79..242,976.79 rows=999,179 width=48) (actual time=45,375.391..45,375.391 rows=999,424 loops=1)

  • Output: t_xml_file_ers3_log.xmlf_cdn, t_xml_file_ers3_log.xmlf_file_name_lb
  • Buckets: 8192 Batches: 16 Memory Usage: 4969kB
8. 43,820.796 43,820.796 ↓ 1.0 999,424 1

Seq Scan on ers3.t_xml_file_ers3_log (cost=0.00..242,976.79 rows=999,179 width=48) (actual time=0.004..43,820.796 rows=999,424 loops=1)

  • Output: t_xml_file_ers3_log.xmlf_cdn, t_xml_file_ers3_log.xmlf_file_name_lb
9. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: xmlf_cdn, xmlf_file_name_lb, jou_cdn, jou_cle_lb, jou_creation_dt, jou_alerte_bl, jou_msg_lb, 'SN'::text
  • One-Time Filter: false
10. 55,221.327 351,434.753 ↑ 6,614.8 12 1

Hash Join (cost=564,048.79..2,615,967.68 rows=79,378 width=186) (actual time=260,621.902..351,434.753 rows=12 loops=1)

  • Output: t_xml_file_ers3_autre.xmlf_cdn, t_xml_file_ers3_autre.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, 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
  • Hash Cond: (t_journal_ers3_1.xmlf_cdn = t_xml_file_ers3_autre.xmlf_cdn)
11. 206,868.001 206,868.001 ↑ 1.0 41,986,180 1

Seq Scan on ers3.t_journal_ers3 t_journal_ers3_1 (cost=0.00..1,471,759.88 rows=42,106,788 width=160) (actual time=0.009..206,868.001 rows=41,986,180 loops=1)

  • 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
12. 78.642 89,345.425 ↓ 2.6 47,163 1

Hash (cost=563,818.08..563,818.08 rows=18,457 width=34) (actual time=89,345.425..89,345.425 rows=47,163 loops=1)

  • Output: t_xml_file_ers3_autre.xmlf_cdn, t_xml_file_ers3_autre.xmlf_file_name_lb, t_xml_file_ers3_autre.xmlf_type_message
  • Buckets: 2048 Batches: 1 Memory Usage: 3040kB
13. 89,266.783 89,266.783 ↓ 2.6 47,163 1

Seq Scan on ers3.t_xml_file_ers3_autre (cost=0.00..563,818.08 rows=18,457 width=34) (actual time=186.013..89,266.783 rows=47,163 loops=1)

  • Output: t_xml_file_ers3_autre.xmlf_cdn, t_xml_file_ers3_autre.xmlf_file_name_lb, t_xml_file_ers3_autre.xmlf_type_message
  • Filter: (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 = 'FA'::text)
  • Rows Removed by Filter: 3643988
Planning time : 1.155 ms
Execution time : 721,734.587 ms