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

Add support for wal_fpi in pg_stat_wal #1028

Open
NotIlya4 opened this issue May 7, 2024 · 1 comment
Open

Add support for wal_fpi in pg_stat_wal #1028

NotIlya4 opened this issue May 7, 2024 · 1 comment

Comments

@NotIlya4
Copy link

NotIlya4 commented May 7, 2024

Add support for pg_stat_wal

Use case. Why is this important?
I have a use case from my experience. I had huge spikes on checkpoints. At first, I thought the checkpointer was late and that I needed to increase max_wal_size/checkpoint_timeout, but it didn't help. I accidentally noticed that wal_fpi increased along with the spikes. To prove this, my workaround was to sample it with an SQL exporter, and it turned out to be true. The core problem was that we had a table with a GUID index and a huge insert workload, which rapidly dirties almost all the index's pages, triggering massive wal_fpi on checkpoints. Having at least wal_fpi would be very useful to quickly discover such problems. Also, I think it would be useful to have the entire pg_stat_wal in the exporter, but for other columns, I don't have such motivation.

@SuperQ
Copy link
Contributor

SuperQ commented May 7, 2024

A pg_stat_wal collector sounds like a great idea.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants