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 1kC9Zm-00082W-Ew for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Aug 2020 22:43:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kC9Zj-0003qI-UG for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Aug 2020 22:43:55 +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 1kC9Zj-0003qB-N1 for pgsql-hackers@lists.postgresql.org; Sat, 29 Aug 2020 22:43:55 +0000 Received: from mail-qk1-x741.google.com ([2607:f8b0:4864:20::741]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kC9Zg-0004b5-Rl for pgsql-hackers@lists.postgresql.org; Sat, 29 Aug 2020 22:43:55 +0000 Received: by mail-qk1-x741.google.com with SMTP id m7so3010576qki.12 for ; Sat, 29 Aug 2020 15:43:52 -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:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=n36GqcV1Kpzkiq/rF+s4yyIB9EcqMGmrYXgp7agb3mw=; b=Qho6s2cHM/ajYdNOnSF4doET71xnWDVcYxwiSnWMcU+iPpTwBIxyFFFXPB14eGApU1 baROvE7FsCE2alfoK9gHAm7HFTHlhG7z29i4TmyuExPzT4s5aScguVCdoF1MJ+Sp5yKV 4dcEZ7SR1myLhEmiYlUTXKV3X8UQ7g7tsAmyXNq9fzODHSri+o5Mh21iTOOpDRJcDkI1 ccaj01TbHdXevRlPHfC8Isa4LjtApp02QmxT9ZdqIUSnQYXTSA2JDzTINtNPulvvcCSy KErEPeARBhVvdx48ektEFMKzFj5CANxt/gdR2f5PnN7Lr5PHw+j03/21hsshP570VRzT ZFdg== 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:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=n36GqcV1Kpzkiq/rF+s4yyIB9EcqMGmrYXgp7agb3mw=; b=Mza0cGjDXfB9mM3+jq2fa7RiVfjQjEuouz2md5I0+TMzOf8eEx4dzNi0F/j3+/N4YW /AAHt9Ldfs3Yk0CiJWHmkgpf0NBK6e/k3CJMB9GctMYpuQZTaxjOZdfduIuftJxwf/qr bPpyTtsbZhRR8cGSxSgIPtN2gJL3nNESNriEcg2ePPQc7FO2gQShvEOuh4zZwAWjWDzC Dpq+LdWH0lPGWkRtAFqaeDQxIeaMfUbyPMFMIC1TShwsNs7CEt+FW3l65V8o3oX47MNJ QNRwca4MMhjWj4iYykwgh9F7/rEUZD/AJrnFyEiKuYpWbU/kGYW40f5RKR8uycwXa2YI RaFQ== X-Gm-Message-State: AOAM5324qI/t6CwcMh2Mqm7dUQbM2V4ff9bXQZStRdIrISc/aXlqfo80 2W/o49ZtRsbYleeFiW+NL95X7g== X-Google-Smtp-Source: ABdhPJyy9l4vDn69nBqQ8hooxyspuKXdeFWTWDQqRSz1WdlUe+PQGPK7mEIsjUnmTog15efB/sLcww== X-Received: by 2002:a05:620a:13c9:: with SMTP id g9mr5157705qkl.436.1598741030548; Sat, 29 Aug 2020 15:43:50 -0700 (PDT) Received: from perhan.alvh.no-ip.org ([190.95.19.47]) by smtp.gmail.com with ESMTPSA id w32sm4415997qtw.66.2020.08.29.15.43.49 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 29 Aug 2020 15:43:49 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id CDCF72A0FD5; Sat, 29 Aug 2020 18:43:47 -0400 (-04) Date: Sat, 29 Aug 2020 18:43:47 -0400 From: Alvaro Herrera To: Tomas Vondra Cc: Tatsuro Yamada , Julien Rouhaud , Pavel Stehule , PostgreSQL Hackers Subject: Re: list of extended statistics on psql Message-ID: <20200829224347.GA16787@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20200829215458.ca6pnchavgfhs2pf@development> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services