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 1kC9kH-0008Pb-7e for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Aug 2020 22:54:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kC9kF-0006VC-1C for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Aug 2020 22:54:47 +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 1kC9kE-0006V5-M6 for pgsql-hackers@lists.postgresql.org; Sat, 29 Aug 2020 22:54:46 +0000 Received: from mail-ej1-x644.google.com ([2a00:1450:4864:20::644]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kC9k7-0004h3-H2 for pgsql-hackers@lists.postgresql.org; Sat, 29 Aug 2020 22:54:46 +0000 Received: by mail-ej1-x644.google.com with SMTP id l2so3790733eji.3 for ; Sat, 29 Aug 2020 15:54:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=O6RWzIX5SNBdRNAuSm4h2psLRe8DGudgzcoMSfjg6Q0=; b=bb8ewEH7ctSsXUGGPrZt+YHK/egsv07BdblSrITqXuvsBmvi3kbZcZSLDDE2LLSSLb ciz9PTpyNzTScvhnjv9gu805LSJxG/DsdbLS7vtY3t844VRz1iv7uQPKyfxQJvNoeWhk zcJIPwnPwi9iAA7TNYAgxdfNNXFKxxOuEkwL/U9WoGCgatEYRh3dQ0YL/nZochp5Za4f r6r2+aoO9y9GfLIgUYnOj2WuXGzij00alr9uc+pw9dhIG2TwOugooORbru5tGahMnP/d rK7gSbZKLD6SoqqQiaH8Cp62YjT5Ysg3F0vaelmw/e+Ao4ESGshAkWuLsnbkM7pwen3R pqCQ== 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; bh=O6RWzIX5SNBdRNAuSm4h2psLRe8DGudgzcoMSfjg6Q0=; b=Rc9Eh4r5CbWC9ko1EKYp2C218yzi2nYCykqGsUZEZUTvLSy5TTQOIO81nrZMOsLzJL y/IFGHzIjEl0TdYHHvzyONN1tHQg4qBU/RYGJAlsTyQ26NfhEsNArDdxNuXtDD+svwHJ ukl48Wu9SD9LSs0LvD/YPv9YA7ruXnvHId3BYc6E7hE9YBM9a1h4XZszAVr/nvNRHHLT 4whyOCbwo18vqLabMnjpFgg5OOiP5wkD7ssaXdqu8NO25rO+GYLucCCA2N3w2CFI18vN JN68Uc2hOGSN3Q05XhuB1sw1IsPaVCNHOjrqtHvmkOm67nunUfb0MHGkdiu5fGRD4pCT /prA== X-Gm-Message-State: AOAM5318N+Ishtj8x3MF7O1hUkHPZW3UzP1NQM3YrVkIpsgWFtpJRyOz CvwhxmvijOzHKSh5/kqop3r90w== X-Google-Smtp-Source: ABdhPJzhtmga5ezsdL5nS8DpSOVFvheozusSPBkUZOkNTPzw5vW+EPnllyG/FdIX3zjNwL+Q7lZ9MQ== X-Received: by 2002:a17:906:8401:: with SMTP id n1mr1321447ejx.215.1598741678609; Sat, 29 Aug 2020 15:54:38 -0700 (PDT) Received: from localhost (ip-86-49-253-216.net.upcbroadband.cz. [86.49.253.216]) by smtp.gmail.com with ESMTPSA id f6sm3371170ejh.92.2020.08.29.15.54.37 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 29 Aug 2020 15:54:38 -0700 (PDT) Date: Sun, 30 Aug 2020 00:54:36 +0200 From: Tomas Vondra To: Alvaro Herrera Cc: Tatsuro Yamada , Julien Rouhaud , Pavel Stehule , PostgreSQL Hackers Subject: Re: list of extended statistics on psql Message-ID: <20200829225436.atuttqilrcgppqio@development> References: <20200829215458.ca6pnchavgfhs2pf@development> <20200829224347.GA16787@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline In-Reply-To: <20200829224347.GA16787@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sat, Aug 29, 2020 at 06:43:47PM -0400, Alvaro Herrera wrote: >On 2020-Aug-29, Tomas Vondra wrote: > >> But if we want the >> output to show both what was requested and which types were actually >> built, that'll effectively double the number of columns needed :-( > >I was thinking it would be one column per type showing either disabled or enabled >or built. But another idea is to show one type per line that's at least >enabled. > >> Also, it might be useful to show the size of the statistics built, just >> like we show for \d+ etc. > >\dX+ I suppose? > Right. I've only used \d+ as an example of an existing command showing sizes of the objects. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services