db: add index ON explicit_permissions_bitbucket_projects_jobs (project_key, external_service_id, state)

Review changes
Download
Patches
Plain diff

Merged db: add index ON explicit_permissions_bitbucket_projects_jobs (project_key, external_service_id, state)

Overview 1
Commits 1
Pipelines 0
Changes 6

Merged Warren Gifford requested to merge as/add-index into main 3 years ago

Overview 1
Commits 1
Pipelines 0
Changes 6

Created by: asdine

We add an index to speed up the duplication of jobs when adding a new job for the same couple project key / code host id. The index can also be used to query jobs by project key in the list API

Test plan

sg migration up and undo

Merge request reports

Activity

Filter activity

Approvals
Assignees & reviewers
Comments (from bots)
Comments (from users)
Commits & branches
Edits
Labels
Lock status
Mentions
Merge request status
Tracking

Please register or sign in to reply

0 Assignees

None

Select assignees

0 Reviewers

None

Request review from

Labels

bitbucket-project-permissions cla-signed team/repo-management

Select labels

Manage project labels

Milestone

None

Time tracking

No estimate or time spent

Participants

There are currently no pipelines.

To run a merge request pipeline, the jobs in the CI/CD configuration file must be configured to run in merge request pipelines and you must have sufficient permissions in the source project.