explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JR6b : Optimization for: plan #ctwL

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Insert on sedol_sec (cost=0.00..2,758,130.15 rows=16,851,649 width=1,885) (actual rows= loops=)

  • Conflict Resolution: UPDATE
  • Conflict Arbiter Indexes: sedol_sec_securityid_key
2. 0.000 0.000 ↓ 0.0

Seq Scan on sedol_sec_bulkdata stgfdcsedolsec (cost=0.00..2,758,130.15 rows=16,851,649 width=1,885) (actual rows= loops=)

  • Filter: (NOT isprocessed)