explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tqIP

Settings
# exclusive inclusive rows x rows loops node
1. 505.332 2,022.284 ↓ 0.0 0 1

Update on epics (cost=0.29..3,102.81 rows=1,570 width=788) (actual time=2,022.284..2,022.284 rows=0 loops=1)

2. 1,516.952 1,516.952 ↓ 1.7 2,678 1

Index Scan using epics_pkey on epics (cost=0.29..3,102.81 rows=1,570 width=788) (actual time=12.630..1,516.952 rows=2,678 loops=1)

  • Index Cond: ((id >= 0) AND (id <= 10000))
  • Filter: (lock_version IS NULL)
  • Rows Removed by Filter: 5869
Planning time : 216.156 ms
Execution time : 2,022.512 ms