explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oooY

Settings
# exclusive inclusive rows x rows loops node
1. 0.172 1.668 ↑ 1.0 1 1

Aggregate (cost=112.45..112.46 rows=1 width=32) (actual time=1.668..1.668 rows=1 loops=1)

2. 1.496 1.496 ↓ 3.8 365 1

Index Scan using slpvalue_view_big_idx on slpvalue_view v (cost=0.42..112.21 rows=95 width=12) (actual time=0.810..1.496 rows=365 loops=1)

  • Index Cond: (((slpid)::text = 'S41'::text) AND (fromdate >= '2019-01-01'::date) AND (todate <= '2020-01-01'::date) AND ((timeframe)::text = 'TOTAL_HOUR'::text) AND (status = 'ACTUAL'::text) AND ((market)::text = 'NG'::text) AND (gridoperator IS NULL) AND (netarea IS NULL) AND (simulation = false))
  • Filter: (nature = 'EFFECTIVE_PROFILE'::text)
Planning time : 0.664 ms
Execution time : 1.724 ms