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 1kXqlt-000439-BG for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Oct 2020 19:06:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kXqls-0004Vd-B7 for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Oct 2020 19:06:08 +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 1kXqls-0004VW-4G for pgsql-hackers@lists.postgresql.org; Wed, 28 Oct 2020 19:06:08 +0000 Received: from mail-ed1-x542.google.com ([2a00:1450:4864:20::542]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kXqlp-0004Xn-Nn for pgsql-hackers@lists.postgresql.org; Wed, 28 Oct 2020 19:06:07 +0000 Received: by mail-ed1-x542.google.com with SMTP id t20so549419edr.11 for ; Wed, 28 Oct 2020 12:06:05 -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=MBmBol8xtb+Uu7RJQLEj9kzFVK7+HoyAukKXeyN20Lw=; b=YHp47KpfMGHE2+8cL3+iTexO5ylzRteVXN6CsU7IjnuFLu+vRkktfOokB1kEZ4E9dT QXd5YqIf+DeAhl3cBH8scg0d7LmgaNW1JcC58Ip4s6Qr6FANjosDOCYYtFCJHCqzcZUy rnlTdPVPrTVeEKyQ1oBj4xvos58hlMI+O4sAcrC5hpXHjZjf1RAyp+1MQqnTCJRJA7fd qWOA9F31KyqSGOsL+9J4rrPS6IX6kcKRepGWfEiCSuTTJGKsgujjj+BTDZpWd+yhXoT1 w/bDJHYxGBT2wAsYuELv7qB15eBibUid8nbLkQkbnnTKnFBvM39cqpD5WgnDgmqxx5/L WTYw== 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=MBmBol8xtb+Uu7RJQLEj9kzFVK7+HoyAukKXeyN20Lw=; b=E7z06GbU+tWIJfrpk+221xnjYTO/lm3Kp+qn25CXydXslbrqwCFtieZcNyubkYNpy1 91S7P3VdwDwBmqPacBl1i/9S11ZKcl3vQ0X8nQZIHNBh2LYjBeaBfW9JhhX1UR5va4Vb 0WwMbImBVz216kzQk7HMCZuPDi7aDNDOsaH6TsJzzVJ5M8sG2fZe7aBtJ9lwJzZWp1Wa l74E4QB1vTPSHW4EWPht/0CgKSpDyi17hD7pGGdGCWxjUGwb3j/ltZUt8RbW6sbxjKqn clxreJLCDfBwNs56EhnIedUvDMoaXXppEDQWaQIh/bEc8YfJh3JKdhxBd/4P1neFJo4e zBJQ== X-Gm-Message-State: AOAM531SadyX3O99ytyS1zFHuZbR/65dcvMHUrbvWQ+87A326D18O3YE I/O1mRveD05Np7T2nd57jTGR3A== X-Google-Smtp-Source: ABdhPJxnS70kGxB9Rks1cBiuuwrbIMR2k/jngUGwZsasdvW48n7hW16mutz2WsKW5Y8evDMVXB6vOg== X-Received: by 2002:aa7:c351:: with SMTP id j17mr401706edr.70.1603911965017; Wed, 28 Oct 2020 12:06:05 -0700 (PDT) Received: from localhost (ip-86-49-245-76.net.upcbroadband.cz. [86.49.245.76]) by smtp.gmail.com with ESMTPSA id m16sm307451edj.37.2020.10.28.12.06.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 28 Oct 2020 12:06:04 -0700 (PDT) Date: Wed, 28 Oct 2020 20:06:01 +0100 From: Tomas Vondra To: Tatsuro Yamada Cc: Michael Paquier , Pavel Stehule , Alvaro Herrera , Julien Rouhaud , PostgreSQL Hackers Subject: Re: list of extended statistics on psql Message-ID: <20201028190601.bbshe6dhp32767q7@development> References: <20200831153053.a343pjgumahiejhw@development> <20200831161809.GA31337@alvherre.pgsql> <20200831163200.jp6eqbaaupb6hxac@development> <20200917055531.GV2873@paquier.xyz> <20200930061947.GD1996@paquier.xyz> <2a3173fb-8571-3779-2916-d16a170750f0@nttcom.co.jp_1> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline In-Reply-To: <2a3173fb-8571-3779-2916-d16a170750f0@nttcom.co.jp_1> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, Oct 28, 2020 at 03:07:56PM +0900, Tatsuro Yamada wrote: >Hi Michael-san and Hackers, > >On 2020/09/30 15:19, Michael Paquier wrote: >>On Thu, Sep 17, 2020 at 02:55:31PM +0900, Michael Paquier wrote: >>>Could you provide at least a rebased version of the patch? The CF bot >>>is complaning here. >> >>Not seeing this answered after two weeks, I have marked the patch as >>RwF for now. >>-- >>Michael > > >Sorry for the delayed reply. > >I re-based the patch on the current head and did some >refactoring. >I think the size of extended stats are not useful for DBA. >Should I remove it? > I think it's an interesting / useful information, I'd keep it (in the \dX+ output only, of course). But I think it needs to print the size similarly to \d+, i.e. using pg_size_pretty - that'll include the unit and make it more readable for large stats. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services