explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Mby

Settings
# exclusive inclusive rows x rows loops node
1. 308,928.504 309,830.015 ↓ 0.0 0 1

Insert on own_fund_hist_unadjusted_snapshot t (cost=0.00..99,300.01 rows=4,148,201 width=63) (actual time=309,830.015..309,830.015 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: 4144447
  • Tuples Inserted: 0
  • Conflicting Tuples: 4144447
2. 901.511 901.511 ↑ 1.0 4,144,447 1

Seq Scan on own_fund_hist_unadjusted_nonfi_snapshot_stage (cost=0.00..99,300.01 rows=4,148,201 width=63) (actual time=0.007..901.511 rows=4,144,447 loops=1)

Planning time : 0.093 ms
Execution time : 309,836.098 ms