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

Generated by Ricardo Wurmus using scpaste at Tue Jan 2 13:02:48 2024. CET. (original)