explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EHi4 : Optimization for: Optimization for: plan #lVOd; plan #otH6

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 50.764 338.537 ↑ 1.0 1 1

Aggregate (cost=2,759,234.92..2,759,234.93 rows=1 width=8) (actual time=338.536..338.537 rows=1 loops=1)

2. 129.737 287.773 ↑ 1.2 1,200,000 1

Bitmap Heap Scan on event_series (cost=56,460.73..2,755,631.57 rows=1,441,338 width=0) (actual time=185.866..287.773 rows=1,200,000 loops=1)

  • Recheck Cond: ((created_at < '2018-02-01 00:00:00'::timestamp without time zone) AND (key = 'health'::text))
  • Heap Blocks: exact=165144
3. 158.036 158.036 ↑ 1.2 1,200,000 1

Bitmap Index Scan on foobars4 (cost=0.00..56,100.40 rows=1,441,338 width=0) (actual time=158.036..158.036 rows=1,200,000 loops=1)

  • Index Cond: ((created_at < '2018-02-01 00:00:00'::timestamp without time zone) AND (key = 'health'::text))
Planning time : 0.137 ms
Execution time : 338.577 ms