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.96) (envelope-from ) id 1w2WRR-000Mj9-0D for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Mar 2026 15:34:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2WRP-002gkf-2w for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Mar 2026 15:34:43 +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.96) (envelope-from ) id 1w2WRP-002gkX-1t for pgsql-hackers@lists.postgresql.org; Tue, 17 Mar 2026 15:34:43 +0000 Received: from mail-ot1-x329.google.com ([2607:f8b0:4864:20::329]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2WRM-00000000csd-2aTd for pgsql-hackers@postgresql.org; Tue, 17 Mar 2026 15:34:43 +0000 Received: by mail-ot1-x329.google.com with SMTP id 46e09a7af769-7d7c77fd31cso190398a34.3 for ; Tue, 17 Mar 2026 08:34:40 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773761679; cv=none; d=google.com; s=arc-20240605; b=lhieH6riUEvC2VLCGDvmFnmSB0EFQOdPp8hsvwEHg82kL7EMxIGVog9ntlRLD8rIya MgDcjhXQbqLi4AmubILrsjXAnPiona6K+RaeNm7BwuMfTwyPoGeMBl9Fitf3R/PKQmoJ reStapXMErjMedOSz7jDDQxdjBWeRS7Y16WtkI9tVLPZf1sItCxOIVI1hDIstsGJpGG4 ho1wrQZ2SM1RxG1ShI4H3PVhVpHNa+9C1jzs0m3sbIgX961/PxPJ6oFZmg3NU3rLcY5v YDdJ5h5eeixgQbtpmzmOIK5lnSrceQCRO6PEfhTZNv5Z7+z8AaaZErPjklGrR7KM8nNB Ckcg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=Eeco75Drv56WyM9Q/1vGUiRUoNtC0U/xPCK1fU/7NaM=; fh=/ZUOKjGOSEhFKeJGlhWbcIXcOIRtWcv8IW6wLuAGEQg=; b=SPTKqWetrs5QWCgnPubLwbUcn8rrRQoUYQXexAUbrdxhmiKzgPGq6TYOh13tPPt0NO iJhqfW8Nns8+8gn6OhMlDPlGjc0TWFyg8v8DouV3ju56c+Lrgw0PhDPCkcINOCQMNLmu +Tlx8itPcBh+FWVGMkpMR0Filbzd5VBOilemJghOv/LfduxlD0XZNuWX5fWF8FXDHYJw Xe5Ej3yf166rByCJYSKh1e0t1avYhFLWTGIOy85jc+diA3ajHGEiEgqCUfmDJQp++5uO 9lesAqrj3C9uZm/CbZvByKd5cqMcvOjzmvxdTcsRH292V/R29PiiGUgeAqvikGbV3JSF lFFA==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773761679; x=1774366479; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Eeco75Drv56WyM9Q/1vGUiRUoNtC0U/xPCK1fU/7NaM=; b=nX46RxUK9Ga/mhYlKTv/BCQt3wX9u0JblJWqYwnlIpuWGT4KOlpQtotMGLB6m2A2jR +1+YgB7sp8PzmZYUtLQcfqOtekkHkYkzcnznJ6kqt0p0Y9xWu7mTuaEEcZvXTVVaBBp4 ODk3/5/GIrxKSSH4HYVVsamXXvr9v/iTUI9NmfoIs/8YRr5FeTfxs+sZN5zEwv2kFoOe hhTqnQtd1uBU1CKK6371HzZlarKw0MGu3G0Z53bGZbJ+dlcRkcg/Bria2/Zwp817sniN AI1/b5ut1gkT3CB7DQOclBVWxJ1d0gaXWTPhlOajMD8QPfZfjzmOpAfHnc6XzN0yy462 Pdxg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773761679; x=1774366479; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Eeco75Drv56WyM9Q/1vGUiRUoNtC0U/xPCK1fU/7NaM=; b=pxQ9/yH2iayT+kbbGWsuWS6w++Ik2gHuurATTpNyzUod4Gq6c9f9kBuAGK8EFCFqSl WCItLzArb/dSg6nOVwEqVQEk0TPrntVa+B2Xib9qOAb+sWiWyaC8wdCKMTvdAMlkMnfI evF0tmtv17eG+2zHYvp6+XI5PotO9kArsuiN8lPi3omfZlhMcrgWr/fp1sCStsjYCAeY f2TWVTXiqwH05yMcw6RHxd8Vgj0juSmYvTAF7pIdfoI4Y1HMiF35vSqX0VdXOSXRl/wX ndk517Gip6iJbvnywQWDAJj7RoBK+6/UQg00reCwFG/erslLafId2IP1H+bqxuO6L+jh WmBA== X-Gm-Message-State: AOJu0Yy0lHNU6HeD8fX0WGfjWnmp2ptvB156BPrT/U5ARaFwszBxUIW4 FL9FNNAdNCj6mydsXDjxkbfJE+AggH7DAKq41Vk3n4iOIWbN5jLC14cB9YdiTtTJ72cFg9kRPFU nHV5tKgOO+7ljxdqH/uat85Ey+R2OXk4= X-Gm-Gg: ATEYQzyWqijtkI9nydrmDsRQ2qLD6uLhmor6Bg76GQv6T5CqaCAB4jaGo/7G6j1ZkRg G1dFdPmJXbeYGLbhA6S95aq8OWxvvpaffAa0WBay101x3YI16Htn/SuIdn5GGPmS7MQbaDH4/nj Y7kPC2zayx6uOEloTb7zDeTidnbCCGIgXn/lpBvZIWevinAr7eo99prYaQ02HMj224UtXLfw9oP mix5RjUSWUARedh7kZN1U730H3L+gPE7Pn8Ee6LC08Pl5g9oICEPlxgtYTO5dxctK/M4WI/mo1k MVThM8DlOwjXPGjLprgNY+vk/wv6Fwzu3TElKptmeA== X-Received: by 2002:a05:6820:498e:b0:67b:b405:77d with SMTP id 006d021491bc7-67bda9b0626mr9047364eaf.17.1773761678766; Tue, 17 Mar 2026 08:34:38 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Fujii Masao Date: Wed, 18 Mar 2026 00:34:26 +0900 X-Gm-Features: AaiRm51FyQ6ZChPOe8T2rRpkDjmJ24RluuNQD5t0JLLGK3svc01P5NMlEdowpt4 Message-ID: Subject: Re: [PATCH] Docs: clarify default values of EXPLAIN BUFFERS and SERIALIZE To: =?UTF-8?B?TWF0c3VtdXJhLCBSeW8v5p2+5p2RIOmHjw==?= Cc: PostgreSQL-development Content-Type: multipart/mixed; boundary="000000000000c79d9c064d3a121d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c79d9c064d3a121d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Mar 17, 2026 at 7:26=E2=80=AFPM Matsumura, Ryo/=E6=9D=BE=E6=9D=91 = =E9=87=8F wrote: > > On Mon, Mar 16, 2026 at 10:30:00 +0000, Fujii Masao wrote: > > Isn't the existing description "In text format, only non-zero values > > are printed." sufficient? > > This description is sufficient. It was a careless mistake on my part. Sor= ry about that. > > I=E2=80=99ve attached a revised patch. Thanks for updating the patch! Since the docs already state that buffer usage is automatically included when ANALYZE is used, the focus here seems to be clarifying the behavior of BUFFERS without ANALYZE. From that perspective, it might be better to explicitly describe what happens when BUFFERS is TRUE without ANALYZE. I've updated the patch accordingly. Patch attached. Thought? Regards, --=20 Fujii Masao --000000000000c79d9c064d3a121d Content-Type: application/octet-stream; name="v4-0001-doc-Clarify-BUFFERS-behavior-without-ANALYZE-in-E.patch" Content-Disposition: attachment; filename="v4-0001-doc-Clarify-BUFFERS-behavior-without-ANALYZE-in-E.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mmurwamt0 RnJvbSA3N2YxNmE3ZjVmNjM0OGU4MDQxMWIyYjdhNDQyMWIwOTRiZTk1NDM0IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5vcmc+CkRh dGU6IFR1ZSwgMTcgTWFyIDIwMjYgMjM6MTc6NDkgKzA5MDAKU3ViamVjdDogW1BBVENIIHY0XSBk b2M6IENsYXJpZnkgQlVGRkVSUyBiZWhhdmlvciB3aXRob3V0IEFOQUxZWkUgaW4gRVhQTEFJTgoK VGhpcyBjb21taXQgY2xhcmlmaWVzIHRoZSBkb2N1bWVudGF0aW9uIGZvciB0aGUgQlVGRkVSUyBv cHRpb24gb2YgRVhQTEFJTgpieSBleHBsaWNpdGx5IGRlc2NyaWJpbmcgaXRzIGJlaGF2aW9yIHdo ZW4gQU5BTFlaRSBpcyBub3Qgc3BlY2lmaWVkLgoKQXV0aG9yOiBSeW8gTWF0c3VtdXJhIDxtYXRz dW11cmEucnlvQGZ1aml0c3UuY29tPgpSZXZpZXdlZC1ieTogRnVqaWkgTWFzYW8gPG1hc2FvLmZ1 amlpQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9UWVJQUjAxTUIx MzQ1N0QzMTA4NUNCNUIyNDZEQkJBMUFGRTg0NUFAVFlSUFIwMU1CMTM0NTcuanBucHJkMDEucHJv ZC5vdXRsb29rLmNvbQotLS0KIGRvYy9zcmMvc2dtbC9yZWYvZXhwbGFpbi5zZ21sIHwgNSArKysr LQogMSBmaWxlIGNoYW5nZWQsIDQgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoKZGlmZiAt LWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvZXhwbGFpbi5zZ21sIGIvZG9jL3NyYy9zZ21sL3JlZi9l eHBsYWluLnNnbWwKaW5kZXggN2RlZTc3ZmQzNjYuLjViOGI1MjE4MDJlIDEwMDY0NAotLS0gYS9k b2Mvc3JjL3NnbWwvcmVmL2V4cGxhaW4uc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvcmVmL2V4cGxh aW4uc2dtbApAQCAtMjAyLDcgKzIwMiwxMCBAQCBST0xMQkFDSzsKICAgICAgIFRoZSBudW1iZXIg b2YgYmxvY2tzIHNob3duIGZvciBhbgogICAgICAgdXBwZXItbGV2ZWwgbm9kZSBpbmNsdWRlcyB0 aG9zZSB1c2VkIGJ5IGFsbCBpdHMgY2hpbGQgbm9kZXMuICBJbiB0ZXh0CiAgICAgICBmb3JtYXQs IG9ubHkgbm9uLXplcm8gdmFsdWVzIGFyZSBwcmludGVkLiAgQnVmZmVycyBpbmZvcm1hdGlvbiBp cwotICAgICAgYXV0b21hdGljYWxseSBpbmNsdWRlZCB3aGVuIDxsaXRlcmFsPkFOQUxZWkU8L2xp dGVyYWw+IGlzIHVzZWQuCisgICAgICBpbmNsdWRlZCBieSBkZWZhdWx0IHdoZW4gPGxpdGVyYWw+ QU5BTFlaRTwvbGl0ZXJhbD4gaXMgdXNlZCBidXQKKyAgICAgIG90aGVyd2lzZSBpcyBub3QgaW5j bHVkZWQgYnkgZGVmYXVsdC4gIFdoZW4gdGhpcyBwYXJhbWV0ZXIgaXMKKyAgICAgIDxsaXRlcmFs PlRSVUU8L2xpdGVyYWw+IHdpdGhvdXQgPGxpdGVyYWw+QU5BTFlaRTwvbGl0ZXJhbD4sCisgICAg ICBvbmx5IGJ1ZmZlciB1c2FnZSBkdXJpbmcgdGhlIHF1ZXJ5IHBsYW5uaW5nIHBoYXNlIGlzIHJl cG9ydGVkLgogICAgICA8L3BhcmE+CiAgICAgPC9saXN0aXRlbT4KICAgIDwvdmFybGlzdGVudHJ5 PgotLSAKMi41MS4yCgo= --000000000000c79d9c064d3a121d--