explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wFQp

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 9.012 6,238.440 ↓ 0.0 0 1

Insert on ct_co0122_1_past (cost=97,636.87..307,233.04 rows=1,617,805 width=133) (actual time=6,238.439..6,238.440 rows=0 loops=1)

2. 2,891.035 6,229.428 ↑ 470.8 3,436 1

Hash Semi Join (cost=97,636.87..307,233.04 rows=1,617,805 width=133) (actual time=2,512.718..6,229.428 rows=3,436 loops=1)

  • Hash Cond: (present.columnhash = bfc.columnhash)
  • Join Filter: ((bfc.amount <> present.amount) OR (bfc.convamount <> present.convamount) OR (bfc.consamount <> present.consamount) OR (bfc.data_comment <> present.data_comment))
  • Rows Removed by Join Filter: 1614412
3. 876.193 876.193 ↓ 1.0 1,617,848 1

Seq Scan on ct_co0122_1_present present (cost=0.00..57,068.05 rows=1,617,805 width=193) (actual time=0.009..876.193 rows=1,617,848 loops=1)

4. 1,270.086 2,462.200 ↓ 1.0 1,611,694 1

Hash (cost=53,881.83..53,881.83 rows=1,611,683 width=93) (actual time=2,462.199..2,462.200 rows=1,611,694 loops=1)

  • Buckets: 524288 Batches: 4 Memory Usage: 54660kB
5. 1,192.114 1,192.114 ↓ 1.0 1,611,694 1

Seq Scan on ct_co0122_1_hash bfc (cost=0.00..53,881.83 rows=1,611,683 width=93) (actual time=0.007..1,192.114 rows=1,611,694 loops=1)

Planning time : 0.422 ms
Execution time : 6,241.634 ms