MIME-Version: 1.0
References: <CACX+KaMOd3HHteOJNX7fkWxO+R=uLJkfKqE2-QUK8fKmKfOwqw@mail.gmail.com>
In-Reply-To: <CACX+KaMOd3HHteOJNX7fkWxO+R=uLJkfKqE2-QUK8fKmKfOwqw@mail.gmail.com>
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Mon, 24 Jun 2024 16:38:33 +0500
Message-ID: <CAAPsdhfNRaVt6EkNDmprk0eLHHDbq8M1bhSO1nC_T3o=Ef-xtg@mail.gmail.com>
Subject: Re: Issue with pgstattuple on Sequences in PostgreSQL
To: Ayush Vatsa <ayushvatsa1810@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000004bb1fd061ba139a2"
Archived-At: <https://www.postgresql.org/message-id/CAAPsdhfNRaVt6EkNDmprk0eLHHDbq8M1bhSO1nC_T3o%3DEf-xtg%40mail.gmail.com>
Precedence: bulk

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

Hi

I dont think Sequences are support, please refer to the following
documentation.

https://www.postgresql.org/docs/current/pgstattuple.html

Regards
Kashif Zeeshan

On Mon, Jun 24, 2024 at 4:09=E2=80=AFPM Ayush Vatsa <ayushvatsa1810@gmail.c=
om>
wrote:

> Hi PostgreSQL Community,
>
> I was recently exploring the pgstattuple code directory and found this
> piece of code:
> https://github.com/postgres/postgres/blob/master/contrib/pgstattuple/pgst=
attuple.c#L255-L259
> .
>
> It indicates that pgstattuple supports relations, toast tables,
> materialized views, and sequences.
> However, when I executed a query with a sequence, I encountered the
> following error:
>
> postgres=3D> CREATE SEQUENCE serial START 101;
> CREATE SEQUENCE
> postgres=3D> SELECT * FROM pgstattuple('serial');
> ERROR:  only heap AM is supported
> postgres=3D>
>
> It got stuck in this if condition -
> https://github.com/postgres/postgres/blob/master/contrib/pgstattuple/pgst=
attuple.c#L326-L329
> How can one use pgstattuple on sequences?
>
> Regards,
> Ayush Vatsa
>

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

<div dir=3D"ltr">Hi<div><br></div><div>I dont think Sequences are support, =
please refer to the following documentation.</div><div><br></div><div><a hr=
ef=3D"https://www.postgresql.org/docs/current/pgstattuple.html">https://www=
.postgresql.org/docs/current/pgstattuple.html</a><br></div><div><br></div><=
div>Regards</div><div>Kashif Zeeshan</div></div><br><div class=3D"gmail_quo=
te"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Jun 24, 2024 at 4:09=E2=
=80=AFPM Ayush Vatsa &lt;<a href=3D"mailto:ayushvatsa1810@gmail.com">ayushv=
atsa1810@gmail.com</a>&gt; wrote:<br></div><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 dir=3D"ltr"><p>Hi PostgreSQL Community,</p><p>I was =
recently exploring the pgstattuple code directory and found this piece of c=
ode: <a rel=3D"noreferrer" href=3D"https://github.com/postgres/postgres/blo=
b/master/contrib/pgstattuple/pgstattuple.c#L255-L259" target=3D"_blank">htt=
ps://github.com/postgres/postgres/blob/master/contrib/pgstattuple/pgstattup=
le.c#L255-L259</a>.=C2=A0</p><p>It indicates that pgstattuple supports rela=
tions, toast tables, materialized views, and sequences.<br>However, when I =
executed a query with a sequence, I encountered the following error:</p><p>=
postgres=3D&gt; CREATE SEQUENCE serial START 101;<br>CREATE SEQUENCE<br>pos=
tgres=3D&gt; SELECT * FROM pgstattuple(&#39;serial&#39;);<br>ERROR: =C2=A0o=
nly heap AM is supported<br>postgres=3D&gt;</p><p>It got stuck in this if c=
ondition - <a href=3D"https://github.com/postgres/postgres/blob/master/cont=
rib/pgstattuple/pgstattuple.c#L326-L329" target=3D"_blank">https://github.c=
om/postgres/postgres/blob/master/contrib/pgstattuple/pgstattuple.c#L326-L32=
9</a><br>How can one use pgstattuple on sequences?=C2=A0</p><p>Regards,<br>=
Ayush Vatsa<br></p></div>
</blockquote></div>

--0000000000004bb1fd061ba139a2--