hub/database/migrations/schema/052_package_views_year_mont...

6 lines
237 B
SQL

create index if not exists package_views_year_month_idx on package_views (date_trunc('year', day::timestamp), date_trunc('month', day::timestamp));
---- create above / drop below ----
drop index if exists package_views_year_month_idx;