Increase the query size that we are collecting on pg_stat_activity
Currently, we just capture the first 1048 bytes from the query.
We need to increase to capture the whole query and the marginalia comments.
This is impacting in the analysis as: https://gitlab.com/gitlab-com/gl-infra/infrastructure/-/issues/12309
The parameter we need to change is the:
track_activity_query_size = 2048
The parameter above will require a switchover from the primary since requires a restart.
Due to requirement for pgsentinel, we should also change:
pg_stat_statements.track = all
** Acceptance criteria: **
-
Create the MR for staging and production. -
Rollout in staging. Using the playbook with the same procedure that will be needed in production. -
Evaluate any performance drawback. -
Rollout in Production. Using a playbook.
Edited by Jose Finotto