MIME-Version: 1.0
References: <TkMBDTWXZtirfjz6IU1BWpApEgB1IeTC9mNYCtc4njmeNpNFde75i-a5mps9m43fvsJaaqOCbZs-9AO8OybMbPHb4iypM8RbJi1DjgLENF4=@protonmail.com>
In-Reply-To: <TkMBDTWXZtirfjz6IU1BWpApEgB1IeTC9mNYCtc4njmeNpNFde75i-a5mps9m43fvsJaaqOCbZs-9AO8OybMbPHb4iypM8RbJi1DjgLENF4=@protonmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 15 Jun 2024 13:04:58 -0400
Message-ID: <CANzqJaBvysYZkAwsH2KeHZrRjv7v+7qkHPpgNDVA1KZ8c7g_3Q@mail.gmail.com>
Subject: Re: pgstattuple - can it/does it provide stats by partition?
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000226a6061af0bcf7"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaBvysYZkAwsH2KeHZrRjv7v%2B7qkHPpgNDVA1KZ8c7g_3Q%40mail.gmail.com>
Precedence: bulk

--0000000000000226a6061af0bcf7
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sat, Jun 15, 2024 at 9:47=E2=80=AFAM Dragam <dragam@protonmail.com> wrot=
e:

> 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?

--0000000000000226a6061af0bcf7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Sat, Jun 15, 2024 at 9:47=E2=80=AFAM D=
ragam &lt;<a href=3D"mailto:dragam@protonmail.com">dragam@protonmail.com</a=
>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail=
_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204=
,204);padding-left:1ex"><div style=3D"font-family:Arial,sans-serif;font-siz=
e:14px">Hi all,</div><div style=3D"font-family:Arial,sans-serif;font-size:1=
4px"><br></div><div style=3D"font-family:Arial,sans-serif;font-size:14px">A=
s the title says - does (and/or can) pgstattuple provide a breakdown by par=
tition?</div><div style=3D"font-family:Arial,sans-serif;font-size:14px"><di=
v><a href=3D"https://proton.me/" rel=3D"noopener noreferrer" target=3D"_bla=
nk"></a></div></div></blockquote><div><br></div><div>Partitions are tables,=
 created via CREATE TABLE.=C2=A0 I know from experience that it works on in=
heritance tables; what happens when you try pgstattuple() on a small test p=
artition?</div><div><br></div></div></div>

--0000000000000226a6061af0bcf7--