explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gvO3

Settings
# exclusive inclusive rows x rows loops node
1. 86.492 429.351 ↑ 3.4 21 1

GroupAggregate (cost=53,171.30..54,061.60 rows=72 width=10) (actual time=299.461..429.351 rows=21 loops=1)

  • Group Key: year, ((date_part('quarter'::text, (to_date((month)::text, 'MM'::text))::timestamp without time zone))::integer)
2. 126.810 342.859 ↓ 2.3 205,382 1

Sort (cost=53,171.30..53,393.38 rows=88,832 width=10) (actual time=299.010..342.859 rows=205,382 loops=1)

  • Sort Key: year, ((date_part('quarter'::text, (to_date((month)::text, 'MM'::text))::timestamp without time zone))::integer)
  • Sort Method: quicksort Memory: 15772kB
3. 216.049 216.049 ↓ 2.3 205,382 1

Index Scan using cm_cityid_datetime on calendar_metric_properties (cost=0.57..45,869.85 rows=88,832 width=10) (actual time=0.035..216.049 rows=205,382 loops=1)

  • Index Cond: ((city_id = 59380) AND (make_date((year)::integer, (month)::integer, 1) <= '2019-06-01'::date))
Planning time : 0.241 ms
Execution time : 430.966 ms