explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hpXe

Settings
# exclusive inclusive rows x rows loops node
1. 0.154 1.000 ↑ 1.0 1 1

Aggregate (cost=120.77..120.78 rows=1 width=32) (actual time=1.000..1.000 rows=1 loops=1)

2. 0.846 0.846 ↓ 3.8 365 1

Index Scan using slpvalue_view_big_idx on slpvalue_view v (cost=0.42..120.53 rows=95 width=12) (actual time=0.380..0.846 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) AND (nature = 'EFFECTIVE_PROFILE'::text))
Planning time : 0.333 ms
Execution time : 1.050 ms