explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yAHu

Settings
# exclusive inclusive rows x rows loops node
1. 1,204.035 1,856.774 ↓ 0.0 0 1

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

2. 652.739 652.739 ↓ 13.7 961 1

Index Scan using ci_stages_pkey on ci_stages (cost=0.57..124.91 rows=70 width=53) (actual time=0.057..652.739 rows=961 loops=1)

  • Index Cond: ((id >= 11,000) AND (id <= 12,000))
  • Filter: (lock_version IS NULL)
  • Rows Removed by Filter: 1
Planning time : 0.386 ms
Execution time : 1,856.817 ms