explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 16,781.124 ↑ 1.0 1 1

Finalize Aggregate (cost=3,529,670.42..3,529,670.43 rows=1 width=8) (actual time=16,781.124..16,781.124 rows=1 loops=1)

2. 48.300 16,817.557 ↑ 2.0 8 1

Gather (cost=3,529,668.77..3,529,670.38 rows=16 width=8) (actual time=16,780.992..16,817.557 rows=8 loops=1)

  • Workers Planned: 16
  • Workers Launched: 7
3. 20.504 16,769.257 ↑ 1.0 1 8

Partial Aggregate (cost=3,528,668.77..3,528,668.78 rows=1 width=8) (actual time=16,769.257..16,769.257 rows=1 loops=8)

4. 16,748.753 16,748.753 ↓ 1.6 281,250 8

Parallel Seq Scan on event_series (cost=0.00..3,528,233.75 rows=174,007 width=0) (actual time=7,959.827..16,748.753 rows=281,250 loops=8)

  • Filter: ((created_at < '2018-03-01 00:00:00'::timestamp without time zone) AND (key = 'health'::text))
  • Rows Removed by Filter: 6281250
Planning time : 0.144 ms
Execution time : 16,817.614 ms