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 1wCOpZ-001wSD-0M for pgsql-docs@arkaria.postgresql.org; Mon, 13 Apr 2026 21:28:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wCOpX-008pek-18 for pgsql-docs@arkaria.postgresql.org; Mon, 13 Apr 2026 21:28:28 +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 1wCOpX-008pec-0P for pgsql-docs@lists.postgresql.org; Mon, 13 Apr 2026 21:28:28 +0000 Received: from mail-pj1-x102e.google.com ([2607:f8b0:4864:20::102e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wCOpV-00000000ruK-1VPg for pgsql-docs@lists.postgresql.org; Mon, 13 Apr 2026 21:28:27 +0000 Received: by mail-pj1-x102e.google.com with SMTP id 98e67ed59e1d1-35fb166b0c6so783609a91.0 for ; Mon, 13 Apr 2026 14:28:25 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776115705; cv=none; d=google.com; s=arc-20240605; b=VqT5rO5PEXgvY8MeuD+PiLauxNcHEGiYozAaYtbDR0eFZ3449DW/EaqI9AC7QXupGb U1ZmrDk+zqFI9MYcu747jH50MqQiah06J4V0oWaTxKwXolKcKPg2I+2uI16/aLCfE4VH aoyVWgNgEJUS3jf8hKwAjdBuhE0/lWTKtBoZt8rA8IQvLu/9Mvf4vGzNP1wl87fkpvMV fFRK0eSMIDxLGPET4y5hZtB5XMWbCj4koEpwVExpWWZcJFJSVhtKBRSplCSgJSsVaN/V ONKXM2C7+MCIL5C7iRosCnQclCYCrW2iML3uP63EPD6q0hD46GiNo1LOhG4cAuVL8CA5 naXw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :reply-to:in-reply-to:references:mime-version:dkim-signature; bh=bbWMOEMTIBRjeW0To02+R2IcGzaESpbvwyuIw1mO1nA=; fh=5pCdxsLJFgyYRJtt+SqFZMM0zX9ORFonf6Jt3DYnLJY=; b=RMJwvhGqQO36XhHr49gK45dQhndtHSj3wkmXMcGmLEJ9G2RKvM9DEfQHOxtr+z2k/m N0Ddy+TTNf/9s0QBQCmgs1lSISvY1E7PSQ4cXHTJNluPVhPcmo/dhH0WAO+ZUelYRdE/ cYVuJkqUDY4e/30EBlIoORcb3rQP7w/E8B8p0O3lZkN3mJ5fr/yD8qBomqAKlAZutB/9 B9Xq0xWdz84VmquO+7I6dXahkJEtX8AJqCQBV51tTWPmk5QV9B7JP3lxj2sCTSI1RGnt AAl+Oget0dytiGLzkpdStagYAa5dQujS3nDGLrRVH2HLhPhxeoCEC53NpLykIuQe4vFo VA8w==; 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=1776115705; x=1776720505; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :reply-to:in-reply-to:references:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=bbWMOEMTIBRjeW0To02+R2IcGzaESpbvwyuIw1mO1nA=; b=JMurRCWpNT84894a9xUA2zwlglidd5EKnDfLXoqMAXDmnQWiFLY49gDiyFEd8ygD1g JJAU0aZrIrI6cnJaCE9rfDd82tOrOrbhDvDzQ3fwPwrkjkZI49sQxkOOHEdc/lvAfcCb RLty8Abv4F+IEMoVFdZmvL0gyGg/U2gSsUbidMk/FRRGL9E8YBcrj2IooDuG+gJ5PlE1 QfYM4GhfzCK3wjzpzBS9tWeNrOphX9glEWJyt9gU8IW0QuWqLQYukWZB9JQs562NEMtA G12aa5ha56orkj6FaXH/AW9syEj1nMnHf6rBdd1kAayNHtMTRnulBi7y0ON2Ya4G1lAx tYYw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776115705; x=1776720505; h=content-transfer-encoding:cc:to:subject:message-id:date:from :reply-to:in-reply-to:references:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=bbWMOEMTIBRjeW0To02+R2IcGzaESpbvwyuIw1mO1nA=; b=cv4n4avtUBLFqWwLF/p2iRjo6APYkR3ouGQ+evYPqyorqpNU3tXtuHocw+ZllWj2SF Q+CfPkb25fcjCcJ5dN58jMH+Qh5/2mZfucuTwlZmGgv/anuYCprc/UDnYyPjk0OJH8Xb Xs+3Mou7vl1nPnq0uXFU0QyTRHZAPSP3p6qsH5uZPck1HxyTrGXPtMleIXKWB9Gaiyoc aaonCwM0nXGNWilKGzzF1CcFOcBYfUZdbACDnh3Ecb9Cv7gc6Bx7ZspIKag2jpCW38Sd 3g43BmYybhJHYEJP10d+wGhlrbHDvSBDb2NXbFG6P+yU+BIgiwDC7FVCbrYP4T02HEB0 EmmA== X-Forwarded-Encrypted: i=1; AFNElJ/2xBQmujEcuLowPVUBgW4p7koOEhFeNjknRKTyBpHoIlTa2bN6cD14RZKJpbQbNeGRj/CsOW9EuX+d@lists.postgresql.org X-Gm-Message-State: AOJu0YxqHDXOOBYl9D4YAP9rzECVqpdVkhh5MKBPNLERfRoa/fxp1gRA u7+bBMzGczlmM7uri+Tl9XEvrPBZrNtRyftvKFQxWd4Bc4w9RWmRNVN/hdYwPD6PcWda7tlBdkc EkBPmYd+6eCJe0wJMz+NOlpxXwlw3McM= X-Gm-Gg: AeBDietMDKXLFL8/5Rygsrmd8NnK8H61A3Uz6JsfJlKaEjWZJcmhOqmwgFXin55FZhJ 2cl6CTqkmRv3LuA6L8kGxXT7p5vfucsV3UzP0a5Pt9bXVZJjheBqN+QolDtLFUz+46slbfrgnJh E3UlwYgP441aeXlp+7ju5rYpZO5huGnjIuaxT+y82YbKMsUSde5AWdIPngi8Z9o/lLSOfRS7qPl vo59HLlFaMvCY1sl3X7cLAFlLTSx5TYX2EsU7zBILnSIbB3i3ZYqdaIp8vJ3q0TRrx6rAZXZyPZ 5mb57jE= X-Received: by 2002:a17:90b:3b52:b0:35f:c1cc:fee0 with SMTP id 98e67ed59e1d1-35fc1cd0366mr1559196a91.8.1776115704748; Mon, 13 Apr 2026 14:28:24 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: Reply-To: maciek@sakrejda.org From: Maciek Sakrejda Date: Mon, 13 Apr 2026 14:26:23 -0700 X-Gm-Features: AQROBzBt6f19Hi8JUKnaaQmHofwEbZBEZOA07bU_OT9K4MvU1c63xOSlm5egHzo Message-ID: Subject: Re: doc: Clarify ANALYZE VERBOSE output To: Shinya Kato Cc: "David G. Johnston" , Fujii Masao , maciek@sakrejda.org, pgsql-docs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Apr 7, 2026 at 6:57=E2=80=AFPM Shinya Kato wrote: > 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) = as 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 is= not good; but not sure why we are being vague so suggest we just go all-in= on specificity. > > Thank you for the suggestion. I'd prefer to keep this patch focused; sinc= e the verbose output of both commands is subject to change, listing every i= ndividual field in the documentation would require frequent updates. > > I believe the current "Outputs" section is intentionally kept simple to m= inimize maintenance overhead. While expanding it might be a worthwhile foll= ow-up, it probably deserves its own dedicated discussion. +1, listing output details is signing up for busywork. But I do like the =E2=80=9Cas each table is processed" wording: it's clear on when you'l= l see output. Given the feedback above (that just using the word "progress" obscures that you'll see actual stats), maybe something along these lines: "Prints detailed stats at INFO level for each table as it is processed." ? I still think "report" is the wrong term for something that happens incrementally. I don't feel strongly about this, though: if everyone is okay with consolidating on the existing VACUUM wording, that's still better than inconsistency. Thanks, Maciek