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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Mahadevan Ramachandran <mahadevan(at)rapidloop(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <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 15:29:33
Message-ID: CAKFQuwaV0Zz5_e7CmJoP_ULRsZ-G2y6fmMF-4QZP6eGso3J7Dg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sunday, June 17, 2018, Mahadevan Ramachandran <mahadevan(at)rapidloop(dot)com>
wrote:
>
>
> The view is named "_all_tables" so he'd expect, well, all
> the tables to be listed there.
>

My first reaction was to agree, which suggests a need for a note in the
docs why this isn't the case. The _all_ specifically means both user and
system; the _stats_ in the name means that only tables that have statistics
are included. I feel this is a reasonable decision.

David J.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-06-17 17:43:26 Re: row_to_json(), NULL values, and AS
Previous Message Mahadevan Ramachandran 2018-06-17 12:24:03 Re: BUG #15245: pg_stat_all_tables does not include partition master tables