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 1uGuRU-009l36-PU for pgsql-admin@arkaria.postgresql.org; Mon, 19 May 2025 06:57:45 +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 1uGuRT-00DzPW-PH for pgsql-admin@arkaria.postgresql.org; Mon, 19 May 2025 06:57:43 +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 1uGuRT-00DzPJ-D0 for pgsql-admin@lists.postgresql.org; Mon, 19 May 2025 06:57:43 +0000 Received: from mail-wm1-x32a.google.com ([2a00:1450:4864:20::32a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uGuRQ-002Wx7-22 for pgsql-admin@lists.postgresql.org; Mon, 19 May 2025 06:57:42 +0000 Received: by mail-wm1-x32a.google.com with SMTP id 5b1f17b1804b1-440685d6afcso43169625e9.0 for ; Sun, 18 May 2025 23:57:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1747637860; x=1748242660; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=2zsPoPB0YVRpSESQ1hSGuS1QNbi4eJpPx36kLZwCYhU=; b=WcTdsHPR+Z85yVBfMXrG7kUluXlnQgpYfg0FshhHHmxOtq4OpblpGjXsumJ8sxL/fg 4jgkjkAwMyNbX+TGcoMLpObDn4BTFzRcnQxDVZo1Pt6wv2j6BwRu8tPwg6hDZvMm4+p2 1BYQGVheYsbw71ghTaiz1ovSDt8KjssfFKc83mvevBP5Sa11lvOSUv/UV7ptgLfczc1r 0hrukIoTKnpRtD+qai6ZtoC1quTiDRz2JpQFAZL0e0q6TfbJ3V89qNrnC6u5g6ksh9wX 4HcLp7JOYObAt4XNu0aQM30+cdcdoYw9KKiIEfDQ1reLCErRkaIf0ggiL0tNvIkPym3E H2Qw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747637860; x=1748242660; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=2zsPoPB0YVRpSESQ1hSGuS1QNbi4eJpPx36kLZwCYhU=; b=lOkfO5oAW0tfeDYxwpp1UHdNe1SZl993ux5+rHVl8VcUMWIyEGHEFk8IvnNjsWf5DI 0qhVw0ZW30dnlUB24UAJazZLS6kiD03uIwn9whvjvMygJkvByrtJtOASde5i5rtgPkju 5fcETQ9VfmubeB2dzXImbDI1OmIPVPmcL+UnBpZFAwngLamQdhW1NITOf7mhsNMuuo6B mGmsRU3sHl7p9KTLSdKMDSfr8mD2aVkxpS/4XyLHLpscZw/9M0U3eCEM9ZZqSSXNPm9x wJeGZ5oS2gtoPTxXyKpkQC4iNv22SfKKIjpwjzYqYiXaS3fWZY5HqaBaD0pGNUoF/hUp iSkg== X-Gm-Message-State: AOJu0Yyp81U9Pw9XlrM77GS4jabadiTpI1pHIkUE5wsoLFvmQC4AWHzb 8t66avMk+DQEDmrQ1uuCZ7Ok53Cqy8LYm3Xa1lUQLEIOuq/gXm84Fmhg59FADIQwa+LcrhF96dq O31Gd X-Gm-Gg: ASbGncuQUBr/HguW+Yf2C22pI0cQJXeo+xn12g3KqwFtPAEwvrVaeFH3dQkiz2kAwL3 YziZGGAHltGo1RBWze7th6/QXE3/qoxBwM5hguwHZ+pclCylYQEWdfhECe0olS/TaBgRQagM7Xi A2AK1BTa5HBA2W8xqoQIGSjQFj9jE+smcw621CKPmM0xxa4xfRyyfvPtTjdxOze5dgSKYKjCifJ JgT/DAqhaC+c3n9UtA+wsi48qAcP1PcJ+3AUwXLTl5n4u1qsnq8r7mh6m1L+UAXuOYtjGvmAyZu +19lxrsZ7Gv5dzPPDga2r0eagHl/dvPK+pEBM53SYk/k1Q5klf2XWtXPrkNUFvWgIqiNJl90YGz kDI9r X-Google-Smtp-Source: AGHT+IFJZzInVlAVode44zDesfmsTxy6XQlFYMedHB/tN9FWqYCASQyjdedMo16e+BeY2smFf76XoQ== X-Received: by 2002:a05:600c:8487:b0:43c:e7ae:4bc9 with SMTP id 5b1f17b1804b1-442fefd77c6mr97166525e9.1.1747637859608; Sun, 18 May 2025 23:57:39 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:5e:822b:3860:ca57:ab3e:b53a]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-442fd5107f8sm124465665e9.16.2025.05.18.23.57.39 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 18 May 2025 23:57:39 -0700 (PDT) Message-ID: <841006e17c5eeb4536289bd203dc59650e5cce21.camel@cybertec.at> Subject: Re: pg_stat_statements, write activity From: Laurenz Albe To: Scott Ribe Cc: pgsql-admin Date: Mon, 19 May 2025 08:57:38 +0200 In-Reply-To: <4D3DD5A9-AB6C-4BE1-8F21-091B482C6B48@elevated-dev.com> References: <30BA99F7-F935-4020-B53B-0D70FFA7D205@elevated-dev.com> <4D3DD5A9-AB6C-4BE1-8F21-091B482C6B48@elevated-dev.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 User-Agent: Evolution 3.56.1 (3.56.1-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gU2F0LCAyMDI1LTA1LTE3IGF0IDA4OjUwIC0wNjAwLCBTY290dCBSaWJlIHdyb3RlOgo+ID4g T24gTWF5IDE2LCAyMDI1LCBhdCAxOjM34oCvUE0sIExhdXJlbnogQWxiZSA8bGF1cmVuei5hbGJl QGN5YmVydGVjLmF0PiB3cm90ZToKPiA+IAo+ID4gU29tZXRpbWVzLCBhIGJhY2tlbmQgd3JpdGVz IGEgYmxvY2sgdG8gZGlzayBpdHNlbGYuICBUaGlzIG1pZ2h0IGhhcHBlbiBpZiBhIGxvdAo+ID4g b2YgY2FjaGUgcHJlc3N1cmUsIGJ1dCB1c3VhbGx5IGl0IGhhcHBlbnMgd2hlbiB0aGUgdGFibGUg aXMgZXh0ZW5kZWQgd2l0aCBuZXcKPiA+IGJsb2Nrcy4KPiAKPiBBaCwgdGhhdCdzIHRoZSBwaWVj ZSBJIHdhcyBtaXNzaW5nIQo+IAo+IERvIHRoZSB3cml0dGVuIGJsb2NrcyBnZXQgY291bnRlZCBh cyBkaXJ0eSBmaXJzdCwgb3Igb25seSBhcyB3cml0dGVuPwoKVGhleSB3aWxsIGNlcnRhaW5seSBi ZSBkaXJ0eSBhcyB3ZWxsLiAgWW91IGNhbiB1c2Ugc2ltcGxlIGV4cGVyaW1lbnRzIHRvIGFuc3dl cgpxdWVzdGlvbnMgbGlrZSB0aGlzOgoKQ1JFQVRFIFRBQkxFIG5ldyhpZCBpbnRlZ2VyKTsKCkVY UExBSU4gKEFOQUxZWkUsIEJVRkZFUlMsIENPU1RTIE9GRiwgU1VNTUFSWSBPRkYpIElOU0VSVCBJ TlRPIG5ldyBWQUxVRVMgKDQyKTsKCiAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFO ICAgICAgICAgICAgICAgICAgICAgICAgIArilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDi lZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDi lZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDi lZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZAKIEluc2VydCBvbiBuZXcgKGFjdHVh bCB0aW1lPTAuMTY1Li4wLjE2NiByb3dzPTAuMDAgbG9vcHM9MSkKICAgQnVmZmVyczogc2hhcmVk IGRpcnRpZWQ9MSB3cml0dGVuPTEKICAgLT4gIFJlc3VsdCAoYWN0dWFsIHRpbWU9MC4wMDIuLjAu MDAzIHJvd3M9MS4wMCBsb29wcz0xKQoKWW91cnMsCkxhdXJlbnogQWxiZQo=