From: "Ryo Matsumura (Fujitsu)" <matsumura.ryo@fujitsu.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: [PATCH] Docs: clarify default values of EXPLAIN BUFFERS and SERIALIZE
Thread-Topic: [PATCH] Docs: clarify default values of EXPLAIN BUFFERS and
 SERIALIZE
Thread-Index: AQHcso74sNpJiPxQJkmqLiF1WbWWBA==
Date: Fri, 13 Mar 2026 08:38:35 +0000
Message-ID: 
 <TYRPR01MB13457D31085CB5B246DBBA1AFE845A@TYRPR01MB13457.jpnprd01.prod.outlook.com>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
msip_labels: 
 MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Enabled=True;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SiteId=a19f121d-81e1-4858-a9d8-736e267fd4c7;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SetDate=2026-03-13T08:38:44.206Z;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Name=FUJITSU-RESTRICTED;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ContentBits=1;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Method=Standard;
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=fujitsu.com;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: TYRPR01MB13457:EE_|OS7PR01MB12081:EE_
x-ms-office365-filtering-correlation-id: da44aab9-7dca-4d23-f6f7-08de80dbeabb
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: 
 BCL:0;ARA:13230040|6049299003|1800799024|376014|366016|8096899003|56012099003|18002099003|1580799027|4053099003|38070700021;
