explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CCHE

Settings
# exclusive inclusive rows x rows loops node
1. 2,244,934.765 2,247,532.608 ↓ 0.0 0 1

Insert on own_fund_hist_unadjusted_snapshot t (cost=0.00..120,595.09 rows=5,384,709 width=50) (actual time=2,247,532.608..2,247,532.608 rows=0 loops=1)

  • Conflict Resolution: UPDATE
  • Conflict Arbiter Indexes: pk_own_fund_hist_unadjusted_snapshot_869630191
  • Conflict Filter: ((t.as_of_date <> excluded.as_of_date) OR (COALESCE(t."position", '-1'::numeric) <> COALESCE(excluded."position", '-1'::numeric)) OR (COALESCE(t.inst_id, '0'::numeric) <> COALESCE(excluded.inst_id, '0'::numeric)) OR (COALESCE(t.market_value, '0'::numeric) <> COALESCE(excluded.market_value, '0'::numeric)))
  • Rows Removed by Conflict Filter: 5384689
  • Tuples Inserted: 0
  • Conflicting Tuples: 5384689
2. 2,597.843 2,597.843 ↑ 1.0 5,384,689 1

Seq Scan on own_fund_hist_unadjusted_fi_snapshot_stage s (cost=0.00..120,595.09 rows=5,384,709 width=50) (actual time=0.737..2,597.843 rows=5,384,689 loops=1)

Planning time : 9.047 ms
Execution time : 2,247,540.815 ms