explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 23TP : Optimization for: Optimization for: Optimization for: plan #79d4; plan #0jT3; plan #KPAq

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 172.644 528,067.257 ↑ 1.0 1 1

Aggregate (cost=643,096.64..643,096.65 rows=1 width=8) (actual time=528,067.256..528,067.257 rows=1 loops=1)

2. 101.324 527,894.613 ↑ 1.1 150,000 1

Append (cost=0.55..642,698.45 rows=159,276 width=0) (actual time=0.379..527,894.613 rows=150,000 loops=1)

3. 527,793.289 527,793.289 ↑ 1.1 150,000 1

Index Scan using event_series_created_on_key_1 on event_series_partitioned_customer_1 (cost=0.55..641,902.07 rows=159,276 width=0) (actual time=0.378..527,793.289 rows=150,000 loops=1)

  • Index Cond: (CURRENT_TIMESTAMP <@ valid)
  • Filter: (customer_id = '1'::text)
Planning time : 0.555 ms
Execution time : 528,067.303 ms