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

Grafana Dashboard - add WAL count #217

Closed
pchovelon opened this issue Mar 15, 2024 · 3 comments
Closed

Grafana Dashboard - add WAL count #217

pchovelon opened this issue Mar 15, 2024 · 3 comments
Labels
chart( operator ) Related to the operator (cloudnative-pg) chart

Comments

@pchovelon
Copy link

It could be great to have the number of WAL in the pg_wal folder, regardless their state.

@gbartolini
Copy link
Contributor

gbartolini commented Mar 15, 2024

@pchovelon have you considered also some of the metrics below (taken from here? Is there any other which can be relevant?

cnpg_collector_pg_wal{value="count"} 9
cnpg_collector_pg_wal{value="slots_max"} NaN
cnpg_collector_pg_wal{value="keep"} 32
cnpg_collector_pg_wal{value="max"} 64
cnpg_collector_pg_wal{value="min"} 5
cnpg_collector_pg_wal{value="size"} 1.50994944e+08
cnpg_collector_pg_wal{value="volume_max"} 128
cnpg_collector_pg_wal{value="volume_size"} 2.147483648e+09

For example, if WALs are in a separate volume, count/volume_max indicates the current usage of the WAL volume.

@pchovelon
Copy link
Author

pchovelon commented Mar 15, 2024

No I didn't, as I think only the "count" is missing.
For the usage of the WAL volume I thought the panel "Volume Space Usage: PGDATA and WAL" already gives us this information.

@itay-grudev
Copy link
Collaborator

The panel was added to the dashboard in https://github.com/cloudnative-pg/grafana-dashboards. When #225 is merged, the updated version will also apply to the helm chart, so I'm closing this.

@itay-grudev itay-grudev added the chart( operator ) Related to the operator (cloudnative-pg) chart label May 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
chart( operator ) Related to the operator (cloudnative-pg) chart
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants