explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kEyS

Settings
# exclusive inclusive rows x rows loops node
1. 131,769.663 136,692.469 ↓ 0.0 0 1

Update on issues (cost=0.44..8,410.46 rows=4,275 width=805) (actual time=136,692.469..136,692.469 rows=0 loops=1)

2. 4,922.806 4,922.806 ↓ 1.6 6,762 1

Index Scan using issues_pkey on issues (cost=0.44..8,410.46 rows=4,275 width=805) (actual time=0.029..4,922.806 rows=6,762 loops=1)

  • Index Cond: ((id >= 0) AND (id <= 10000))
  • Filter: (lock_version IS NULL)
  • Rows Removed by Filter: 3
Planning time : 282.702 ms
Execution time : 136,692.614 ms