explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l0JK

Settings
# exclusive inclusive rows x rows loops node
1. 0.081 1.142 ↑ 1.0 50 1

Subquery Scan on q (cost=12.51..877.97 rows=50 width=49) (actual time=0.994..1.142 rows=50 loops=1)

2. 0.024 1.061 ↑ 1.0 50 1

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

3. 0.182 1.037 ↑ 5.7 50 1

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

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

SubPlan (for Seq Scan)

5. 0.855 0.855 ↓ 40.0 200 1

Function Scan on pg_lock_status l (cost=0.00..12.50 rows=5 width=4) (actual time=0.787..0.855 rows=200 loops=1)

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