MIME-Version: 1.0
From: Ayush Vatsa <ayushvatsa1810@gmail.com>
Date: Mon, 24 Jun 2024 16:39:28 +0530
Message-ID: <CACX+KaMOd3HHteOJNX7fkWxO+R=uLJkfKqE2-QUK8fKmKfOwqw@mail.gmail.com>
Subject: Issue with pgstattuple on Sequences in PostgreSQL
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000051818c061ba0d1e4"
Archived-At: <https://www.postgresql.org/message-id/CACX%2BKaMOd3HHteOJNX7fkWxO%2BR%3DuLJkfKqE2-QUK8fKmKfOwqw%40mail.gmail.com>
Precedence: bulk

--00000000000051818c061ba0d1e4
Content-Type: text/plain; charset="UTF-8"

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/pgstattuple.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=> CREATE SEQUENCE serial START 101;
CREATE SEQUENCE
postgres=> SELECT * FROM pgstattuple('serial');
ERROR:  only heap AM is supported
postgres=>

It got stuck in this if condition -
https://github.com/postgres/postgres/blob/master/contrib/pgstattuple/pgstattuple.c#L326-L329
How can one use pgstattuple on sequences?

Regards,
Ayush Vatsa

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

<div dir=3D"ltr"><p>Hi PostgreSQL Community,</p><p>I was recently exploring=
 the pgstattuple code directory and found this piece of code: <a rel=3D"nor=
eferrer" href=3D"https://github.com/postgres/postgres/blob/master/contrib/p=
gstattuple/pgstattuple.c#L255-L259">https://github.com/postgres/postgres/bl=
ob/master/contrib/pgstattuple/pgstattuple.c#L255-L259</a>.=C2=A0</p><p>It i=
ndicates that pgstattuple supports relations, toast tables, materialized vi=
ews, and sequences.<br>However, when I executed a query with a sequence, I =
encountered the following error:</p><p>postgres=3D&gt; CREATE SEQUENCE seri=
al START 101;<br>CREATE SEQUENCE<br>postgres=3D&gt; SELECT * FROM pgstattup=
le(&#39;serial&#39;);<br>ERROR: =C2=A0only heap AM is supported<br>postgres=
=3D&gt;</p><p>It got stuck in this if condition - <a href=3D"https://github=
.com/postgres/postgres/blob/master/contrib/pgstattuple/pgstattuple.c#L326-L=
329">https://github.com/postgres/postgres/blob/master/contrib/pgstattuple/p=
gstattuple.c#L326-L329</a><br>How can one use pgstattuple on sequences?=C2=
=A0</p><p>Regards,<br>Ayush Vatsa<br></p></div>

--00000000000051818c061ba0d1e4--