Re: pgstattuple - can it/does it provide stats by partition? - Mailing list pgsql-general

From Ron Johnson
Subject Re: pgstattuple - can it/does it provide stats by partition?
Date
Msg-id CANzqJaBvysYZkAwsH2KeHZrRjv7v+7qkHPpgNDVA1KZ8c7g_3Q@mail.gmail.com
Whole thread Raw
In response to pgstattuple - can it/does it provide stats by partition?  (Dragam <dragam@protonmail.com>)
List pgsql-general
On Sat, Jun 15, 2024 at 9:47 AM Dragam <dragam@protonmail.com> wrote:
Hi all,

As the title says - does (and/or can) pgstattuple provide a breakdown by partition?

Partitions are tables, created via CREATE TABLE.  I know from experience that it works on inheritance tables; what happens when you try pgstattuple() on a small test partition?

pgsql-general by date:

Previous
From: Sushrut Shivaswamy
Date:
Subject: Re: Design for dashboard query
Next
From: yudhi s
Date:
Subject: Re: Design for dashboard query