explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SpAQ : Optimization for: plan #E0W

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.512 3.811 ↑ 1.0 1 1

Aggregate (cost=1,907.63..1,907.64 rows=1 width=8) (actual time=3.811..3.811 rows=1 loops=1)

2. 2.299 2.299 ↓ 1.0 5,341 1

Index Scan using unique_rsg_capacity_230 on rsg_capacity_230 cap (cost=0.42..1,881.96 rows=5,135 width=8) (actual time=0.012..2.299 rows=5,341 loops=1)

  • Index Cond: ((station_id = 230) AND (break_date >= '2019-02-01'::date) AND (break_date <= '2019-02-28'::date))