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 1wAIAm-002F3N-1n for pgsql-docs@arkaria.postgresql.org; Wed, 08 Apr 2026 01:57:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wAIAk-003rKL-2C for pgsql-docs@arkaria.postgresql.org; Wed, 08 Apr 2026 01:57:39 +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 1wAIAk-003rKD-1M for pgsql-docs@lists.postgresql.org; Wed, 08 Apr 2026 01:57:38 +0000 Received: from mail-qv1-xf2d.google.com ([2607:f8b0:4864:20::f2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wAIAi-00000001Dhc-12wP for pgsql-docs@lists.postgresql.org; Wed, 08 Apr 2026 01:57:38 +0000 Received: by mail-qv1-xf2d.google.com with SMTP id 6a1803df08f44-89fc349b5c2so55602486d6.0 for ; Tue, 07 Apr 2026 18:57:36 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775613454; cv=none; d=google.com; s=arc-20240605; b=PF9c8rvpYf5eVFBhCpUCv0LaIkWulL6JDNcr8xMyEjdZesV4mQgkA0XSPODb58Yib/ kslGYACe7+Yadd2/D8BBwiyylTpfJDHMag0HvEBeltpTciJu2UNxO0YqnVIEGEPztgpp im2gTRAOQQDh239E2JOGErjM8XzUQg/w4aKcR8ExlI+DzDuc/vDG5Xblx4vS8luTn5p8 hcfbFwk+owKpbAuTg/Ga7GeEiv9nd94TcGRH/j/b0083eB2USi9FBjGRaoWXezcbn1bg BJOu3X1wNCpBDa1OHz4XOnixbFju/9UBu4XhK/rNxGVnrwZQeIGEZBZuptn6Opt5Suqr Y8Uw== 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=/1gXBpgiMlqu6IW4QCMlSXQNDOiB1Wi3lCiJ3JXkH6E=; fh=/anFxzcN8yG+RoC8VlmVV0pFmqyiLsKLoV0pT/ofC3U=; b=Of395+I6bnX0QgGBp0naNthRQIMRNpKDpn+ghUwdTmoTXcaWqrB06cnFjyhelbBXen gp8PatHU1xyCAA+e5g010W5TUsrBRJNp5o2qbP6NoDa89Jd3gIcUJrtcvGDmkUy3mGTs qevnP/2y9AnDUXvNCM8dUu1LebaVMO15d166lK30QVtbRec7xzl+/EB+27BVe3a/Vh+w Ed+FpmKiOat1HsVZ4Jd2/UH3mDdOsWc6pIsdxYWf3SLVw5wmrC3W/Pbhqqt4v0zJlz3S lGLc3RocJz2gbQwCiZ+1VFgASpNyq0TAf3hulasiAVlxQwQdffoKA+Q3VOmND1mtVidc AlrQ==; 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=1775613454; x=1776218254; 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=/1gXBpgiMlqu6IW4QCMlSXQNDOiB1Wi3lCiJ3JXkH6E=; b=cpH7TCLM8lAbFcQ+TiiREqkNIVeKgpGTqEf1F/QYse9TNf6a0CfiIHkQVCl1Rp/l0A 2fgI6gpurQA2sDoxjgbWV6qAz7CGhScXXdpifpeCidTnSVl0lmU6MVucG7QhquvKtpvs GVM7Ryu9XJfrSqMEJWZ7bUcz9+yH0uUKbMuS2xkt8NMF8t8C55N3IGXfRIe7dsnR9F+4 qtWxj18mUnFGGrdi1Gjd13SLTvR2xRxYA/pVYEVeiaPRtGq3mZxaR5aqyKP3qUhj4PnY l4pWBzE7vv05VzOmto7OPVw1GNSe1VRcr5Ao4NzjUQpd3xKWZ0XK3Hn9QwAG9x+NrKnI iKIA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775613454; x=1776218254; 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=/1gXBpgiMlqu6IW4QCMlSXQNDOiB1Wi3lCiJ3JXkH6E=; b=BCEtnSl1OGweywOHs5ooDn9/rfFhsaZ6mC3PkqrGz1iMFVd/IIiryPHwwhsHtwkfu6 vlSneKcsH5qCtRdKtQ6hqcDhMOc3RiochN17hR7x8p5HKfmKscV8xGYDgb2/EBLQZaLn f+8O1SEXI7GBbC/citS1aR0XceUyVeaXhxJ5AzPxGesVTrL3D+otqhZVvYMv7OdHz8x8 DLCUOijRa41xxpDjN8Jhr2rnPINICJjdEkSf/KMScZF4vlnJpqXiIajblHC1yiUvBVeF clyzDEZDvq7DrNl5RyLhYV+utSnFQlRz1Cr2fi3artTlfH6Ktuca32tMwvrFQ22VS4ah n10g== X-Forwarded-Encrypted: i=1; AJvYcCX88E4cRW9NWf+CC4IHcFPW7q1tjeM3wSAZZ/s24YK/HWh38PfBxfUNF3r55YFVdZ008BSh0BchUY8a@lists.postgresql.org X-Gm-Message-State: AOJu0YxD0X0RLDZIcIVLK59CpynuYzqMWQROp1kz/76WAnvkVGop9U+0 26HKDNWG+/A969hQHSRqNXbKOH6eJUGgelRHWlrJ1mb5PS37AEuerG0tP0Gvk+qhbeEe78f7jnY 4hKn4w8CC0syGBVdhJ/d4a4hs27JBnA== X-Gm-Gg: AeBDietwq4tFwQb/f+CMzZDsx/EsRP1Dih+VxDzjY3sasn96zQMVkLPW9pdDgfCXgnu Ne6nBWI1ilQg17Dwy8alWfJuHLKQvHnAxYxSi0EwS4fgh8NCt/l2DBlatOU6g54nAdD0xh4e4RK aLXkf9plKAYiPpq8gnWfHiJtYTWZcFfsYmIIPsXXQJSmz2ftEpMp/HhLAAmEEcANdfO7qBUBeKE g7WYujLhclR0qaoedG7fMmvbWMaWoHqZ2A3eeblAvIzlDGjRcieJxHmNLnbwNyRcSlrR+CZv7dE ZlgkhOa+mvf2rEwbM7vbZbYXR/Jgc3U= X-Received: by 2002:a05:6214:8084:b0:89c:8cc8:7c6a with SMTP id 6a1803df08f44-8a7020c09ffmr289735186d6.5.1775613454413; Tue, 07 Apr 2026 18:57:34 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Shinya Kato Date: Wed, 8 Apr 2026 10:49:24 +0900 X-Gm-Features: AQROBzBQmV30k7kbcCXLs-F5o-wn_CpOSKRXFbUlcBY-eaGtl-ymBLI5CB35EsQ Message-ID: Subject: Re: doc: Clarify ANALYZE VERBOSE output To: "David G. Johnston" Cc: Fujii Masao , maciek@sakrejda.org, pgsql-docs@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000357259064ee9390b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000357259064ee9390b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Apr 6, 2026, 14:17 David G. Johnston wrote: > > How about something like: > =E2=80=9CEnables sending an INFO message to the client (and server log) a= s each > table is processed. This message contains: etc=E2=80=A6=E2=80=9D > > And then let=E2=80=99s tell the user what info they are getting and what = it means > (where necessary). > > I concur being specific about when these messages arrive, and IMO where, > should be specified. But losing the detail of =E2=80=9Creport=E2=80=9D i= s not good; but > not sure why we are being vague so suggest we just go all-in on specifici= ty. > Thank you for the suggestion. I'd prefer to keep this patch focused; since the verbose output of both commands is subject to change, listing every individual field in the documentation would require frequent updates. =E2=80=8BI believe the current "Outputs" section is intentionally kept simp= le to minimize maintenance overhead. While expanding it might be a worthwhile follow-up, it probably deserves its own dedicated discussion. -- Shinya Kato > --000000000000357259064ee9390b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Mon, Apr 6, 2026, 14:= 17 David G. Johnston <davi= d.g.johnston@gmail.com> wrote:
<= div>
How about something like:
=E2=80=9CEnables sen= ding an INFO message to the client (and server log) as each table is proces= sed.=C2=A0 This message contains: etc=E2=80=A6=E2=80=9D

And then let=E2=80=99s tell the user what info they are getting and w= hat it means (where necessary).

I concur being spe= cific about when these messages arrive, and IMO where, should be specified.= =C2=A0 But losing the detail of =E2=80=9Creport=E2=80=9D is not good; but n= ot sure why we are being vague so suggest we just go all-in on specificity.=

Than= k you for the suggestion. I'd prefer to keep this patch focused; since = the verbose output of both commands is subject to change, listing every ind= ividual field in the documentation would require frequent updates.

=E2=80=8BI believe the current &= quot;Outputs" section is intentionally kept simple to minimize mainten= ance overhead. While expanding it might be a worthwhile follow-up, it proba= bly deserves its own dedicated discussion.

--
Shinya Kato
--000000000000357259064ee9390b--