explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pgFP : explain analyze SELECT id, referer, url, type FROM urlqueue WHERE NOT completed LIMIT 1 FOR UPDATE SKIP LOCKED;

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,119.709 ↑ 1.0 1 1

Limit (cost=0.00..0.36 rows=1 width=374) (actual time=1,119.708..1,119.709 rows=1 loops=1)

2. 13.876 1,119.707 ↑ 809,285.0 1 1

LockRows (cost=0.00..291,923.36 rows=809,285 width=374) (actual time=1,119.707..1,119.707 rows=1 loops=1)

3. 1,105.831 1,105.831 ↑ 14,451.5 56 1

Seq Scan on urlqueue (cost=0.00..283,830.51 rows=809,285 width=374) (actual time=0.968..1,105.831 rows=56 loops=1)

  • Filter: (NOT completed)
  • Rows Removed by Filter: 3596072
Planning time : 0.218 ms
Execution time : 1,119.730 ms