explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lVOd

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 12.561 12,236.800 ↑ 1.0 1 1

Aggregate (cost=1,390,071.24..1,390,071.25 rows=1 width=8) (actual time=12,236.799..12,236.800 rows=1 loops=1)

2. 11,526.560 12,224.239 ↑ 1.7 300,000 1

Bitmap Heap Scan on event_series (cost=22,834.37..1,388,815.17 rows=502,428 width=0) (actual time=1,045.866..12,224.239 rows=300,000 loops=1)

  • Recheck Cond: (CURRENT_TIMESTAMP <@ valid)
  • Heap Blocks: exact=1387738
3. 697.679 697.679 ↓ 2.8 1,412,009 1

Bitmap Index Scan on event_series_created_created_at (cost=0.00..22,708.76 rows=502,428 width=0) (actual time=697.679..697.679 rows=1,412,009 loops=1)

  • Index Cond: (CURRENT_TIMESTAMP <@ valid)
Planning time : 0.136 ms
Execution time : 12,245.678 ms