x-microsoft-antispam-message-info: 
 xGSUCEDIJXL1wwu5ohxwGnqbBkWg7FP8b7dL8P31DdwnQYOfJnoTQCaCZvvZKwVVZy+8NJbDiEURmdYGJOEJ7fg9IR35wcWNBFKu2vqagAMw/C0R6Ydql2ooUuj7K1p8LOOcaLSWR1k6yi64BnLiATxVsXrVv8MEIWwcSz/P9fEkXjwyJXeUVndVnFako3nQFebbpnPCHb1RrABI5hDwNKGwO3RRG0in2bfcP8hR1N1xg/686oeEscUl/uZrh5qqJlzTr2QR71NcNy6WIqmQb1WDiSa2GiZJqVrJHOo6dH3gPluyheq11M9Swf+kVHlpoyhYpFYO4OWD/VCOcUFhuQE3YDEHq91UVB5jg4RVdM/iGNDR+8TWodfhaAUiVWZiSj27jp32SteYn6E9WxbbWZHBKn/PrheGm+T+UwwG1RASC5wRwQ2HdhOAc3V2Wikc9whCHLrvW6RrwDc6WCX8Ie0+FsxtE/7UMoyhx7eKvuqzBMYOUrlKN/jLKOY4UYyZW0WUdYZEx5qvaOkY96s1n7BI56bOwYk5GAVvZpaksEMy7f5yiKpgHi93N+Bd/hQQkdyjr2o+i0wjAv5ilIDbnlKaMpeNVDbmJB0BorbtSb1+EzrBlhJjok7Q78gtFDflchmMAxv1nothAOGiokPThtpdwbVEf9dS9h7xVm6xRsaU0KvqNVz903Ftmchb7EfQUvx3hqCp9t0YHeXh4QwL5XT/41C0fumZuhCLtdj248JcUyy6tqLW9NB/rT1pcBvDQ73ThHYXjisRoLlK2KcgHeNfPAeQinJUsd/MY+tZcAkK486ArCxQ5+SLtBU7OeObBCWESwpf1v+BGQn6RY88sw==
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYRPR01MB13457.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(6049299003)(1800799024)(376014)(366016)(8096899003)(56012099003)(18002099003)(1580799027)(4053099003)(38070700021);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-2022-jp?B?aHFaMUtPclZJQmlPOG9tY1RUV0Q1ejkxd1luaVQycnRQUElaOUM0dkl1?=
 =?iso-2022-jp?B?WlRNb2VLS05iY1E5M0xSNzI1OTdzbExVcFpsQXBtZ2NDUXR5QjZhU01H?=
 =?iso-2022-jp?B?cTRQenBCb2E1TnFHRWpZMDJtWkg4a1hQNXN0UlJUbGoyclpSbDlLeWpw?=
 =?iso-2022-jp?B?OEtzTExvaXhXVDNuQU5zaW13OWsxUko4VnhESis5eEdvUXFEL3VNREZZ?=
 =?iso-2022-jp?B?c0FsS2p0WTEyanJHL3dRR0g3ZkxYQXE1WG1LMkRSUFcwVjdEeml2aUls?=
 =?iso-2022-jp?B?cU5XbTdJY0hpM2tySjFXNUY1K2xoSE1PdVpCT3FoY1dtRHZIOHczV0d0?=
 =?iso-2022-jp?B?eko2VXMvd09yM0E4SW00eThZc002YUpLLzc0NVBKSG1Eb3JWK09FSm1j?=
 =?iso-2022-jp?B?dW1YV3JGcldtbnhpT3dBWkFMOUl3Yjgrdk1tVFBTNVd1TVV0TE9jQlFN?=
 =?iso-2022-jp?B?KzhVaE1aMTlRYVJUMXdZM2hYVjlvL0FCMng0MHpiYTVWSWQ4VU9IU1Nj?=
 =?iso-2022-jp?B?YzFVTk92Qk9YVFVEZkFhOWZ5ejRhcjhhb25YMEsvWDJyU1dETndnS3Rx?=
 =?iso-2022-jp?B?cDBxRG9paWxJOEEzUGxzNjFkdXJENnMrNTl3NXBNQkFNdERwV2dlaEQv?=
 =?iso-2022-jp?B?RFg2cXlCb1BGMWVtVnBhdVRVK3BobGJMNG15djlsWit4ZHBMU09nb3c5?=
 =?iso-2022-jp?B?M2taOS9zYnQ2ZzBiR1VVd0t1UHpPQVp2ZUpmQTFWQXdJU3dZRjBGdzQv?=
 =?iso-2022-jp?B?SUZ2WUpMNWgxT25VOUxoaEZ0M0wyUW1FK0x5d0p6VWQ3RUVaQjJ2dU5O?=
 =?iso-2022-jp?B?a1RnalF3RjVicHdQeDRFMzJJYXdFSnFMME94Y1RlOVExUlZWZHRGN2Mr?=
 =?iso-2022-jp?B?UlFyT3I0TlpuNENFRVVHODZlMzcvd0VUNUdvNzBvSjdBVkJCWjNkdGlJ?=
 =?iso-2022-jp?B?cVc5dmJkNG43OTNjZW9ibzR2bzU0cHhuVjdRWU4vdS9jNGlYdEJpVWk3?=
 =?iso-2022-jp?B?WXkvY0J5cUttektjYjlKSEF4Vmt5VTlVVEtLZkJTcFVIT1REOGUvakhT?=
 =?iso-2022-jp?B?Sk9HNWlpVWhaSUo5cWlwQTJVRlFUSGNZSWdQYnBMTGIyelM4c3E0QThs?=
 =?iso-2022-jp?B?WkFzSDFXakxtblBaRnZlRDhmYkkrMkh1RTFJR1dTSjJDalRvUXpvR2RK?=
 =?iso-2022-jp?B?V0FqWnBFallTNTRMeGNqLzFnVy9yNE1NU1VCWk5VSFREOHBEWUp0dm40?=
 =?iso-2022-jp?B?ZERIbmtEQVJZNFRucCtNMGFmYlFrNDI3a05qdDdzRkcvbkZjWThVMStt?=
 =?iso-2022-jp?B?RmVYd1p0UWFqQ3JVVk92aExlMzRCaHQ4aEVJczJlUXhmZjVzcHdkOXlR?=
 =?iso-2022-jp?B?YlU1QkN0Slo0R1luN3Vqdi92Q3NSbXNtS1Z5akFRWFI5dXZxb1VJbHZB?=
 =?iso-2022-jp?B?NmlIalBBUHpONWQzNFBhdFhNNm5ONEdaSG5rNmR0aVBnMjRqZU1sZnVC?=
 =?iso-2022-jp?B?SjM5TWlKNVZjb3RiY1VBb3F2NSsyVmZUUVRhY01TQ1pMbDdLY3o4dDZu?=
 =?iso-2022-jp?B?ME1nK0R4K01ieEE4TFl0NHZYSXhRbU4rUkd2UGNzOWVXcDdWVElvNTlD?=
 =?iso-2022-jp?B?KzF6ajhIOERJRGZzakpTL2I5RHVWTWpKa3ZTQnN2aUZELzliQTU2TUlQ?=
 =?iso-2022-jp?B?clNadE13SlVQSTdXbkhGVk1CYkdzb29BaFFTTFJRZFZzWlZOYTlBQTBR?=
 =?iso-2022-jp?B?cG5kNVdKRitCY0ZMVHNRY1RHZmtFWlZpT3hTTFJuSjdaZnd0N3ZQdm9n?=
 =?iso-2022-jp?B?d1JlN0cxT2tTM1M2Nzl4M25kbkpSQW9lLzI2K1lRdnFmVWV0NkszV1A4?=
 =?iso-2022-jp?B?OWhXWXBKb3VDOEZqVmhpZnZmQ1F2b0hmZnlLblNoczJWQTdMajNRNXNC?=
 =?iso-2022-jp?B?MTQvM0ZvTmxkaCthWWt6b3F6elFhTHdiT2ppVENTVTFqOEVZZzFqd3J6?=
 =?iso-2022-jp?B?UzFWNGNEYTE5aUIxd0c1akMrbWg1cTVWUUMzL0Y2bmZqZnlub2VHTHBM?=
 =?iso-2022-jp?B?SCtlMGlMUU1GZzVYMDRGRDZRRnI2WjJYMWd6aWxQajA2Y05Nc0ZIeVlT?=
 =?iso-2022-jp?B?cXlBa1ZoU3pwZHpsZUR4YXRGRmIyeFhTQXdLNWVzbkt1b1NEeGJ6NU9y?=
 =?iso-2022-jp?B?WWZENDkvb2wrMDFHejNCVURUVHlKWm5XYzgvTmVBaUErb2xKRzhkeDNR?=
 =?iso-2022-jp?B?Y2FnN1VNcnRpdlVFUlNoZWdPT2tOU2ZHQXo5b3JCbEREczRTb2Y2c3FX?=
 =?iso-2022-jp?B?TWh5ZjBpcEpsSUVXWlVGSitBNFZ3SExDQWNXRU94L3V6NmRvaEFHcjAw?=
 =?iso-2022-jp?B?R0g0UmNuQTJDTitlcU9lNk5KVG16cHpKdThGVWI1QlBpaVpOaFV2Y2p0?=
 =?iso-2022-jp?B?d0RQY1Z6dkl6bzdaRzczUm5NbzJKOWlreGViaHU5UkhtNHVPcnc3bFJY?=
 =?iso-2022-jp?B?Y2RBTm5ZRHFJejFKRDNnVlREbUliQzlKUkErUT09?=
