explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eL44 : Insert On Conflict Update

Settings
# exclusive inclusive rows x rows loops node
1. 0.525 0.587 ↑ 1.0 1 1

Insert on bravo (cost=0.00..0.02 rows=1 width=620) (actual time=0.585..0.587 rows=1 loops=1)

  • Conflict Resolution: UPDATE
  • Conflict Arbiter Indexes: activity_pkey
  • Conflict Filter: (activity.updated_at < excluded.updated_at)
  • Tuples Inserted: 0
  • Conflicting Tuples: 1
  • Buffers: shared hit=28 dirtied=5
2. 0.062 0.062 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=620) (actual time=0.062..0.062 rows=1 loops=1)

  • Buffers: shared hit=1
Planning time : 0.212 ms
Execution time : 0.683 ms