Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l1BHr-0006kn-U0 for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Jan 2021 16:52:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l1BHq-0000FS-QY for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Jan 2021 16:52:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l1BHq-0000FL-EM for pgsql-hackers@lists.postgresql.org; Sun, 17 Jan 2021 16:52:22 +0000 Received: from mail-io1-xd29.google.com ([2607:f8b0:4864:20::d29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1l1BHj-0000Ox-BW for pgsql-hackers@lists.postgresql.org; Sun, 17 Jan 2021 16:52:21 +0000 Received: by mail-io1-xd29.google.com with SMTP id w18so28310502iot.0 for ; Sun, 17 Jan 2021 08:52:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=zZs+YNocwVu9+OIbs0QEaFtXW8EVfslZeTJmEPIRz3I=; b=qrKn45CfKidgaRjIjmbjmSiZXQp0Vh/tzr/OxhVXmfFYVq2UTshnwjsXyjgTs0AJv7 WjXiJOsk+OacL4UG3pVRFjrIgp/1p4b6L0LJCjmny+OlD759p1QlrhNLF9Aee93nK1GR 5iY6iDdyWIf2h78Mny/YjIAo6z7UzsIL1xm8NLREwYF+01gHJK3HdNk/KKvHh5GY74L8 lcwkHJwHKi1mZkQVZLp+4P126cdDW8jbMpErTFTfjz58Nr81AOYXuoBwMKq30bGL3KVj pg8iA2s/uCCtKspjwJFtun0RUpf+PU3u2zQvPHG5H/fuNboxMTbp5j7pGI1gFoYFsPgS Bw3Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=zZs+YNocwVu9+OIbs0QEaFtXW8EVfslZeTJmEPIRz3I=; b=SgBo4pjZyE6e1hvkyXY/Zuqzrv9dY7OwV0WpmE/nmoeant1yafPbWOtYTmZNFrqcF1 5IPGSPFswU5gSjqmqIO2E72DSMl6+wWC4f5UzpePGecJpoZS+aTt1bfCrYWKuT5II9Fc UO4Fpi0QSsjCNxippCMHGicXv6CTMTAEM7T0Lwl2YeeQOa4u/QjMWU/y7Xx4eFQX8Lt3 66cPjte73YHTzDx4lO1FgA4VwFprv0Rv/ka+1vmZbRxTSPpYFIn+vhw+8NzmlggjFq3G aB3RP/xH64G0+OyA5fi47vlydJxkdvyyfoyqNAaqfibqpan9E+EB3pdzGfpw9E6LuwAA kZ7Q== X-Gm-Message-State: AOAM532rx1h9qFB409kUloFnBbOYAMw6TYEe7ZY/nO7T5u5q+/4accyp poB/TQeXBKWlh19EZv2WzwwSzA== X-Google-Smtp-Source: ABdhPJzpmoTiDVQXf/7NsBMwhD1Cw2WCYgUmAzmw829BocRvjApHawiz+2zAF8OOAh914MgbvXhboA== X-Received: by 2002:a6b:c981:: with SMTP id z123mr9980886iof.206.1610902333456; Sun, 17 Jan 2021 08:52:13 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id m19sm8983807ila.81.2021.01.17.08.52.12 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 17 Jan 2021 08:52:12 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 5BB858010E7; Sun, 17 Jan 2021 10:52:10 -0600 (CST) Date: Sun, 17 Jan 2021 10:52:10 -0600 From: Justin Pryzby To: Tomas Vondra Cc: "Shinoda, Noriyoshi (PN Japan FSIP)" , Julien Rouhaud , Tatsuro Yamada , Alvaro Herrera , Tomas Vondra , Michael Paquier , Pavel Stehule , PostgreSQL Hackers Subject: Re: list of extended statistics on psql Message-ID: <20210117165210.GD8560@telsasoft.com> References: <876efa7e-2067-a4f9-d7e8-f6025440c870@nttcom.co.jp_1> <0e84aa72-25f2-1849-753f-f827949132b3@enterprisedb.com> <85e7e1e7-c2f0-a4a0-61de-6e7ecaee44e3@nttcom.co.jp_1> <79d3a4c5-1efe-5b9e-c06e-3a907b531013@nttcom.co.jp_1> <20210115084741.GA91293@nol> <2eb51458-7475-17d3-cb13-b3c950b2f930@enterprisedb.com> <5e0fb573-3c38-ee39-885c-bdc01f116335@enterprisedb.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sun, Jan 17, 2021 at 03:31:57PM +0100, Tomas Vondra wrote: > I've reverted the commit - once we find the right way to handle this, I'll > get it committed again. Please consider these doc changes for the next iteration. commit 1a69f648ce6c63ebb37b6d8ec7c6539b3cb70787 Author: Justin Pryzby Date: Sat Jan 16 17:47:35 2021 -0600 doc review: psql \dX 891a1d0bca262ca78564e0fea1eaa5ae544ea5ee diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index aaf55df921..a678a69dfb 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1928,15 +1928,15 @@ testdb=> is specified, only those extended statistics whose names match the pattern are listed. If + is appended to the command name, each extended - statistics is listed with its size. + statistic is listed with its size. - The column of the kind of extended stats (e.g. Ndistinct) shows some statuses. + The column of the kind of extended stats (e.g. Ndistinct) shows its status. "requested" means that it needs to collect statistics by ANALYZE. "built" means ANALYZE was - finished, and the planner can use it. NULL means that it doesn't exists. + run, and statistics are available to the planner. NULL means that it doesn't exist.