explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W8T8

Settings
# exclusive inclusive rows x rows loops node
1. 0.130 12.081 ↑ 1.0 1 1

Aggregate (cost=569.24..569.25 rows=1 width=32) (actual time=12.080..12.081 rows=1 loops=1)

2. 11.951 11.951 ↓ 3.8 365 1

Index Scan using slpvalue_view_slpid_idx on slpvalue_view v (cost=0.42..569.00 rows=95 width=12) (actual time=9.960..11.951 rows=365 loops=1)

  • Index Cond: ((slpid)::text = 'S41'::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 = 'TOTAL_HOUR'::text) AND ((market)::text = 'NG'::text))
  • Rows Removed by Filter: 5,480
Planning time : 0.382 ms
Execution time : 12.133 ms