explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5cqY : Optimization for: plan #JdVQ

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2.156 9.938 ↑ 1.1 787 1

Hash Left Join (cost=129.78..194.56 rows=890 width=250) (actual time=2.299..9.938 rows=787 loops=1)

  • Hash Cond: (t_journal_ers3.xmlf_cdn = t_xml_file_ers3_autre.xmlf_cdn)
  • 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: 103
2. 2.039 6.551 ↑ 1.0 890 1

Hash Left Join (cost=65.39..115.71 rows=890 width=224) (actual time=1.039..6.551 rows=890 loops=1)

  • Hash Cond: (t_journal_ers3.xmlf_cdn = t_xml_file_ers3_sal.xmlf_cdn)
3. 2.339 4.403 ↑ 1.0 890 1

Hash Left Join (cost=56.80..102.89 rows=890 width=195) (actual time=0.918..4.403 rows=890 loops=1)

  • Hash Cond: (t_journal_ers3.xmlf_cdn = t_xml_file_ers3_log.xmlf_cdn)
4. 1.226 1.226 ↑ 1.0 890 1

Seq Scan on t_journal_ers3 (cost=0.00..36.90 rows=890 width=165) (actual time=0.061..1.226 rows=890 loops=1)

5. 0.271 0.838 ↑ 1.0 169 1

Hash (cost=54.69..54.69 rows=169 width=30) (actual time=0.838..0.838 rows=169 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
6. 0.567 0.567 ↑ 1.0 169 1

Seq Scan on t_xml_file_ers3_log (cost=0.00..54.69 rows=169 width=30) (actual time=0.007..0.567 rows=169 loops=1)

7. 0.036 0.109 ↑ 1.0 26 1

Hash (cost=8.26..8.26 rows=26 width=29) (actual time=0.109..0.109 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
8. 0.073 0.073 ↑ 1.0 26 1

Seq Scan on t_xml_file_ers3_sal (cost=0.00..8.26 rows=26 width=29) (actual time=0.011..0.073 rows=26 loops=1)

9. 0.424 1.231 ↑ 1.0 284 1

Hash (cost=60.84..60.84 rows=284 width=34) (actual time=1.231..1.231 rows=284 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
10. 0.807 0.807 ↑ 1.0 284 1

Seq Scan on t_xml_file_ers3_autre (cost=0.00..60.84 rows=284 width=34) (actual time=0.017..0.807 rows=284 loops=1)

Planning time : 1.017 ms