Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Stream]每日凌晨上报活跃项目sql优化 #9869

Closed
randychen2046 opened this issue Dec 27, 2023 · 0 comments
Closed

[Stream]每日凌晨上报活跃项目sql优化 #9869

randychen2046 opened this issue Dec 27, 2023 · 0 comments
Assignees
@randychen2046
Labels
done Production environment in tencent has been deploy kind/enhancement 功能改进特性 streams/grayed stream 灰度环境测试通过

Comments

@randychen2046
Copy link
Collaborator

现状：
SELECT COUNT(DISTINCT devops_stream.T_GIT_REQUEST_EVENT_BUILD.GIT_PROJECT_ID) FROM devops_stream.T_GIT_REQUEST_EVENT_BUILD WHERE devops_stream.T_GIT_REQUEST_EVENT_BUILD.CREATE_TIME >= '2023-11-27 00:00:00.008' AND devops_stream.T_GIT_REQUEST_EVENT_BUILD.CREATE_TIME <= '2023-12-26 23:59:59.008' AND devops_stream.T_GIT_REQUEST_EVENT_BUILD.BUILD_ID IS NOT NULL AND devops_stream.T_GIT_REQUEST_EVENT_BUILD.PARSED_YAML LIKE '%v2.0%';

优化：
1、加索引：VERSION
2、sql改成 VERSION='v2.0'
@randychen2046 randychen2046 added the kind/enhancement 功能改进特性 label Dec 27, 2023
@randychen2046 randychen2046 self-assigned this Dec 27, 2023
randychen2046 added a commit to randychen2046/bk-ci that referenced this issue Dec 27, 2023
@randychen2046
[Stream]每日凌晨上报活跃项目sql优化 TencentBlueKing#9869
c00555f
bkci-bot added a commit that referenced this issue Jan 2, 2024
@bkci-bot
Merge pull request #9871 from randychen2046/issue_9869_slow_sql
9d89950 
[Stream]每日凌晨上报活跃项目sql优化 #9869
@bkci-bot bkci-bot added the for gray UAT environment in tencent has been deploy label Jan 4, 2024
@randychen2046 randychen2046 added streams/grayed stream 灰度环境测试通过 and removed for gray UAT environment in tencent has been deploy labels Jan 9, 2024
@bkci-bot bkci-bot added the done Production environment in tencent has been deploy label Jan 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@randychen2046 randychen2046

Labels
done Production environment in tencent has been deploy kind/enhancement 功能改进特性 streams/grayed stream 灰度环境测试通过
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@randychen2046 @bkci-bot