No OneTemporary
Actions

Size

937 B

Subscribers

None

View Options

	diff --git a/swh/scheduler/sql/60-indexes.sql b/swh/scheduler/sql/60-indexes.sql
	index cbe8642..8361dc8 100644
	--- a/swh/scheduler/sql/60-indexes.sql
	+++ b/swh/scheduler/sql/60-indexes.sql
	@@ -1,23 +1,26 @@
	create index on task(type);
	create index on task(next_run);

	-- used for quick equality checking
	create index on task using btree(type, md5(arguments::text));

	create index on task(priority);

	create index on task_run(task);
	create index on task_run(backend_id);

	create index task_run_id_asc_idx on task_run(task asc, started asc);

	+create index on task(type, next_run)
	+where status = 'next_run_not_scheduled'::task_status;
	+

	-- lister schema
	create unique index on listers (name, instance_name);

	-- listed origins
	create index on listed_origins (url, visit_type);

	-- visit stats
	create index on origin_visit_stats (url, visit_type);
	-- XXX probably add indexes on most (visit_type, last_xxx) couples