Postgres Pro
Downloads
Home   >   mailing lists

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

From PG Bug reporting form
Subject BUG #15245: pg_stat_all_tables does not include partition mastertables
Date
Msg-id 152922564661.24801.3078728743990100425@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #15245: pg_stat_all_tables does not include partition mastertables  (Michael Paquier <michael@paquier.xyz>)
Re: BUG #15245: pg_stat_all_tables does not include partition master tables  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      15245
Logged by:          Mahadevan Ramachandran
Email address:      mahadevan@rapidloop.com
PostgreSQL version: 10.4
Operating system:   any
Description:

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'.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15244: Inherited table queries return null lines that do not exist
Next
From: Hillel Eilat
Date:
Subject: RE: BUG #15230: "Logical decoding" is not sensitive to clientencoding setting