Postgres Pro
Downloads
Home   >   mailing lists

Calculating average block write time - Mailing list pgsql-general

From Thomas Kellerer
Subject Calculating average block write time
Date
Msg-id 90374fa3-d750-e1ab-2fad-eaa7142f6b5a@gmx.net
Whole thread Raw
Responses Re: Calculating average block write time  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-general
Tree view 
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.

Am I missing something, or is this simply not tracked (as of Postgres 15)?

Regards
Thomas

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Reducing bandwidth usage of database replication
Next
From: Simon Riggs
Date:
Subject: Re: Reducing bandwidth usage of database replication