explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rpSDv

Settings
# exclusive inclusive rows x rows loops node
1. 333,452.416 333,452.461 ↓ 0.0 0 1

Update on alf_lock (cost=4.27..8.29 rows=1 width=144) (actual time=333,452.461..333,452.461 rows=0 loops=1)

2. 0.030 0.045 ↑ 1.0 1 1

Bitmap Heap Scan on alf_lock (cost=4.27..8.29 rows=1 width=144) (actual time=0.036..0.045 rows=1 loops=1)

  • Recheck Cond: (excl_resource_id = '7'::bigint)
  • Filter: ((lock_token)::text = '2e6c8ffc-5272-4305-924a-4b1c9b89667f'::text)
  • Heap Blocks: exact=1
3. 0.015 0.015 ↑ 1.0 1 1

Bitmap Index Scan on fk_alf_lock_excl (cost=0.00..4.27 rows=1 width=0) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (excl_resource_id = '7'::bigint)