explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kZMP

Settings
# exclusive inclusive rows x rows loops node
1. 4,663.343 4,869.485 ↓ 0.0 0 1

Update on bo_instance (cost=464.64..64,556.39 rows=88 width=1,839) (actual time=4,869.484..4,869.485 rows=0 loops=1)

2. 200.855 206.142 ↓ 113.6 10,000 1

Bitmap Heap Scan on bo_instance (cost=464.64..64,556.39 rows=88 width=1,839) (actual time=5.811..206.142 rows=10,000 loops=1)

  • Recheck Cond: ((id >= 10000) AND (id <= 20000))
  • Filter: (tags IS NULL)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=4037
3. 5.287 5.287 ↓ 1.1 20,002 1

Bitmap Index Scan on bo_instance_pkey (cost=0.00..464.62 rows=17,619 width=0) (actual time=5.287..5.287 rows=20,002 loops=1)

  • Index Cond: ((id >= 10000) AND (id <= 20000))
Planning time : 0.151 ms
Execution time : 4,870.087 ms