explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eSrZ : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #mFlR; plan #S1xk; plan #d7Ti; plan #l42o; plan #Fx68

Settings

Optimization path:

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

Finalize Aggregate (cost=946,926.02..946,926.03 rows=1 width=32) (actual time=1,368.321..1,368.321 rows=1 loops=1)

2. 51.391 1,412.396 ↓ 1.2 5 1

Gather (cost=946,925.58..946,925.99 rows=4 width=32) (actual time=1,368.278..1,412.396 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 14.024 1,361.005 ↑ 1.0 1 5

Partial Aggregate (cost=945,925.58..945,925.59 rows=1 width=32) (actual time=1,361.004..1,361.005 rows=1 loops=5)

4. 1,346.981 1,346.981 ↓ 22.1 30,000 5

Parallel Index Scan using event_series_created_rkey on event_series es (cost=0.56..945,912.00 rows=1,358 width=30) (actual time=0.216..1,346.981 rows=30,000 loops=5)

  • Index Cond: (key = 'arr'::text)
  • Filter: ('2018-07-12 00:00:00+00'::timestamp with time zone <@ valid)
  • Rows Removed by Filter: 5220000
Planning time : 0.175 ms
Execution time : 1,412.465 ms