Skip to content

Draft: Feature: decomposition:connection_status: Include connection status

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 connections

Currently 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)
  1. Visit any group or project member pages such as http://127.0.0.1:3000/groups/flightjs/-/group_members
  2. Click the invite members button. -->

Related to #450729

Edited by Niklas Janz

Merge request reports