explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.141 16.997 ↑ 1.0 1,500 1

Limit (cost=0.55..5,947.70 rows=1,500 width=78) (actual time=0.230..16.997 rows=1,500 loops=1)

2. 16.856 16.856 ↑ 100.6 1,500 1

Index Scan using event_series_created_on_key_1 on event_series_partitioned_customer_1 (cost=0.55..598,156.74 rows=150,868 width=78) (actual time=0.229..16.856 rows=1,500 loops=1)

  • Index Cond: (CURRENT_TIMESTAMP <@ valid)
Planning time : 0.091 ms
Execution time : 17.089 ms