AnkeshThakur commented on issue #8361: URL: https://github.com/apache/incubator-devlake/issues/8361#issuecomment-2754859599
Overall time is reduced from 10 hours to 5 hours. And the Dora step's time is reduced from ~9 hours to ~4 hours. I have not identified the index that performed best. I need to observe it more. But I had added these indexes: ``` CREATE INDEX idx_cicd_deployment_commits_prev_success_deployment_commit_id ON cicd_deployment_commits(prev_success_deployment_commit_id); CREATE INDEX idx_cicd_deployment_commits_environment ON cicd_deployment_commits(environment); CREATE INDEX idx_commits_diffs_new_commit_sha ON commits_diffs(new_commit_sha); CREATE INDEX idx_commits_diffs_old_commit_sha ON commits_diffs(old_commit_sha); CREATE INDEX idx_cicd_deployment_commits_commit_sha ON cicd_deployment_commits(commit_sha); CREATE INDEX idx_cicd_deployment_commits_result ON cicd_deployment_commits(RESULT); CREATE INDEX idx_commits_diffs_composite ON commits_diffs (new_commit_sha, old_commit_sha); ``` My hunch is that it is idx_commits_diffs_composite but I am not certain. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@devlake.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
