explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gTbt

Settings
# exclusive inclusive rows x rows loops node
1. 28,502.249 28,535.908 ↓ 0.0 0 1

Update on merge_requests (cost=0.56..4,750.97 rows=4,751 width=734) (actual time=28,535.908..28,535.908 rows=0 loops=1)

2. 33.659 33.659 ↓ 1.5 7,170 1

Index Scan using merge_requests_pkey on merge_requests (cost=0.56..4,750.97 rows=4,751 width=734) (actual time=0.027..33.659 rows=7,170 loops=1)

  • Index Cond: ((id >= 0) AND (id <= 10,000))
  • Filter: (lock_version IS NULL)
Planning time : 0.476 ms
Execution time : 28,536.037 ms