Content-Type: multipart/mixed;
	boundary="_004_TYRPR01MB13457D31085CB5B246DBBA1AFE845ATYRPR01MB13457jp_"
MIME-Version: 1.0
X-Exchange-RoutingPolicyChecked: 
	b/uxUbzopqVIDgHdthU2Y+BVyebzcANI5XQbow6ovsjuaxniWMzmDu9dmSQ/iN6sTfLQqaWAcMZsuXWCT26yLGzR7uZpgYsuULOFohdUsAcsesSA2Ybdi0H4K3149RZfy8fcvS9jqhWsk39qeoSi16x+GTc84GIMa+Nm7zamppRC3TOfdmcis2dR8Kw2130TO2cgQivTtU+//oSz2uS2sk6tTKVwO+hk17Tnuv32tW+ZGosGvlph1dbp5pKAbsfCzpWoYR0iPpb2BgvkLcWQAKkoaDgZWWaYPv3qDdEXlfTPF4zZRjyElhE9o3/oEfxHUCcsj9n4DgJNxuKs2eWS1A==
X-OriginatorOrg: fujitsu.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: TYRPR01MB13457.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 da44aab9-7dca-4d23-f6f7-08de80dbeabb
X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Mar 2026 08:38:35.7373
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 aMjYUmJxaZWxGveLn8srS0tHKEU8DX5xutVH9LvKlKFlOGyPsnNe2NBK1VI8G2VUgayLowrtegZB0I1f8WCdxMgklml3sR3mGw27N8ncr8g=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS7PR01MB12081
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/TYRPR01MB13457D31085CB5B246DBBA1AFE845A%40TYRPR01MB13457.jpnprd01.prod.outlook.com>
Precedence: bulk

