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 1uFyZt-00BAZH-Mh for pgsql-admin@arkaria.postgresql.org; Fri, 16 May 2025 17:10:34 +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 1uFyZr-003F4H-A2 for pgsql-admin@arkaria.postgresql.org; Fri, 16 May 2025 17:10:31 +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 1uFyZq-003F49-QL for pgsql-admin@lists.postgresql.org; Fri, 16 May 2025 17:10:30 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uFyZn-0026rU-3D for pgsql-admin@lists.postgresql.org; Fri, 16 May 2025 17:10:29 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 238D96361C for ; Fri, 16 May 2025 17:10:27 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1747415427; bh=Y7KzFu8tA02n/XJfReS0kNvg9JqqFdI5ptdwfVo/hR8=; h=From:Subject:Date:To:From; b=XK7v4ACImvDMNvGGtJkl+lHUMKPSVziPI/V5N13uHPNtUPn+IjB0LPjpOeK6zKMjr G9+QExOjE4Yh/O4UjjIF5aq2bdoEe/kgdB2AGw8YBO/z8kIE3SnOcWzmfZp6AJluz8 N8jniswVdrj/JGr4Pb6cezbG0mmh9XUDn8eO78+ZaHDMD68sSLcQskhFx5GONKPQbQ zvRy3q89Gya9YzVF3wJXK8IHgHG/E/fK+qgvKn/gjOMw4qSZ0UptDeZNhDCkm2wR8X SBlE0krBxQYAoTFolgW/IS5Fejvxv68qryugwx6vAWuxsD2XbP4NL3Sn19Un/8gZM5 1K7plVYU5hbHg== X-Virus-Scanned: Debian amavisd-new at emo07-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo07-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id xy4s0oZOpMkv for ; Fri, 16 May 2025 17:10:26 +0000 (UTC) Received: from smtpclient.apple (165.140.184.195.ip.vcn.com [165.140.184.195]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id B03886360F for ; Fri, 16 May 2025 17:10:26 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1747415426; bh=Y7KzFu8tA02n/XJfReS0kNvg9JqqFdI5ptdwfVo/hR8=; h=From:Subject:Date:To:From; b=ZQtTrviFv1bNbxMco6nZYnk6SepcOkam6kEg8lHqYgTTOfOUr2muo8qQDQ67VBpxl SeDDBmp6IQ1RjxoPSAbu2q517zwxSej6jY2v6QD4bsAG8ujp6jzNAdnXlSTdUxsFh5 sTt3PaNMC7sz//yoHV3gJkkukdpfZNTWD8Iu2HEqtXu6Q187unfyn4S+950grnGP6R pAGdD3qNYDIN7aGBaB2QwnxAf08Y8ugQDoKomdul6xAcYr8D0t8wxyWLbESpbBp/WK A9NspQQ+BWI9Y0KrgDC6ysq8LFg869moCFBtGdbDsest1K64GsjggzVwztJr160+Am 07XenQLZ9ykrg== From: Scott Ribe Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.500.181.1.5\)) Subject: pg_stat_statements, write activity Message-Id: <30BA99F7-F935-4020-B53B-0D70FFA7D205@elevated-dev.com> Date: Fri, 16 May 2025 11:10:15 -0600 To: pgsql-admin X-Mailer: Apple Mail (2.3826.500.181.1.5) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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??? -- Scott Ribe scott_ribe@elevated-dev.com https://www.linkedin.com/in/scottribe/