Re: BUG #15245: pg_stat_all_tables does not include partition mastertables - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #15245: pg_stat_all_tables does not include partition mastertables
Date
Msg-id 20180617120653.GD1411@paquier.xyz
Whole thread Raw
In response to BUG #15245: pg_stat_all_tables does not include partition mastertables  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15245: pg_stat_all_tables does not include partition master tables  (Mahadevan Ramachandran <mahadevan@rapidloop.com>)
List pgsql-bugs
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 (CREATE
> TABLE ... PARTITION BY ..).
>
> 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).
>
> IMHO, it should also include rows with relkind = 'p'.

Why?  A parent partition has no physical presence and no data of its
own.
--
Michael

Attachment

pgsql-bugs by date:

Previous
From: Hillel Eilat
Date:
Subject: RE: BUG #15230: "Logical decoding" is not sensitive to clientencoding setting
Next
From: Mahadevan Ramachandran
Date:
Subject: Re: BUG #15245: pg_stat_all_tables does not include partition master tables