explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4u59 : Optimization for: 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; plan #7ZAy

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 10.646 45,031.512 ↑ 1.0 50,000 1

Limit (cost=0.55..198,313.07 rows=50,000 width=78) (actual time=0.322..45,031.512 rows=50,000 loops=1)

2. 45,020.866 45,020.866 ↑ 3.0 50,000 1

Index Scan using event_series_created_on_key_1 on event_series_partitioned_customer_1 (cost=0.55..590,027.89 rows=148,762 width=78) (actual time=0.321..45,020.866 rows=50,000 loops=1)

  • Index Cond: (CURRENT_TIMESTAMP <@ valid)
Planning time : 0.120 ms
Execution time : 45,038.005 ms