explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hx8N

Settings
# exclusive inclusive rows x rows loops node
1. 1.431 9,516.114 ↑ 1.3 981 1

Merge Append (cost=0.58..2,329.09 rows=1,269 width=30) (actual time=15.734..9,516.114 rows=981 loops=1)

  • Sort Key: wdqmsapi_synopobservation_110.date
2. 9,514.683 9,514.683 ↑ 1.3 981 1

Index Scan using wdqmsapi_synopobservation_110_var_id_station_id_date_center_idx on wdqmsapi_synopobservation_110 (cost=0.57..2,316.39 rows=1,269 width=30) (actual time=15.730..9,514.683 rows=981 loops=1)

  • Index Cond: ((var_id = 110) AND (station_id = 7,162) AND (date >= '2020-03-21 18:00:00+00'::timestamp with time zone) AND (date <= '2020-04-21 18:00:00+00'::timestamp with time zone))
Planning time : 0.963 ms
Execution time : 9,517.046 ms