Skip to content

Added project_stats indexes

Suraj Tripathi requested to merge issue_389424_add_index_to_sort_project_stats_column into master

What does this MR do and why?

Based on review feedback during adding sort functionality for the following fields from project_statistics, db concerns were raised.

This MR introduces indexes on the columns to mitigate those concerns

Added project_stats indexes

Added index for lfs_objects_size build_artifacts_size snippets_size pipeline_artifacts_siz

Changelog: performance ref: https://gitlab.com/gitlab-org/gitlab/-/issues/389424

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

Before After

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Merge request reports