On Fri, 2022-11-18 at 11:11 +0100, Thomas Kellerer wrote: > Thomas Kellerer schrieb am 04.11.2022 um 10:19: > > I can easily calculate the average block read time using > > pg_stat_database and divide blk_read_time by blks_read. > > > > While there is a column blk_write_time, it seems that there is no > > cummulative measure for the total number of blocks written. > > > > Any ideas on how to get the equivalent of (blk_read_time / blks_read) for > blk_write_time? > > I thought about using tup_updated + tup_inserted + tup_deleted because each > tuple change would require at least one block written. > However, a single block write could update multiple tuples so the result of > that wouldn't be accurate (too low).
You cannot get that, because most writes are done by the checkpointer, and that does not distinguish between databases. Yours, Laurenz Albe -- +43-670-6056265 CYBERTEC PostgreSQL International GmbH Römerstraße 19, 2752 Wöllersdorf Web: https://www.cybertec-postgresql.com
