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 1sv8YM-00ChVo-4k for pgsql-committers@arkaria.postgresql.org; Mon, 30 Sep 2024 05:02: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 1sv8YL-00CSXG-HL for pgsql-committers@arkaria.postgresql.org; Mon, 30 Sep 2024 05:02:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sv8YL-00CSWS-9y for pgsql-committers@lists.postgresql.org; Mon, 30 Sep 2024 05:02:33 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sv8YG-001mho-Rg for pgsql-committers@lists.postgresql.org; Mon, 30 Sep 2024 05:02:32 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sv8YG-005Tc6-7P for pgsql-committers@lists.postgresql.org; Mon, 30 Sep 2024 05:02:28 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sv8YF-001WMH-Ht for pgsql-committers@lists.postgresql.org; Mon, 30 Sep 2024 05:02:28 +0000 Content-Type: multipart/mixed; boundary="===============1842871340233044935==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Show values of SET statements as constants in pg_stat_statements X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 30 Sep 2024 05:02:28 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1842871340233044935== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U2hvdyB2YWx1ZXMgb2YgU0VUIHN0YXRlbWVudHMgYXMgY29uc3RhbnRzIGluIHBnX3N0YXRfc3Rh dGVtZW50cwoKVGhpcyBpcyBhIGNvbnRpbnVhdGlvbiBvZiB3b3JrIGxpa2UgMTFjMzRiMzQyYmQ3 LCBkb25lIHRvIHJlZHVjZSB0aGUKYmxvYXQgb2YgcGdfc3RhdF9zdGF0ZW1lbnRzIGJ5IGFwcGx5 aW5nIG1vcmUgbm9ybWFsaXphdGlvbiB0byBxdWVyeQplbnRyaWVzLiAgVGhpcyBjb21taXQgaXMg YWJsZSB0byBkZXRlY3QgYW5kIG5vcm1hbGl6ZSB2YWx1ZXMgaW4KVmFyaWFibGVTZXRTdG10LCBy ZXN1bHRpbmcgaW46ClNFVCBjb25mX3BhcmFtID0gJDEKCkNvbXBhcmVkIHRvIG90aGVyIHBhcnNl IG5vZGVzLCBWYXJpYWJsZVNldFN0bXQgaXMgZW1iZWRkZWQgaW4gbXVjaCBtb3JlCnBsYWNlcyBp biB0aGUgcGFyc2VyLCBpbXBhY3RpbmcgbWFueSBxdWVyeSBwYXR0ZXJucyBpbgpwZ19zdGF0X3N0 YXRlbWVudHMuICBBIGN1c3RvbSBqdW1ibGUgZnVuY3Rpb24gaXMgdXNlZCwgd2l0aCBhbiBleHRy YQpmaWVsZCBpbiB0aGUgbm9kZSB0byBkZWNpZGUgaWYgYXJndW1lbnRzIHNob3VsZCBiZSBpbmNs dWRlZCBpbiB0aGUKanVtYmxpbmcgb3Igbm90LCBhIGxvY2F0aW9uIGZpZWxkIGJlaW5nIG5vdCBl bm91Z2ggZm9yIHRoaXMgcHVycG9zZS4KVGhpcyBhcHByb2FjaCBhbGxvd3MgZm9yIGEgZmluZXIg dHVuaW5nLgoKQ2xhdXNlcyByZWx5aW5nIG9uIG9uZSBvciBtb3JlIGtleXdvcmRzIGFyZSBub3Qg bm9ybWFsaXplZCwgZm9yIGV4YW1wbGU6CiogREVGQVVMVAoqIEZST00gQ1VSUkVOVAoqIExpc3Qg b2Yga2V5d29yZHMuICBTRVQgU0VTU0lPTiBDSEFSQUNURVJJU1RJQ1MgQVMgVFJBTlNBQ1RJT04s CndoZXJlIGl0IGlzIGNyaXRpY2FsIHRvIGRpZmZlcmVudGlhdGUgZGlmZmVyZW50IHNldHMgb2Yg b3B0aW9ucywgaXMgYQpnb29kIGV4YW1wbGUgb2Ygd2h5IG5vcm1hbGl6YXRpb24gc2hvdWxkIG5v dCBoYXBwZW4uCgpTb21lIHF1ZXJpZXMgdXNlIFZhcmlhYmxlU2V0U3RtdCBmb3Igc29tZSBzdWJj bGF1c2VzIHdpdGggU0VULCB0aGF0IGFsc28KaGF2ZSB0aGVpciB2YWx1ZXMgbm9ybWFsaXplZDoK LSBBTFRFUiBEQVRBQkFTRQotIEFMVEVSIFJPTEUKLSBBTFRFUiBTWVNURU0KLSBDUkVBVEUvQUxU RVIgRlVOQ1RJT04KCmJhOTBlYWM3YTk5NSBoYXMgYWRkZWQgdGVzdCBjb3ZlcmFnZSBmb3IgbW9z dCBvZiB0aGUgZXhpc3RpbmcgU0VUCnBhdHRlcm5zLiAgVGhlIGV4cGVjdGVkIG91dHB1dCBvZiB0 aGVzZSB0ZXN0cyBzaG93cyB0aGUgZGlmZmVyZW5jZSB0aGlzCmNvbW1pdCBjcmVhdGVzLiAgTm9y bWFsaXphdGlvbiBjb3VsZCBiZSBwZXJoYXBzIGFwcGxpZWQgdG8gbW9yZSBwb3J0aW9ucwpvZiB0 aGUgZ3JhbW1hciBidXQgd2hhdCBpcyBkb25lIGhlcmUgaXMgY29uc2VydmF0aXZlLCBhbmQgZ29v ZCBlbm91Z2ggYXMKYSBzdGFydGluZyBwb2ludC4KCkF1dGhvcjogR3JlZyBTYWJpbm8gTXVsbGFu ZSwgTWljaGFlbCBQYXF1aWVyCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMzZlNWJm ZmUtZTk4OS0xOTRmLTg1YzgtMDZlN2JjODhlNmY3QGFtYXpvbi5jb20KRGlzY3Vzc2lvbjogaHR0 cHM6Ly9wb3N0Z3IuZXMvbS9CNDRGQTI5RC1FQkQwLTRERDktQUJDMi0xNkYxQ0IwODcwNzRAYW1h em9uLmNvbQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBS0FubW1KdEpZMmp6UU45 MT0yUUFEMmVBSkFBLVBlcjYxZXlPNDgtVHl4RWctcTBSZ0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNo Ci0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9y Zy9wZy9jb21taXRkaWZmL2RjNjg1MTU5NjhlODBkNzVmODEwNmQwZGYwNWRhMzQ2YmU1Mzc2MjgK Ck1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmNvbnRyaWIvcGdfc3RhdF9zdGF0ZW1lbnRz L2V4cGVjdGVkL2RtbC5vdXQgICAgICAgIHwgIDIgKy0KLi4uL3BnX3N0YXRfc3RhdGVtZW50cy9l eHBlY3RlZC9sZXZlbF90cmFja2luZy5vdXQgfCAgMiArLQpjb250cmliL3BnX3N0YXRfc3RhdGVt ZW50cy9leHBlY3RlZC91dGlsaXR5Lm91dCAgICB8IDIwICsrKysrKystLS0tLS0tLS0tLQpjb250 cmliL3BnX3N0YXRfc3RhdGVtZW50cy9leHBlY3RlZC93YWwub3V0ICAgICAgICB8ICAyICstCnNy Yy9iYWNrZW5kL25vZGVzL3F1ZXJ5anVtYmxlZnVuY3MuYyAgICAgICAgICAgICAgIHwgMTkgKysr KysrKysrKysrKysrKysKc3JjL2JhY2tlbmQvcGFyc2VyL2dyYW0ueSAgICAgICAgICAgICAgICAg ICAgICAgICAgfCAyNCArKysrKysrKysrKysrKysrKysrKysrCnNyYy9pbmNsdWRlL25vZGVzL3Bh cnNlbm9kZXMuaCAgICAgICAgICAgICAgICAgICAgIHwgMjEgKysrKysrKysrKysrKysrKy0tLQo3 IGZpbGVzIGNoYW5nZWQsIDcxIGluc2VydGlvbnMoKyksIDE5IGRlbGV0aW9ucygtKQoK --===============1842871340233044935==--