Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fUjZH-0001Bg-Pi for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Jun 2018 02:06:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fUjZG-0001sl-2R for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Jun 2018 02:06:54 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fUjZF-0001sc-OJ for pgsql-bugs@lists.postgresql.org; Mon, 18 Jun 2018 02:06:53 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fUjZ8-0007ey-TH for pgsql-bugs@lists.postgresql.org; Mon, 18 Jun 2018 02:06:52 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 4EC0120DCF; Sun, 17 Jun 2018 22:06:46 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sun, 17 Jun 2018 22:06:46 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; bh=Fc8Nqy4GdO+f0PmzMjFWGCcF7m0LmkAHVa9PPIrA990=; b=rhyecUzn G0PL8sDqeBjKhUCu41ngNSdXsPOVXmaWEjXmTVXY50DelucQdsB5AGCwcBvNwUhc yRNqfQfPf9UNBWI80vxKtzscTXBvDSHyiEQwTX5k1O8uuzUZhBuXgA8CEaPiTp6G cBHZvmRGQZK8aPgOmQMkYEzyOLCNy91JCK0DnTKxJOjq2JmrUbqzY8CTHMWBSq23 UBmOzE9ZMMYEcH9RBf6gfDYrVbFkaGI9EZg51Zg0krq+Q9Uq2UZbnH1gIQWZMEWI LU9zTO04L15+tHhzD9mt+vGkr10RucvWvOsGeR25W8BtN6VPk2/fejmu0uL2JMSQ /9ctUYxCJF8JHg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=Fc8Nqy4GdO+f0PmzMjFWGCcF7m0Lm kAHVa9PPIrA990=; b=mCh7gMs/AbdxspbdhnGF05QQKz44CVA21gL/i9c6iuAsD 6sFqPapc1koE1AXNXoeYof7sh1o62XYWHEDt9DxZYk9szZ8JX9i6pnhweZThv5eO jkq+M5sAjqC1lhsETv4Uy8ceg1jzVyY4VAAlQZn6vZwOJmQFiiUMW3gbvDovGrHL mAKQBxP30KAWBAVgcbp4scKrWDk8n9VUtC5ZfnWbrr8rvpnFsLNmcc+viunQThK8 22dJlOXFkvnkPYIr3/3DUm8BRgd2wxyjDW4yLNixhKnegsp1DmWiJCgpBdKSsp89 CwMCKMyBDn0biqWePgnkMIunWDPKRT0ivhMbjtPKg== X-ME-Proxy: X-ME-Sender: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id DBBBEE4329; Sun, 17 Jun 2018 22:06:44 -0400 (EDT) Date: Mon, 18 Jun 2018 11:06:42 +0900 From: Michael Paquier To: "David G. Johnston" Cc: Mahadevan Ramachandran , "pgsql-bugs@lists.postgresql.org" Subject: Re: BUG #15245: pg_stat_all_tables does not include partition master tables Message-ID: <20180618020642.GC3721@paquier.xyz> References: <152922564661.24801.3078728743990100425@wrigleys.postgresql.org> <20180617120653.GD1411@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="oJ71EGRlYNjSvfq7" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --oJ71EGRlYNjSvfq7 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sun, Jun 17, 2018 at 08:29:33AM -0700, David G. Johnston wrote: > My first reaction was to agree, which suggests a need for a note in the > docs why this isn't the case. The _all_ specifically means both user and > system; the _stats_ in the name means that only tables that have statistics > are included. I feel this is a reasonable decision. If there were anything to happen here, then I think that it would be hard to define what the statistics of the parent partition should reflect. For example, the autovacuum and autoanalyze run times are I think tricky as you cannot really define the last time autovacuum has been run on the parent as the last time it has been run only only one of the partitions or a sub-set of them. This gets also messier if you come across multiple partition layers. -- Michael --oJ71EGRlYNjSvfq7 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlsnE7IACgkQnvQgOdby QH2EMRAAgxQXYtmLOQojiF1ltbYeFDKAi6v8ohx2EGqn8OymlSeb68uPe0uOK9Js xi15Jff7yrgNSJWJMJzH0e/U/NjbSIe3IfMsAMMehMlW3dQuvxMofEGnXAomnFu/ +ViuFZM82ta+ZwbJ4wMp0huiu04ugUqiKU1RJCOYz4VFTAhorsrvQgTp8Uhavq95 XUlArgDv0veTnnh88xRD2072PYlPcG2qu44v/qeOQpOz/ImWyYDSNxAWhm6ARZ0L yYIAtVhPbmPOIy5hB7Dox4ymYvTsGwtWTbgx5umyiDgbqT44UAZxamIDjIYxs4RC KHQJ2duc0XQbW5Zp5k6XZXnngPdJyZR2CsmfFppEHjZ3y5Kws8Ve2TznNaYCCYSC mIampiVsx58ruCRgqWzmxNNygz6/3gXW+DANc9g0y+A/cSHipqLAVpULSiiNTgl7 gpyqjkF1hCthAN3eoZtjHon6Ucu6xnCzdX5Ddqb0e9I4bKTmis3cMsFWyT7MFckd GyM5xrwgrl/Iq1+HH05v+f79qHheRJsyY74fxjut42J85HUrahisl5SOYS9mg4Cy oU4LPI47QSAq2shL3wRLhhlsnCj44KI9bQEX00NdSq0Y1dn9OwuObndbk+BVD0vj n1fOt+Zma5uNgHg7W/18G85J0iRZDMgTFKEPqQxi1x0vRrhFjQk= =6XN9 -----END PGP SIGNATURE----- --oJ71EGRlYNjSvfq7--