explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nLje

Settings
# exclusive inclusive rows x rows loops node
1. 19.466 1,668.458 ↓ 0.0 0 1

Nested Loop (cost=0.56..189,872.61 rows=96,102 width=23) (actual time=1,668.458..1,668.458 rows=0 loops=1)

2. 57.056 57.056 ↓ 1.0 99,496 1

Seq Scan on task_lock l (cost=0.00..1,983.95 rows=99,495 width=23) (actual time=0.033..57.056 rows=99,496 loops=1)

  • Filter: (user_code IS NOT NULL)
3. 1,591.936 1,591.936 ↓ 0.0 0 99,496

Index Scan using uk_task_code on task t (cost=0.56..1.89 rows=1 width=23) (actual time=0.016..0.016 rows=0 loops=99,496)

  • Index Cond: (code = l.code)
  • Filter: (task_status_code = 'done'::text)
  • Rows Removed by Filter: 1
Planning time : 0.984 ms
Execution time : 1,668.555 ms