Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

fix(monitoring): improve accuracy of replica lag #2750

Merged
merged 1 commit into from
Sep 12, 2023
Merged

Conversation

gbartolini
Copy link
Contributor

This patch overrides the previous patch which only covered the documentation samples. From a deeper analysis, we noticed that some examples had already been introduced in the default monitoring config map, thus have been removed from the docs.

The default configmap now fixes the pg_replication metric to use the pg_last_wal_receive_lsn() and pg_last_wal_replay_lsn() functions to better estimate the lag of a replica, and avoid the increase of the lag on inactive systems.

Closes #1814

@github-actions github-actions bot added backport-requested ◀️ This pull request should be backported to all supported releases release-1.19 release-1.20 labels Sep 12, 2023
@github-actions
Copy link
Contributor

Build Error! No Linked Issue found. Please link an issue or mention it in the body using #<issue_id>

@github-actions
Copy link
Contributor

❗ By default, the pull request is configured to backport to all release branches.

  • To stop backporting this pr, remove the label: backport-requested ◀️ or add the label 'do not backport'
  • To stop backporting this pr to a certain release branch, remove the specific branch label: release-x.y

@github-actions
Copy link
Contributor

Build Error! No Linked Issue found. Please link an issue or mention it in the body using #<issue_id>

This patch overrides the previous patch which only covered the
documentation samples. From a deeper analysis, we noticed that
some examples had already been introduced in the default monitoring
config map, thus have been removed from the docs.

The default configmap now fixes the `pg_replication` metric to use the
`pg_last_wal_receive_lsn()` and `pg_last_wal_replay_lsn()` functions to better
estimate the lag of a replica, and avoid the increase of the lag on inactive
systems.

Closes #1814

Signed-off-by: Gabriele Bartolini <gabriele.bartolini@enterprisedb.com>
@gbartolini gbartolini merged commit 6b7b91c into main Sep 12, 2023
5 of 7 checks passed
@gbartolini gbartolini deleted the dev/1814-b branch September 12, 2023 20:08
@github-actions
Copy link
Contributor

Build Error! No Linked Issue found. Please link an issue or mention it in the body using #<issue_id>

cnpg-bot pushed a commit that referenced this pull request Sep 12, 2023
This patch overrides the previous patch which only covered the
documentation samples. From a deeper analysis, we noticed that
some examples had already been introduced in the default monitoring
config map, thus have been removed from the docs.

The default configmap now fixes the `pg_replication` metric to use the
`pg_last_wal_receive_lsn()` and `pg_last_wal_replay_lsn()` functions to better
estimate the lag of a replica, and avoid the increase of the lag on inactive
systems.

Closes #1814

Signed-off-by: Gabriele Bartolini <gabriele.bartolini@enterprisedb.com>
(cherry picked from commit 6b7b91c)
mnencia pushed a commit that referenced this pull request Sep 13, 2023
This patch overrides the previous patch which only covered the
documentation samples. From a deeper analysis, we noticed that
some examples had already been introduced in the default monitoring
config map, thus have been removed from the docs.

The default configmap now fixes the `pg_replication` metric to use the
`pg_last_wal_receive_lsn()` and `pg_last_wal_replay_lsn()` functions to better
estimate the lag of a replica, and avoid the increase of the lag on inactive
systems.

Closes #1814 

Signed-off-by: Gabriele Bartolini <gabriele.bartolini@enterprisedb.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
backport-requested ◀️ This pull request should be backported to all supported releases release-1.19 release-1.20
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Replication lag metric seems to be broken in 1.19.1
3 participants