Differential D4855 Diff 17186 swh/scheduler/sql/60-indexes.sql

Changeset View

Standalone View

	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);			create index on listed_origins (visit_type, last_scheduled);