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 1wNUz4-000r9h-1k for pgsql-docs@arkaria.postgresql.org; Thu, 14 May 2026 12:16:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wNUy4-00C3fb-1Y for pgsql-docs@arkaria.postgresql.org; Thu, 14 May 2026 12:15:08 +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.96) (envelope-from ) id 1wNUy4-00C3fS-0E for pgsql-docs@lists.postgresql.org; Thu, 14 May 2026 12:15:08 +0000 Received: from mail-qk1-x733.google.com ([2607:f8b0:4864:20::733]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wNUy2-00000000Ww4-189T for pgsql-docs@lists.postgresql.org; Thu, 14 May 2026 12:15:07 +0000 Received: by mail-qk1-x733.google.com with SMTP id af79cd13be357-8eb5ad01402so794016785a.2 for ; Thu, 14 May 2026 05:15:06 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1778760905; cv=none; d=google.com; s=arc-20240605; b=MGfLBuhvbPjr03FSaaRD05CuDmcsEWiLVijMLZUExxin5CKxobq3AxTmJx9GBVnhK+ SZ8Qx7iK/6WaizIDt50hKTsnsbzngsc+H4b80GWb1grRZhOeK9wjMPp8HVpwsPdWjPdA TQWHIkCJlzu2o0jiCZRf1Y0yWd4jllVWQuJGU6WHq15mbqvUIpo2pXP3eFksGQq8OQW8 kRfJ5K0qcXHw574Rc6/a+mW0hg3U6zwHLOpcEnUxNYWlTvLp4055HeOSnHGq0oHoFKRO mKheBUaIm9frpGk8vVXRaLGd0OyHfeuJ4TDIOVZj8L33ApT3y4VCy2u3MdN7W43amdLQ iUZg== 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=QnPkMTsyLt5XlXlHY0E4601FuIeOFa2zApr6MChgMW0=; fh=QRFPItdeInbd8sgSzYXIKm4NCRHsj0WXRl8OFrBP5M4=; b=U/pKiXo8QQ5sNweakqRISPJM4uzQ7OajxqiysFNPmfVl4lASxllcwwyrjZKSXewQTj PTRWYDGlXiL6wBLIfOILDXa++fmP09jbUuczGUt7KKs6EqCfpfz33r79ocAB1NJ1itpu 3QqgW9ogHPrA6I+Coier10kq7sNfSI53dxX0JD2nmqB72z/JpDOrTMF606LnC9sB7MhH J9YN4hS0l3KG4A+6wfiCiJbbnU4QgFgEFzxzsqDFoo5y2dH1WtGhFa4KkRPtrlIt8Vx2 jOwlGLlcQFelPmdAlWAxUyYXM3E/7oXFWL44Skfm+5rbeYYFxm3R2I+3WD2RwQs3PePk y7bg==; darn=lists.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=20251104; t=1778760905; x=1779365705; darn=lists.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=QnPkMTsyLt5XlXlHY0E4601FuIeOFa2zApr6MChgMW0=; b=LWcH8RSHnGdR7Umh15PCGr3MFgRbS06yx8BFRA/r9j51XqgjY/He/ab+PSjNWH+eR0 aJDLwbUXhS6KUzN1v1jNtopCHnrs8xJpFlkFp2w+BctMn1JmFrHDgJrUf8BvxAe02rZW rJmP5BkDAPXCJ9H7ZqwzDZGbepTV97V6cX8EAheXunsql2/L4pQzrOrqacf3S7LlTLCf jqY0Kf/wslOEq3ZV6uV+yYertseJFqKQXZ+AkIGYxCzOIq3NEK34rL3F/XltEYs0orTy jVcF0Bz9WRqA2y2YyrTdl33Y/GPXTfhNgN09idKntLYXroUT32ae9Z+pjEKKTCRVk7sA 5niw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1778760905; x=1779365705; 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=QnPkMTsyLt5XlXlHY0E4601FuIeOFa2zApr6MChgMW0=; b=HUA+FtJh1UyrqP2GJsmM8lB49xV/xr70tuFv2IUXt/9NlLpHGt+0SXe+5G+KOpKqM+ mnk5DYTsyIRi+lBsrj9Vm0ADt9tLWu8U5LUIexb6/rvKklOzMQf7TcYRNR5gYcJUPPao KJPlsJvR4Ob3A4e8laCVl4/+cZbSbay5Xdy60iE6yERjgNu2GIzwX5dzEH6Zm4TIyrvw qDe55R1PseopSOt1DpZqmqZT4wZ+KZHUcD8Dgx9zCk/yfHPWGztqYFuev503LLdDWrCM KAH98v79fADYXnIlJ2iklCK/vAUbxLpwVuGMGTtsnagGVrb/rVEavQ2+1jffCznZzJAs zp/Q== X-Forwarded-Encrypted: i=1; AFNElJ8X4BpUx06aD6Mjzmf6iD51mZOeDjO4QkJbEgP0VMQpeoI0y/tdkMcO/6HQDV7jRPwJZyEqSJ7PVs2M@lists.postgresql.org X-Gm-Message-State: AOJu0YzI7wHwgVDtzIxZd91Xig9mb6TEPESSjUfoPbtYYK62O+ocCauS 36YVZTXd6Ed2nOSi4OSa3otQ18nitPIZsJ8r72FFswYXcJO3BWK7o6c7uMAbvl9PtGJOSJXQ03t I+eeU4uZvj14ctc/bAFr4UFtGfsrgDg== X-Gm-Gg: Acq92OFDO7FT+2A1NtnVq95k+YZLDcLZRi5LdogB7gDIzNuE7yGAWgumFF6eHyr7tDW aEriUtNgVf7WFVyWr6dTDMKGjPT49DCNeAgmO4s1dRLKUo4D3VIQ+BxNIFJV6hh06D5kjy9FLq8 qz4r8inM7VEcot/GZehunBjwfYpi1/vtMlFdAsp4mNE9TjA1ZhBcqXRffYC+8PD/8bvhDrhGYCa 6Vr4k3h+BWmhCiA6JD3UUfi6IAZghCyEf3z8dWSJw1dCMZ7oZ5kQ2VgBhkSKQHjmwJi/6GPWJP/ yuKGDF4KZJWgEoMcptB46oXoRuXU/PqDEA== X-Received: by 2002:a05:620a:44c6:b0:90d:e71:8900 with SMTP id af79cd13be357-90f88ba6094mr1123493385a.10.1778760904500; Thu, 14 May 2026 05:15:04 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Shinya Kato Date: Thu, 14 May 2026 21:14:27 +0900 X-Gm-Features: AVHnY4IQL1f_kAfXFkJrAlg2C7MstqllgcUnZrEBcusYO36Slc-h_ks0zwfjaXg Message-ID: Subject: Re: doc: Clarify ANALYZE VERBOSE output To: maciek@sakrejda.org Cc: surya poondla , pgsql-docs@lists.postgresql.org Content-Type: multipart/mixed; boundary="000000000000db07d30651c60b90" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000db07d30651c60b90 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, May 12, 2026 at 5:15=E2=80=AFAM Maciek Sakrejda wrote: > > On Tue, May 5, 2026 at 4:26=E2=80=AFPM surya poondla wrote: > > On the wording debate: I think David and Maciek are both pointing at > > the same real issue, the description should convey (a) "what kind of > > information" users will see, and (b) "when" they'll see it. > > > > Given that, I'd suggest leaning toward something like: > > "Sends a detailed INFO message to the client for each table as it is pr= ocessed." > > > > I feel with the above message we balance, the server's perspective ("se= nds" rather than "prints"), and conveys timing ("after each table is proces= sed"). > > I agree with the analysis, and I think the proposed wording works well. > > > This same phrasing could work for both VACUUM and ANALYZE VERBOSE, keep= ing them consistent. > > +1 for consistency. Sorry for the delayed response, and thank you for the feedback. I agree with the points raised, so I have updated the patch accordingly. --=20 Best regards, Shinya Kato NTT OSS Center --000000000000db07d30651c60b90 Content-Type: application/octet-stream; name="v2-0001-doc-Clarify-VERBOSE-output-for-ANALYZE-and-VACUUM.patch" Content-Disposition: attachment; filename="v2-0001-doc-Clarify-VERBOSE-output-for-ANALYZE-and-VACUUM.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mp5gaenf0 RnJvbSA3MWI0ODc4OTE4YWJmODkxNWM3Y2JmZWEyNGI5MDY2OGE3OTNjNjFlIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBTaGlueWEgS2F0byA8c2hpbnlhMTEua2F0b0BnbWFpbC5jb20+ CkRhdGU6IFRodSwgMTQgTWF5IDIwMjYgMjE6MTI6MDQgKzA5MDAKU3ViamVjdDogW1BBVENIIHYy XSBkb2M6IENsYXJpZnkgVkVSQk9TRSBvdXRwdXQgZm9yIEFOQUxZWkUgYW5kIFZBQ1VVTQoKQU5B TFlaRSBWRVJCT1NFIGVtaXRzIGEgZGV0YWlsZWQgcGVyLXRhYmxlIElORk8gbGV2ZWwgcmVwb3J0 LCBsaWtlClZBQ1VVTSBWRVJCT1NFLiAgUmV3b3JkIGJvdGggb3B0aW9uIGRlc2NyaXB0aW9ucyB0 byBjb252ZXkgdGhlCnNlcnZlcidzIHBlcnNwZWN0aXZlICgic2VuZHMiIHJhdGhlciB0aGFuICJw cmludHMiKSBhbmQgdG8gY2xhcmlmeQp0aGUgdGltaW5nIG9mIHRoZSBvdXRwdXQuICBVc2UgaWRl bnRpY2FsIHdvcmRpbmcgZm9yIHRoZSB0d28gY29tbWFuZHMKZm9yIGNvbnNpc3RlbmN5LgoKQXV0 aG9yOiBTaGlueWEgS2F0byA8c2hpbnlhMTEua2F0b0BnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBN YWNpZWsgU2FrcmVqZGEgPG0uc2FrcmVqZGFAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogRnVqaWkg TWFzYW8gPG1hc2FvLmZ1amlpQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IERhdmlkIEcuIEpvaG5z dG9uIDxkYXZpZC5nLmpvaG5zdG9uQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IFN1cnlhIFBvb25k bGEgPHN1cnlhcG9vbmRsYTRAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogWXVzaHUgQ2hlbiA8Z2Vu dGN5c0BnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FPekV1clRw TVRVRVc4a0h1LXpLQjBFQnR1UGZwdnlvSi0tOHB4S2U4N3AyNEJHcnBnQG1haWwuZ21haWwuY29t Ci0tLQogZG9jL3NyYy9zZ21sL3JlZi9hbmFseXplLnNnbWwgfCAzICsrLQogZG9jL3NyYy9zZ21s L3JlZi92YWN1dW0uc2dtbCAgfCA0ICsrLS0KIDIgZmlsZXMgY2hhbmdlZCwgNCBpbnNlcnRpb25z KCspLCAzIGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvYW5hbHl6 ZS5zZ21sIGIvZG9jL3NyYy9zZ21sL3JlZi9hbmFseXplLnNnbWwKaW5kZXggZWM4MWYwMGZlY2Yu LmFlZTdhNGY1NjBkIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvcmVmL2FuYWx5emUuc2dtbAor KysgYi9kb2Mvc3JjL3NnbWwvcmVmL2FuYWx5emUuc2dtbApAQCAtNjUsNyArNjUsOCBAQCBBTkFM WVpFIFsgKCA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+b3B0aW9uPC9yZXBsYWNlYWJs ZT4gWywgLi4uXSApIF0gWyA8cgogICAgIDx0ZXJtPjxsaXRlcmFsPlZFUkJPU0U8L2xpdGVyYWw+ PC90ZXJtPgogICAgIDxsaXN0aXRlbT4KICAgICAgPHBhcmE+Ci0gICAgICBFbmFibGVzIGRpc3Bs YXkgb2YgcHJvZ3Jlc3MgbWVzc2FnZXMgYXQgPGxpdGVyYWw+SU5GTzwvbGl0ZXJhbD4gbGV2ZWwu CisgICAgICBTZW5kcyBhIGRldGFpbGVkIDxsaXRlcmFsPklORk88L2xpdGVyYWw+IG1lc3NhZ2Ug dG8gdGhlIGNsaWVudAorICAgICAgZm9yIGVhY2ggdGFibGUgYXMgaXQgaXMgcHJvY2Vzc2VkLgog ICAgICA8L3BhcmE+CiAgICAgPC9saXN0aXRlbT4KICAgIDwvdmFybGlzdGVudHJ5PgpkaWZmIC0t Z2l0IGEvZG9jL3NyYy9zZ21sL3JlZi92YWN1dW0uc2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYvdmFj dXVtLnNnbWwKaW5kZXggYmQ1ZGNhZjg2YTUuLjA2ZjY0ZjM4MjdmIDEwMDY0NAotLS0gYS9kb2Mv c3JjL3NnbWwvcmVmL3ZhY3V1bS5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9yZWYvdmFjdXVtLnNn bWwKQEAgLTEyOSw4ICsxMjksOCBAQCBWQUNVVU0gWyAoIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFy YW1ldGVyIj5vcHRpb248L3JlcGxhY2VhYmxlPiBbLCAuLi5dICkgXSBbIDxyZQogICAgIDx0ZXJt PjxsaXRlcmFsPlZFUkJPU0U8L2xpdGVyYWw+PC90ZXJtPgogICAgIDxsaXN0aXRlbT4KICAgICAg PHBhcmE+Ci0gICAgICBQcmludHMgYSBkZXRhaWxlZCB2YWN1dW0gYWN0aXZpdHkgcmVwb3J0IGZv ciBlYWNoIHRhYmxlCi0gICAgICBhdCA8bGl0ZXJhbD5JTkZPPC9saXRlcmFsPiBsZXZlbC4KKyAg ICAgIFNlbmRzIGEgZGV0YWlsZWQgPGxpdGVyYWw+SU5GTzwvbGl0ZXJhbD4gbWVzc2FnZSB0byB0 aGUgY2xpZW50CisgICAgICBmb3IgZWFjaCB0YWJsZSBhcyBpdCBpcyBwcm9jZXNzZWQuCiAgICAg IDwvcGFyYT4KICAgICA8L2xpc3RpdGVtPgogICAgPC92YXJsaXN0ZW50cnk+Ci0tIAoyLjQ3LjMK Cg== --000000000000db07d30651c60b90--