explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4sCW

Settings
# exclusive inclusive rows x rows loops node
1. 0.048 0.049 ↓ 0.0 0 1

Insert on locks (cost=0.00..0.01 rows=1 width=1,040) (actual time=0.049..0.049 rows=0 loops=1)

  • Conflict Resolution: UPDATE
  • Conflict Arbiter Indexes: locks_pkey
  • Conflict Filter: (((locks.token)::text = 'test'::text) OR (locks.expiry < '2019-01-15 00:00:00'::timestamp without time zone))
  • Tuples Inserted: 0
  • Conflicting Tuples: 1
2. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=1,040) (actual time=0.001..0.001 rows=1 loops=1)