wehub-resource-sync
13 lines
874 B
SQL
13 lines
874 B
SQL
-- Indexes for the dashboard's filter/aggregation queries. Apply:
|
|
-- wrangler d1 execute reasonix-crash --remote --file=migrate-dashboard-indexes.sql
|
|
-- groups has no index but crashGroups filters/sorts by these columns every load;
|
|
-- the pings/metrics facets group by version and (signal,bucket) over a window.
|
|
CREATE INDEX IF NOT EXISTS groups_status ON groups (status);
|
|
CREATE INDEX IF NOT EXISTS groups_source ON groups (source);
|
|
CREATE INDEX IF NOT EXISTS groups_last_version ON groups (last_version);
|
|
CREATE INDEX IF NOT EXISTS groups_last_os ON groups (last_os);
|
|
CREATE INDEX IF NOT EXISTS groups_first_version ON groups (first_version);
|
|
CREATE INDEX IF NOT EXISTS pings_version ON pings (version);
|
|
CREATE INDEX IF NOT EXISTS metrics_signal_bucket ON metrics (signal, bucket);
|
|
CREATE INDEX IF NOT EXISTS metric_users_signal_bucket ON metric_users (signal, bucket);
|