explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7ZAy : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #79d4; plan #0jT3; plan #KPAq; plan #23TP; plan #9EN8; plan #qPS; plan #vblG

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.679 136.925 ↑ 1.0 15,000 1

Limit (cost=0.55..59,489.73 rows=15,000 width=78) (actual time=0.289..136.925 rows=15,000 loops=1)

2. 135.246 135.246 ↑ 9.9 15,000 1

Index Scan using event_series_created_on_key_1 on event_series_partitioned_customer_1 (cost=0.55..591,723.57 rows=149,201 width=78) (actual time=0.288..135.246 rows=15,000 loops=1)

  • Index Cond: (CURRENT_TIMESTAMP <@ valid)
Planning time : 0.133 ms
Execution time : 137.798 ms