explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wq8i : Optimization for: plan #9LcX

Settings

Optimization path:

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

Subquery Scan on q (cost=4,942.06..4,942.08 rows=1 width=48) (actual rows= loops=)

  • Filter: pg_try_advisory_lock(q.inboxid)
2. 0.000 0.000 ↓ 0.0

Limit (cost=4,942.06..4,942.07 rows=1 width=56) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=4,942.06..4,942.07 rows=1 width=56) (actual rows= loops=)

  • Sort Key: (row_number() OVER (?)), inbox.inboxtenantid
4. 0.000 0.000 ↓ 0.0

WindowAgg (cost=4,942.03..4,942.05 rows=1 width=56) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=4,942.03..4,942.04 rows=1 width=48) (actual rows= loops=)

  • Sort Key: inbox.inboxtenantid
6. 0.000 0.000 ↓ 0.0

Seq Scan on inbox (cost=12.51..4,942.02 rows=1 width=48) (actual rows= loops=)

  • Filter: ((inboxwasprocessed <> 1) AND (NOT (hashed SubPlan 1)) AND (upper((inboxtenantid)::text) = 'GFCDEVQACSIX_TST'::text))
  • -> Function Scan on pg_lock_status l (cost=0.00..12.50 rows=5 width=4)" Filter: (locktype = 'advisory'::text)