Changeset View
Changeset View
Standalone View
Standalone View
swh/scheduler/sql/60-indexes.sql
Show All 11 Lines | |||||
create index task_run_id_asc_idx on task_run(task asc, started asc); | create index task_run_id_asc_idx on task_run(task asc, started asc); | ||||
-- lister schema | -- lister schema | ||||
create unique index on listers (name, instance_name); | create unique index on listers (name, instance_name); | ||||
-- listed origins | -- listed origins | ||||
create index on listed_origins (url); | create index on listed_origins (url); | ||||
create index on listed_origins (last_scheduled); |