BUG #15245: pg_stat_all_tables does not include partition master tables

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: mahadevan(at)rapidloop(dot)com
Subject: BUG #15245: pg_stat_all_tables does not include partition master tables
Date: 2018-06-17 08:54:06
Message-ID: 152922564661.24801.3078728743990100425@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15245
Logged by: Mahadevan Ramachandran
Email address: mahadevan(at)rapidloop(dot)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'.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hillel Eilat 2018-06-17 09:54:50 RE: BUG #15230: "Logical decoding" is not sensitive to client encoding setting
Previous Message Tom Lane 2018-06-16 14:42:26 Re: row_to_json(), NULL values, and AS