--_004_TYRPR01MB13457D31085CB5B246DBBA1AFE845ATYRPR01MB13457jp_
Content-Type: multipart/alternative;
	boundary="_000_TYRPR01MB13457D31085CB5B246DBBA1AFE845ATYRPR01MB13457jp_"

--_000_TYRPR01MB13457D31085CB5B246DBBA1AFE845ATYRPR01MB13457jp_
Content-Type: text/plain; charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable

Hi Hackers,

It looks like the EXPLAIN documentation is missing an explanation of the de=
fault values for the BUFFERS and SERIALIZE options.
I've attached a patch that adds this information.
While the documentation currently notes that these options are implicitly e=
nabled when ANALYZE is specified, the default values of the parameters them=
selves do not appear to be documented.

Best Regards
Ryo Matsumura

--_000_TYRPR01MB13457D31085CB5B246DBBA1AFE845ATYRPR01MB13457jp_
Content-Type: text/html; charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-2022-=
jp">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div style=3D"direction: ltr; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb=
(0, 0, 0);" class=3D"elementToProof">
Hi Hackers,</div>
<div style=3D"direction: ltr; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb=
(0, 0, 0);" class=3D"elementToProof">
<br>
</div>
<div style=3D"direction: ltr; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb=
(0, 0, 0);" class=3D"elementToProof">
It looks like the EXPLAIN documentation is missing an explanation of the de=
fault values for the BUFFERS and SERIALIZE options.</div>
<div style=3D"direction: ltr; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb=
(0, 0, 0);" class=3D"elementToProof">
I've attached a patch that adds this information.</div>
<div style=3D"direction: ltr; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb=
(0, 0, 0);" class=3D"elementToProof">
While the documentation currently notes that these options are implicitly e=
nabled when ANALYZE is specified, the default values of the parameters them=
selves do not appear to be documented.</div>
<div style=3D"direction: ltr; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb=
(0, 0, 0);" class=3D"elementToProof">
<br>
</div>
<div style=3D"direction: ltr; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb=
(0, 0, 0);" class=3D"elementToProof">
Best Regards</div>
<div style=3D"direction: ltr; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb=
(0, 0, 0);" class=3D"elementToProof">
Ryo Matsumura</div>
</body>
</html>

--_000_TYRPR01MB13457D31085CB5B246DBBA1AFE845ATYRPR01MB13457jp_--

--_004_TYRPR01MB13457D31085CB5B246DBBA1AFE845ATYRPR01MB13457jp_
Content-Type: application/octet-stream;
	name="v1-0001-Docs-clarify-default-values-in-EXPLAIN-documentat.patch"
Content-Description: 
 v1-0001-Docs-clarify-default-values-in-EXPLAIN-documentat.patch
