Draft: Feature: decomposition:connection_status: Include connection status
requested to merge 450729-gitlab-db-decomposition-connection_status-rake-task-doesn-t-include-connection-info-after-ci into master
What does this MR do and why?
solves #450729:
Click to expand
> ### Problem to solve > >`gitlab-rake gitlab:db:decomposition:connection_status` shows the used and max connections of the Postgres database as long as the `ci:` section hasn't been created: > ``` ❯ gitlab-rake gitlab:db:decomposition:connection_status Currently using 42 connections out of 1337 max_connections, which is enough for running GitLab using two database connections. ``` > >This is pretty useful information to have. That behavior changes once the `ci:` section has been created to display a static message: https://gitlab.com/gitlab-org/gitlab/-/blob/v16.6.1-ee/lib/tasks/gitlab/db/decomposition/connection_status.rake?ref_type=tags#L8-11 > ``` ❯ gitlab-rake gitlab:db:decomposition:connection_status GitLab database already running on two connections ``` > >### Proposal > >Provide the connection info, even post `ci:` migration: > ``` ❯ gitlab-rake gitlab:db:decomposition:connection_status GitLab database already running on two connectionsCurrently using 42 connections out of 1337 max_connections, which is enough for running GitLab using two database connections.
>
>### Intended users
>
>[Sidney (Systems Administrator)](https://handbook.gitlab.com/handbook/product/personas/#sidney-systems-administrator) wants to check whether their Postgres `max_connections` is sufficient to accommodate the increased connection demand of GitLab [ter the deprecation of "single database connection".](https://docs.gitlab.com/ee/update/deprecations.html#single-database-connection-is-deprecated)
</details>
## MR acceptance checklist
**Please evaluate this MR against the [MR acceptance checklist](https://docs.gitlab.com/ee/development/code_review.html#acceptance-checklist).**
It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
## Screenshots or screen recordings
_Screenshots are required for UI changes, and strongly recommended for all other merge requests._
<!--
Please include any relevant screenshots or screen recordings that will assist
reviewers and future readers. If you need help visually verifying the change,
please leave a comment and ping a GitLab reviewer, maintainer, or MR coach.
-->
| Before | After |
| ------ | ------ |
| | |
## How to set up and validate locally
_Numbered steps to set up and validate the change are strongly suggested._
<!--
Example below:
1. In rails console enable the experiment fully
```ruby
Feature.enable(:member_areas_of_focus)
- Visit any group or project member pages such as
http://127.0.0.1:3000/groups/flightjs/-/group_members
- Click the
invite members
button. -->
Related to #450729
Edited by Niklas Janz