explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Ggy

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 4,567.389 ↑ 1.0 1 1

Aggregate (cost=8.39..8.40 rows=1 width=0) (actual time=4,567.389..4,567.389 rows=1 loops=1)

2. 2,888.182 4,567.385 ↓ 0.0 0 1

Bitmap Heap Scan on redis_updates (cost=4.38..8.39 rows=1 width=0) (actual time=4,567.385..4,567.385 rows=0 loops=1)

  • Heap Blocks: exact=282228
3. 1,679.203 1,679.203 ↓ 20,752,572.0 20,752,572 1

Bitmap Index Scan on redis_updates_pkey (cost=0.00..4.38 rows=1 width=0) (actual time=1,679.203..1,679.203 rows=20,752,572 loops=1)