Add missing database indexes for telemetry metrics
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 970
- Forks
- 486
- Avg merge
- 3d 33m
- Merged PRs (30d)
- 170
Description
Description
Analysis of telemetry metric queries revealed missing database indexes that could cause slow queries and contribute to connection timeouts. Missing indexes on experiment table: status column (used by 5+ metrics) and mod_date column (used for date range queries). Recommend adding: CREATE INDEX idx_experiment_status ON experiment (status); and CREATE INDEX idx_experiment_mod_date ON experiment (mod_date). Should also analyze other metric tables for similar issues.
Acceptance Criteria
- [Define what needs to be accomplished]
Additional Notes
[Any additional context or notes]
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the experiment table schema and the telemetry metric queries that filter on status or mod_date. Review the other metric tables for comparable query patterns and inspect their execution plans. Done means the justified indexes are added and the affected queries no longer show the reported performance risk.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, performance
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Needs clarification
- Newbie friendliness
- 42/100