Usage ping data: Optimize Jira usage calculation using deployment_type
Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.
From !37002 (comment 425771159)
Once this migration is merged, we could probably update lib/gitlab/usage_data.rb#
jira_usageto query thedeployment_typecolumn directly.
There is a new field on the jira_tracker_data table called deployment_type. This can probably be used to query the database directly when calculating the jira usage in jira_service_data, rather than querying each individual record and re-calculating it.
Related MRs: !37003 (merged) and !36992 (merged)
Edited by 🤖 GitLab Bot 🤖