Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uG0gT-00Bds0-0t for pgsql-admin@arkaria.postgresql.org; Fri, 16 May 2025 19:25:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uG0gR-003mMq-9i for pgsql-admin@arkaria.postgresql.org; Fri, 16 May 2025 19:25:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uG0gQ-003mMi-Ta for pgsql-admin@lists.postgresql.org; Fri, 16 May 2025 19:25:26 +0000 Received: from cloud.gatewaynet.com ([185.90.37.94]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uG0gN-0027op-0P for pgsql-admin@lists.postgresql.org; Fri, 16 May 2025 19:25:25 +0000 Message-ID: Date: Fri, 16 May 2025 22:25:19 +0300 MIME-Version: 1.0 Subject: Re: pg_stat_statements, write activity To: Scott Ribe , pgsql-admin References: <30BA99F7-F935-4020-B53B-0D70FFA7D205@elevated-dev.com> Content-Language: en-US From: Achilleas Mantzios In-Reply-To: <30BA99F7-F935-4020-B53B-0D70FFA7D205@elevated-dev.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 16/5/25 20:10, Scott Ribe wrote: > I would guess that shared_blks_dirtied in pg_stat_statements is basically the count of blocks which will be logged into WAL and written back during checkpoints. So then what is shared_blks_written? Or do I misunderstand shared_blks_dirtied??? My understanding is that dirtied will be eventually written, via checkpoint or bg writer, so it's a matter of timing. > > -- > Scott Ribe > scott_ribe@elevated-dev.com > https://www.linkedin.com/in/scottribe/ > > > > >