Re: BUG #15245: pg_stat_all_tables does not include partition master tables

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: mahadevan(at)rapidloop(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15245: pg_stat_all_tables does not include partition master tables
Date: 2018-06-17 12:06:53
Message-ID: 20180617120653.GD1411@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mahadevan Ramachandran 2018-06-17 12:24:03 Re: BUG #15245: pg_stat_all_tables does not include partition master tables
Previous Message Hillel Eilat 2018-06-17 09:54:50 RE: BUG #15230: "Logical decoding" is not sensitive to client encoding setting