explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e6Rx

Settings
# exclusive inclusive rows x rows loops node
1. 2,628.534 3,430.321 ↓ 0.0 0 1

Update on ci_stages (cost=0.57..124.91 rows=70 width=53) (actual time=3,430.321..3,430.321 rows=0 loops=1)

2. 801.787 801.787 ↓ 14.3 1,001 1

Index Scan using ci_stages_pkey on ci_stages (cost=0.57..124.91 rows=70 width=53) (actual time=2.603..801.787 rows=1,001 loops=1)

  • Index Cond: ((id >= 10000) AND (id <= 11000))
  • Filter: (lock_version IS NULL)
Planning time : 104.382 ms
Execution time : 3,430.378 ms