explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rMY2 : 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.001 0.033 ↑ 1.0 1 1

Limit (cost=0.42..0.54 rows=1 width=375) (actual time=0.032..0.033 rows=1 loops=1)

2. 0.009 0.032 ↑ 851,617.0 1 1

LockRows (cost=0.42..98,799.59 rows=851,617 width=375) (actual time=0.031..0.032 rows=1 loops=1)

3. 0.023 0.023 ↑ 851,617.0 1 1

Index Scan using idx_urlqueue_completed on urlqueue (cost=0.42..90,283.42 rows=851,617 width=375) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: (completed = false)
  • Filter: (NOT completed)
Planning time : 0.111 ms
Execution time : 0.054 ms