explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DQP

Settings
# exclusive inclusive rows x rows loops node
1. 441.360 87,277.059 ↑ 1.0 1 1

Aggregate (cost=34,245.32..34,245.33 rows=1 width=0) (actual time=87,277.058..87,277.059 rows=1 loops=1)

2. 86,387.550 86,835.699 ↓ 25.9 487,868 1

Bitmap Heap Scan on objects (cost=143.29..34,235.90 rows=18,839 width=0) (actual time=676.598..86,835.699 rows=487,868 loops=1)

  • Recheck Cond: (((id / 1000000) = 5) AND (date(updated_at) < (date(now()) - 7)))
3. 448.149 448.149 ↓ 25.9 487,868 1

Bitmap Index Scan on count_updated_at_ix_7 (cost=0.00..142.35 rows=18,839 width=0) (actual time=448.149..448.149 rows=487,868 loops=1)

  • Index Cond: (((id / 1000000) = 5) AND (date(updated_at) < (date(now()) - 7)))
Total runtime : 87,280.728 ms