-
Notifications
You must be signed in to change notification settings - Fork 93
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
New monitoring metric in PostgreSQL 16: pg_stat_io #324
Comments
two good examples of what to report on in https://postgrespro.com/blog/pgsql/5970086 as well |
So the PG17 changes required gathering some BGW stats from pg_stat_io since they were removed from the pg_stat_bgwriter catalog. I'm pulling that out via a stat that specific to the
|
Convert the reads/writes blocks columns to bytes. Just add it as an additional column/metric so people can parse blocks too if they really want to. Example output
|
Add view for
pg_stat_io
pg_stat_io
:Rows of the view show IO operations for a particular backend type, IO target
object, IO context combination (e.g. a client backend's operations on
permanent relations in shared buffers) and each column in the view is the
total number of IO Operations done (e.g. writes). So a cell in the view would
be, for example, the number of blocks of relation data written from shared
buffers by client backends since the last stats reset.
https://www.postgresql.org/message-id/[email protected]
https://pganalyze.com/blog/pg-stat-io
The text was updated successfully, but these errors were encountered: