explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3xHs

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 11.289 ↑ 1.0 1 1

Aggregate (cost=1,718.13..1,718.14 rows=1 width=32) (actual time=11.288..11.289 rows=1 loops=1)

2. 11.270 11.270 ↑ 1,057.0 1 1

Index Scan using slpvalue_view_slpid_idx on slpvalue_view v (cost=0.42..1,715.49 rows=1,057 width=12) (actual time=8.392..11.270 rows=1 loops=1)

  • Index Cond: ((slpid)::text = 'S11'::text)
  • Filter: ((fromdate >= '2019-01-01'::date) AND (todate <= '2019-01-02'::date) AND (status = 'ACTUAL'::text) AND (nature = 'EFFECTIVE_PROFILE'::text) AND ((timeframe)::text = 'LOW'::text))
  • Rows Removed by Filter: 17,531
Planning time : 0.311 ms