explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g9oD

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 80,524.662 ↓ 0.0 0 1

Limit (cost=2,629,503.63..2,629,503.67 rows=1 width=849) (actual time=80,524.662..80,524.662 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, ('FA'::text)
2. 0.002 80,524.659 ↓ 0.0 0 1

Unique (cost=2,629,503.63..2,631,289.68 rows=79,380 width=186) (actual time=80,524.659..80,524.659 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, ('FA'::text)
3. 0.027 80,524.657 ↓ 0.0 0 1

Sort (cost=2,629,503.63..2,629,702.08 rows=79,380 width=186) (actual time=80,524.657..80,524.657 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, ('FA'::text)
  • Sort Key: xmlf_cdn, xmlf_file_name_lb, jou_cdn, jou_cle_lb, jou_creation_dt, jou_alerte_bl, jou_msg_lb, ('FA'::text)
  • Sort Method: quicksort Memory: 25kB
4. 0.005 80,524.630 ↓ 0.0 0 1

Append (cost=0.00..2,616,761.50 rows=79,380 width=186) (actual time=80,524.630..80,524.630 rows=0 loops=1)

5. 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, 'FA'::text
  • One-Time Filter: false
6. 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
7. 0.009 80,524.623 ↓ 0.0 0 1

Hash Join (cost=564,048.79..2,615,967.68 rows=79,378 width=186) (actual time=80,524.623..80,524.623 rows=0 loops=1)

  • Output: t_xml_file_ers3_autre.xmlf_cdn, 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_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.xmlf_cdn = t_xml_file_ers3_autre.xmlf_cdn)
8. 0.010 0.010 ↑ 42,106,788.0 1 1

Seq Scan on ers3.t_journal_ers3 (cost=0.00..1,471,759.88 rows=42,106,788 width=160) (actual time=0.010..0.010 rows=1 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
9. 0.003 80,524.604 ↓ 0.0 0 1

Hash (cost=563,818.08..563,818.08 rows=18,457 width=34) (actual time=80,524.604..80,524.604 rows=0 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: 0kB
10. 80,524.601 80,524.601 ↓ 0.0 0 1

Seq Scan on ers3.t_xml_file_ers3_autre (cost=0.00..563,818.08 rows=18,457 width=34) (actual time=80,524.601..80,524.601 rows=0 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 = 'QUE_SAL'::text)
  • Rows Removed by Filter: 3691151
Planning time : 0.872 ms
Execution time : 80,537.124 ms