Differential D4881 Diff 17370 swh/scheduler/sql/60-indexes.sql

Changeset View

Standalone View

	Show All 10 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, visit_type);
	create index on listed_origins (visit_type, last_scheduled);
				-- visit stats
				create index on origin_visit_stats (url, visit_type);
				-- XXX probably add indexes on most (visit_type, last_xxx) couples