explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UmKt

Settings
# exclusive inclusive rows x rows loops node
1. 0.144 125.336 ↓ 1,000.0 1,000 1

Limit (cost=548.54..548.54 rows=1 width=245) (actual time=125.007..125.336 rows=1,000 loops=1)

2. 13.965 125.192 ↓ 16.1 2,000 1

Sort (cost=548.23..548.54 rows=124 width=245) (actual time=123.497..125.192 rows=2,000 loops=1)

  • Sort Key: delivery_date DESC
  • Sort Method: top-N heapsort Memory: 1001kB
3. 111.227 111.227 ↓ 210.1 26,055 1

Index Scan using idx_best_of_forecasts_curated_test on forecasts_curated (cost=0.56..543.92 rows=124 width=245) (actual time=0.090..111.227 rows=26,055 loops=1)

  • Index Cond: ((curve_id = ANY ('{1,2,3,4,5,6,7,8,9,10,100}'::bigint[])) AND (delivery_date >= '2019-01-10 00:00:00'::timestamp without time zone) AND (delivery_date <= '2019-12-20 23:00:00'::timestamp without time zone) AND (valid_from <= now()) AND (valid_to >= now()))
Planning time : 0.211 ms
Execution time : 125.543 ms