explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KEHj

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.124 12.433 ↑ 1.0 1 1

Aggregate (cost=1,761.94..1,761.95 rows=1 width=32) (actual time=12.433..12.433 rows=1 loops=1)

2. 12.309 12.309 ↑ 2.2 365 1

Index Scan using slpvalue_view_slpid_idx on slpvalue_view v (cost=0.42..1,759.91 rows=810 width=12) (actual time=9.029..12.309 rows=365 loops=1)

  • Index Cond: ((slpid)::text = 'S11'::text)
  • Filter: ((NOT simulation) AND (gridoperator IS NULL) AND (netarea IS NULL) AND (fromdate >= '2019-01-01'::date) AND (todate <= '2020-01-01'::date) AND (status = 'ACTUAL'::text) AND (nature = 'EFFECTIVE_PROFILE'::text) AND ((timeframe)::text = 'LOW'::text) AND ((market)::text = 'EL'::text))
  • Rows Removed by Filter: 17,167
Planning time : 0.436 ms