Re: pgstattuple - can it/does it provide stats by partition?

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgstattuple - can it/does it provide stats by partition?
Date: 2024-06-15 17:04:58
Message-ID: CANzqJaBvysYZkAwsH2KeHZrRjv7v+7qkHPpgNDVA1KZ8c7g_3Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Jun 15, 2024 at 9:47 AM Dragam <dragam(at)protonmail(dot)com> wrote:

> Hi all,
>
> As the title says - does (and/or can) pgstattuple provide a breakdown by
> partition?
> <https://proton.me/>
>

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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message yudhi s 2024-06-15 20:09:11 Re: Design for dashboard query
Previous Message Sushrut Shivaswamy 2024-06-15 15:14:24 Re: Design for dashboard query