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 1fUWSc-0000tj-Tn for pgsql-bugs@arkaria.postgresql.org; Sun, 17 Jun 2018 12:07:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fUWSY-0000zo-Pr for pgsql-bugs@arkaria.postgresql.org; Sun, 17 Jun 2018 12:07:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fUWSW-0000zf-Ic for pgsql-bugs@lists.postgresql.org; Sun, 17 Jun 2018 12:07:06 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fUWSR-0002sL-QY for pgsql-bugs@lists.postgresql.org; Sun, 17 Jun 2018 12:07:04 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 1B08D212A5; Sun, 17 Jun 2018 08:06:58 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sun, 17 Jun 2018 08:06:58 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= 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=wDCqNwg/Lj+zZuBSmrdTMQ+KTrxrc/V7Fe+QV8ieWro=; b=q7aFoBCp gpO/vefIV3ihfpDB5cTQgLiPw+qd2KR/ODe11lwYztWTVditSP4PfI9fSPqATDYR dnyAyOEi9wlmIHviMYwuZz9pSo7Jm8y9wTN9BGYAEkvMbwO/MKfW9qpAW29+lmou wnhwd6FLqcDAf0ggCkNhuhY+sZXnTQuV63XgompELkzr9r2bwRxfEsYg3wepOG5h Y5AWPbmRQZf94gBilB24sR+JLBeErF/N056z3/s6GKRQaR0q4fx2i31ErZFebmgy AYBG+w2STKfQgJbyWvOoxqGQ4vtFhLth7wK5Mbr1mlu5mJCrx6zBMSWHbdwkljhd JmLZfc3fGWlQ5w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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=wDCqNwg/Lj+zZuBSmrdTMQ+KTrxrc /V7Fe+QV8ieWro=; b=WUXK3JiwsX3U2r+XeF1JIrB7q8koRPd2m9JfNyr/anHN1 kD5Sjy0Yj333b9D24Ha4G9alFnI1OFw3D/TK7pKwf+LsDiSZx9yP9cn9I1zDJxdJ SgYO5Ohzvkbbxjaa41BtUcGP+1JWtAoxQsGWZALbY68Nq49nu3553ol4YzhXWg4p MA6oqTQ0vSNvPf5KClNXg1Cg/TrZ717+0mYfahwN9/cu5sCWLGF+Te31Nv9hgkr/ qaF+Euh1qIBCzimooGWT45V4wSqwjyfdUmuKUiMiz8gz1HV/d9bdZUgWknhT2bt4 93S1IELuyYcIfaEjMjrWxFrVoaHClSkTivHGgPR4g== 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 ACCECE4329; Sun, 17 Jun 2018 08:06:56 -0400 (EDT) Date: Sun, 17 Jun 2018 21:06:53 +0900 From: Michael Paquier To: mahadevan@rapidloop.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #15245: pg_stat_all_tables does not include partition master tables Message-ID: <20180617120653.GD1411@paquier.xyz> References: <152922564661.24801.3078728743990100425@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="zS7rBR6csb6tI2e1" Content-Disposition: inline In-Reply-To: <152922564661.24801.3078728743990100425@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --zS7rBR6csb6tI2e1 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sun, Jun 17, 2018 at 08:54:06AM +0000, PG Bug reporting form wrote: > The system view pg_catalog.pg_stat_all_tables (and therefore also > pg_catalog.pg_stat_user_tables) do not list partition master tables (CREA= TE > TABLE ... PARTITION BY ..). >=20 > This is because it only includes rows from pg_class with relkind IN ('r', > 't', 'm') (as defined in src/backend/catalog/system_views.sql). >=20 > IMHO, it should also include rows with relkind =3D 'p'. Why? A parent partition has no physical presence and no data of its own. -- Michael --zS7rBR6csb6tI2e1 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlsmTt0ACgkQnvQgOdby QH0WjA/+Jpq2xXF47r4uT+unAHp/kY8d01NP7nxO/8Iu7qmzodAU1bmcDiZIa+n2 G1kFysUWZuvtuxbIyXA7cPGpWw4CKwskHn3v0+PtEkdU5FqrhTBF95xvykhr1Qtv r0aGw7DZ8jcKGznLFFKI5aONXzsnGjnFwF5qfTVIZBUH7fdO2ZImyqzyyQA3r3QU DgCSItiNU0mZ2cLaJLaAlTqD+e883TnekhR044eKZf1lB3we/dkkB4ScDRXsEwOK Up1BS7Ptql7mLNJuhr2Em2uZizT9w7oW6tVli+xKniE95dOVkBZVkelQ67X0VqeZ SzXuHXX5iur7r/SwwKB35mArX4zUgJlMhXUSI6v22/Dtvy855y0TrgRp5N+T3xM0 TQCKolmrDYE6IwDFYj8LBtPxEIVKMYI6D6eFUUxAs0A6Adoyxs6MVClD7ZJSwm8m tpH0nZisQ6I7bGVbAoMz2kX57wywxuRKoqbv82Jmpinef2HAbt+5dtYpMz4F7ECj oBMlIozWAI7x2eEiPFK0fUbX9HSOHyYPFUHDzPUGGLGKJjOMDP4tcIwLyBttOen6 q0IZzKN7aF7g6nVxVfNVLNJAWuX0gMcQMXEnI6bsLmmuGTwhhQfrnIpu+o9UPpqz SfP7E1tpioRgIgC7yFDNRUlJWWcmHzPriGdWs9WGjyGI6ywjIPs= =UFT3 -----END PGP SIGNATURE----- --zS7rBR6csb6tI2e1--