Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oqsrK-0000M4-C9 for pgsql-general@arkaria.postgresql.org; Fri, 04 Nov 2022 09:19:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oqsrJ-0007ST-7s for pgsql-general@arkaria.postgresql.org; Fri, 04 Nov 2022 09:19:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oqsrI-0007SK-St for pgsql-general@lists.postgresql.org; Fri, 04 Nov 2022 09:19:28 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oqsrF-0000g6-Mv for pgsql-general@lists.postgresql.org; Fri, 04 Nov 2022 09:19:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1667553564; bh=HFeiKnmEo5BX6sniisWpcjHPqgEbrt4GL1NisxxCFCY=; h=X-UI-Sender-Class:To:From:Subject:Date; b=dofRJnstmHnnheYciw0oyxFGhIh3ZPbHgcZ5qNCZgR/G0hSMLWD5sgX7iCKxKqeE5 Qle4iuilnYQfPitdxmxVWs8SQe3NxStZWCkQzLLGrnmWaG+R6M9kB9dJifQZWT6Ipj l7FjiSfpZU/LP1ZzgMEDT0pYDW4a9rTLYRoA4Jso8dOhrt0DhKIE0GGcYicTEDtWKP 2DVb/a1TpWWJ1JaEHPtjL4WW7k5fdDySldULtSQv1SxLXEuVL0V93m2/xZfQYexcvm vl5kvMoX+Xj+F/qVtgn7Oqsvxt6VUfpKQxU7lkCmVgRvzPNkCh8KV6RSh+SV570UQC oDJP+y2xeIjig== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.1.33.81] ([185.40.248.10]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1M7JzQ-1owMUq0XVM-007hX4 for ; Fri, 04 Nov 2022 10:19:24 +0100 To: "pgsql-general@lists.postgresql.org" From: Thomas Kellerer Subject: Calculating average block write time Message-ID: <90374fa3-d750-e1ab-2fad-eaa7142f6b5a@gmx.net> Date: Fri, 4 Nov 2022 10:19:23 +0100 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:Vqd61WTyadW/5scAA+1ikphcWUYIA67qGb0aVvILCI47G2yiks3 iyXwUdJzFkJFzHC2cwZkkIX3rduW/r3dOHaOEo9cnmQSRA2OBj+8Sn5mAcurTGn5kCrKezi SWNSxudosqteMdGzNRVL81vkg9z7H3wnT4y7DaPgToue7uR5iqXWJEK2vGZBe/IiBeUT4pM /fosl+u72GnJQwO4K1gLg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:o1Pm3tZQiQ0=;ImUkJeWGTIQwocDDq+i/MONadMo PC9Oqhr3Vg4xeOjVuEcnqIVwzSu23ptVlTT9NEkj+PzN2H/DLQmTesp196tmnVHkk6YmKRu0G fmghZTTXETEGMc91GcL2xHxyDSwb+mK/HbzzNuxkQVRjgd3RbFYmuA/CDWyDeuPfdFPxFwfNd Y9agg4tOnJAkEBlQNBVOo2Gg5vXTFsX5B7UivbAStKXYbj3oGiVSqcZljftOFTOPohMGWqZz+ 7xkJh+MDDawRB1FAEYPgpN4I87xT8G3uNufMyHKNLEYs1bpdThhaF0sGBWE6gjeHvvMe4U0v+ 9C0fM7HLAZN9P3DphGj8ArdwVg40eYOO5d2L5GntyG3bxm3QZvb2VQ2/hotNv8YTch7f24Z4I m6l0sGeGmlhCN9Cy3EkjY1xU/dlqx9se+0QpKB2xAyg8pco7xxW2WxqKdKKVRwAOjTIZXBRsX eSS25Uo5kPz59ZQyHVEbvYPZF0IqMTpzPVWw1MNsHay6u6PRvfv9SxOTiA8RmvljgD+0Wj6p7 Ruu1gbp9YWRudJKtQHDfEOVH/VfspbKTbXqBWmoXc4jOJXxooha8/75Nc05Cwilnn4UL0f31V /K71kJ6KueD5J2uxO8DHl8Bl8uvTuFhF+8B4FR/y962gN2DbFNub2nnqYTh7/Izp3k1PfoNHJ 7IaZHWndEtZIxFJSc/zhuKmKkZYIWYFQ26eH5TqV8bmbDEChxxI59qZ4RoGzhCqpG4acP3Y1i gXqrTnGEIAYH3HRlIHRiOYo96XBkRmSfPFZDKGPmo9MtJ2xhSA2wKFGCE0sXDYiYwyeIMqbf3 /f27o0rpAExK5fDDytu2A1XSNgEfxoDDOH1/jK2uz0KKtDftgQHhHEIxbIcI0QdsfSGdLykcS /r3KjlcTADfEp1RZRDdlyzgNYxK87iJ7Egel3rKDEY0I90dTiqUQ4ELYXzaJ1H0q47LVWF29v GdfbdcrO/k6SP7dzaoam03yHD/Q= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 cummulat= ive measure for the total number of blocks written. Am I missing something, or is this simply not tracked (as of Postgres 15)? Regards Thomas