Laurenz Albe schrieb am 18.11.2022 um 16:51:
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
Ron writes:
> On 11/18/22 09:51, Laurenz Albe wrote:
>> On Fri, 2022-11-18 at 11:11 +0100, Thomas Kellerer wrote:
>>> Any ideas on how to get the equivalent of (blk_read_time / blks_read) for
>>> blk_write_time?
>> You cannot get that, because most writes are done by the checkpointer, and
>> tha
On 11/18/22 09:51, Laurenz Albe wrote:
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_ti
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 i
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.
>
