#	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

Limit  (cost=0.55..5947.70 rows=1500 width=78) (actual time=0.230..16.997 rows=1500 loops=1)
  ->  Index Scan using event_series_created_on_key_1 on event_series_partitioned_customer_1  (cost=0.55..598156.74 rows=150868 width=78) (actual time=0.229..16.856 rows=1500 loops=1)
        Index Cond: (CURRENT_TIMESTAMP <@ valid)
Planning Time: 0.091 ms
Execution Time: 17.089 ms

Per node type stats

node type	count	sum of times	% of query
Index Scan	1	16.856 ms	99.2 %
Limit	1	0.141 ms	0.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
event_series_partitioned_customer_1	1	16.856 ms	99.2 %
Index Scan	1	16.856 ms	100.0 %

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

Color mode:

Visible columns:

Optimization path:

Optimization(s) for this plan:

Per node type stats

Per table stats