explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mp0G

Settings
# exclusive inclusive rows x rows loops node
1. 0.093 1.047 ↓ 2.9 50 1

Subquery Scan on q (cost=12.51..877.97 rows=17 width=48) (actual time=0.887..1.047 rows=50 loops=1)

  • Filter: pg_try_advisory_lock(q.inboxid)
2. 0.025 0.954 ↑ 1.0 50 1

Limit (cost=12.51..877.34 rows=50 width=48) (actual time=0.882..0.954 rows=50 loops=1)

3. 0.140 0.929 ↑ 5.7 50 1

Seq Scan on inbox (cost=12.51..4,942.02 rows=285 width=48) (actual time=0.880..0.929 rows=50 loops=1)

  • Filter: ((inboxwasprocessed = 1) AND (NOT (hashed SubPlan 1)) AND (upper((inboxtenantid)::text) = 'GFCDEVQACSIX_TST'::text))
  • Rows Removed by Filter: 53
4.          

SubPlan (for Seq Scan)

5. 0.789 0.789 ↓ 30.0 150 1

Function Scan on pg_lock_status l (cost=0.00..12.50 rows=5 width=4) (actual time=0.740..0.789 rows=150 loops=1)

  • Filter: (locktype = 'advisory'::text)
  • Rows Removed by Filter: 5
Planning time : 0.188 ms
Execution time : 1.108 ms