CREATE INDEX builddependencies_target ON public.builddependencies USING btree (target);
CREATE INDEX buildproducts_build ON public.buildproducts USING btree (build);
CREATE INDEX builds_evaluation_index ON public.builds USING btree (evaluation, status);
CREATE INDEX builds_id_job_status_index ON public.builds USING btree (id DESC, job_name, status);
CREATE INDEX builds_job_name_timestamp ON public.builds USING btree (job_name, "timestamp");
CREATE INDEX builds_nix_name ON public.builds USING btree (nix_name);
CREATE INDEX builds_priority_timestamp ON public.builds USING btree (priority, "timestamp" DESC);
CREATE INDEX builds_status_index ON public.builds USING btree (status);
CREATE INDEX builds_status_ts_id ON public.builds USING btree (status DESC, "timestamp" DESC, id);
CREATE INDEX builds_stoptime ON public.builds USING btree (stoptime DESC);
CREATE INDEX builds_stoptime_id ON public.builds USING btree (stoptime DESC, id DESC);
CREATE INDEX builds_timestamp_stoptime ON public.builds USING btree ("timestamp", stoptime);
CREATE INDEX builds_weather_evaluation ON public.builds USING btree (weather, evaluation);
CREATE INDEX evaluations_specification_index ON public.evaluations USING btree (specification, id DESC);
CREATE INDEX evaluations_status_index ON public.evaluations USING btree (id, status);
CREATE INDEX jobs_build ON public.jobs USING btree (build);
CREATE INDEX jobs_name ON public.jobs USING btree (name);
CREATE INDEX jobs_system_status ON public.jobs USING btree (system, status);
CREATE INDEX notifications_build ON public.notifications USING btree (build);
CREATE INDEX outputs_derivation_index ON public.outputs USING btree (derivation);