Re: BUG #15245: pg_stat_all_tables does not include partition mastertables

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BUG #15245: pg_stat_all_tables does not include partition mastertables
Дата
Msg-id 20180617120653.GD1411@paquier.xyz
обсуждение исходный текст
Ответ на BUG #15245: pg_stat_all_tables does not include partition mastertables  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #15245: pg_stat_all_tables does not include partition master tables  (Mahadevan Ramachandran <mahadevan@rapidloop.com>)
Список 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
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Hillel Eilat
Дата:
Сообщение: RE: BUG #15230: "Logical decoding" is not sensitive to clientencoding setting
Следующее
От: Mahadevan Ramachandran
Дата:
Сообщение: Re: BUG #15245: pg_stat_all_tables does not include partition master tables