Calculating average block write time

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Calculating average block write time
Date: 2022-11-04 09:19:23
Message-ID: 90374fa3-d750-e1ab-2fad-eaa7142f6b5a@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2022-11-04 09:20:38 Re: Reducing bandwidth usage of database replication
Previous Message Simon Riggs 2022-11-04 09:16:57 Re: Reducing bandwidth usage of database replication