explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7C38

Settings
# exclusive inclusive rows x rows loops node
1. 19,696.881 20,248.402 ↓ 0.0 0 1

Insert on detail_data (cost=4.57..6.57 rows=100 width=1,120) (actual time=20,248.402..20,248.402 rows=0 loops=1)

  • Conflict Resolution: UPDATE
  • Conflict Arbiter Indexes: pk_detail_key_business_date
  • Conflict Filter: ((detail_data.business_date = excluded.business_date) AND ((detail_data.tag)::text = (excluded.tag)::text))
  • Tuples Inserted: 8662
  • Conflicting Tuples: 0
  • Buffers: shared hit=306733 read=3365, temp read=1345 written=1344
  • I/O Timings: read=10503.501
2. 138.781 551.521 ↓ 86.6 8,662 1

Subquery Scan on *SELECT* (cost=4.57..6.57 rows=100 width=1,120) (actual time=385.970..551.521 rows=8,662 loops=1)

  • Buffers: shared hit=8662, temp read=1345 written=1344
3. 105.492 412.740 ↓ 86.6 8,662 1

Sort (cost=4.57..4.82 rows=100 width=1,116) (actual time=385.943..412.740 rows=8,662 loops=1)

  • Sort Key: d.key
  • Sort Method: external merge Disk: 5368kB
  • Buffers: temp read=1345 written=1344
4. 307.248 307.248 ↓ 86.6 8,662 1

Function Scan on jsonb_to_recordset d (cost=0.00..1.25 rows=100 width=1,116) (actual time=287.176..307.248 rows=8,662 loops=1)

  • Buffers: temp read=673 written=672