From 6d8f30ab0ae82678f10450d2158f24772f0c765c Mon Sep 17 00:00:00 2001 From: GitLab Bot Date: Fri, 14 Apr 2023 09:09:02 +0000 Subject: Add latest changes from gitlab-org/gitlab@master --- db/structure.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'db/structure.sql') diff --git a/db/structure.sql b/db/structure.sql index f74e15b2b9f..26d2a9c5787 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -32847,6 +32847,8 @@ CREATE INDEX tmp_idx_for_vulnerability_feedback_migration ON vulnerability_feedb CREATE INDEX tmp_idx_package_files_on_non_zero_size ON packages_package_files USING btree (package_id, size) WHERE (size IS NOT NULL); +CREATE INDEX tmp_idx_vulnerability_occurrences_on_id_where_report_type_7_99 ON vulnerability_occurrences USING btree (id) WHERE (report_type = ANY (ARRAY[7, 99])); + CREATE INDEX tmp_index_ci_job_artifacts_on_expire_at_where_locked_unknown ON ci_job_artifacts USING btree (expire_at, job_id) WHERE ((locked = 2) AND (expire_at IS NOT NULL)); CREATE INDEX tmp_index_ci_job_artifacts_on_id_expire_at_file_type_trace ON ci_job_artifacts USING btree (id) WHERE (((date_part('day'::text, timezone('UTC'::text, expire_at)) = ANY (ARRAY[(21)::double precision, (22)::double precision, (23)::double precision])) AND (date_part('minute'::text, timezone('UTC'::text, expire_at)) = ANY (ARRAY[(0)::double precision, (30)::double precision, (45)::double precision])) AND (date_part('second'::text, timezone('UTC'::text, expire_at)) = (0)::double precision)) OR (file_type = 3)); -- cgit v1.2.3