Content-Disposition: attachment;
	filename="v1-0001-Docs-clarify-default-values-in-EXPLAIN-documentat.patch";
	size=1191; creation-date="Fri, 13 Mar 2026 02:16:03 GMT";
	modification-date="Fri, 13 Mar 2026 08:38:35 GMT"
Content-Transfer-Encoding: base64

RnJvbSA4Zjk4ZDVjYjFjMTk1YjNmZjNmY2VkNzYzYTU0NzQ4NmM0YjczY2IwIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBSeW8gTWF0c3VtdXJhIDxyeW9AVk0wMDEzMzcyOS5sb2NhbGRv
bWFpbj4KRGF0ZTogRnJpLCAxMyBNYXIgMjAyNiAxMDo1OToyNSArMDkwMApTdWJqZWN0OiBbUEFU
Q0ggdjFdIERvY3M6IGNsYXJpZnkgZGVmYXVsdCB2YWx1ZXMgaW4gRVhQTEFJTiBkb2N1bWVudGF0
aW9uLgoKLS0tCiBkb2Mvc3JjL3NnbWwvcmVmL2V4cGxhaW4uc2dtbCB8IDIgKysKIDEgZmlsZSBj
aGFuZ2VkLCAyIGluc2VydGlvbnMoKykKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvcmVmL2V4
cGxhaW4uc2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYvZXhwbGFpbi5zZ21sCmluZGV4IDdkZWU3N2Zk
MzY2Li4wMDczYTY4YjZlNiAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3JlZi9leHBsYWluLnNn
bWwKKysrIGIvZG9jL3NyYy9zZ21sL3JlZi9leHBsYWluLnNnbWwKQEAgLTIwMyw2ICsyMDMsNyBA
QCBST0xMQkFDSzsKICAgICAgIHVwcGVyLWxldmVsIG5vZGUgaW5jbHVkZXMgdGhvc2UgdXNlZCBi
eSBhbGwgaXRzIGNoaWxkIG5vZGVzLiAgSW4gdGV4dAogICAgICAgZm9ybWF0LCBvbmx5IG5vbi16
ZXJvIHZhbHVlcyBhcmUgcHJpbnRlZC4gIEJ1ZmZlcnMgaW5mb3JtYXRpb24gaXMKICAgICAgIGF1
dG9tYXRpY2FsbHkgaW5jbHVkZWQgd2hlbiA8bGl0ZXJhbD5BTkFMWVpFPC9saXRlcmFsPiBpcyB1
c2VkLgorICAgICAgSXQgZGVmYXVsdHMgdG8gPGxpdGVyYWw+RkFMU0U8L2xpdGVyYWw+LgogICAg
ICA8L3BhcmE+CiAgICAgPC9saXN0aXRlbT4KICAgIDwvdmFybGlzdGVudHJ5PgpAQCAtMjMxLDYg
KzIzMiw3IEBAIFJPTExCQUNLOwogICAgICAgU2VyaWFsaXphdGlvbiBtYXkgb25seSBiZSBlbmFi
bGVkIHdoZW4gPGxpdGVyYWw+QU5BTFlaRTwvbGl0ZXJhbD4gaXMKICAgICAgIGFsc28gZW5hYmxl
ZC4gIElmIDxsaXRlcmFsPlNFUklBTElaRTwvbGl0ZXJhbD4gaXMgd3JpdHRlbiB3aXRob3V0IGFu
CiAgICAgICBhcmd1bWVudCwgPGxpdGVyYWw+VEVYVDwvbGl0ZXJhbD4gaXMgYXNzdW1lZC4KKyAg
ICAgIEl0IGRlZmF1bHRzIHRvIDxsaXRlcmFsPkZBTFNFPC9saXRlcmFsPi4KICAgICAgPC9wYXJh
PgogICAgIDwvbGlzdGl0ZW0+CiAgICA8L3Zhcmxpc3RlbnRyeT4KLS0gCjIuNDcuMwoK

--_004_TYRPR01MB13457D31085CB5B246DBBA1AFE845ATYRPR01MB13457jp_--