pgstattuple only allowed by superuser

[Zsolt Ero]

Hello,

I see that pgstattuple is a supported module, based in the official docs / changelog.

CREATE EXTENSION pgstattuple; runs with OK.

However, when I try to use module with 

SELECT * FROM pgstattuple('tablename');

It terminates with ERROR:  must be superuser to use pgstattuple functions.

I believe this is must be a bug, or otherwise why is this module advertised as supported?

[George (Cloud Platform Support)]

Hello Zsolt, 

This behavior should not appear as unexpected: any features requiring superuser access are not supported. An exception to this rule is made for the CREATE EXTENSION statement, but only for supported extensions, as stated on the "Cloud SQL Features" page. pgstattuple does not fall under this category, as it does not appear on the list of supported extensions. You can check the status of that list on the "PostgreSQL Extensions" page. 

[Ben Perlman]

It says that pgstattuple is supported here: https://cloud.google.com/sql/docs/postgres/release-notes#June_01_2017
Any ideas why its not actually on the supported extension page? 

[mulem]

Hello Ben,

Pgstattuple was deprecated in November, 2018 due to compatibility and functionality issues which is why it no longer appears on the supported extensions page but is still listed in the release notes of June 2017 when it was first introduced.

[Rodolphe QUIEDEVILLE]

Hi,

Thanks for this answer that help understanding the same issue I encountered.

If pgstattuple is not usable why letting it available ? 

What about removing from the available extensions list all that we can't use ?

postgres=> select * from pg_available_extensions where name ='pgstattuple';

    name     | default_version | installed_version |           comment           

-------------+-----------------+-------------------+-----------------------------

 pgstattuple | 1.5             | 1.5               | show tuple-level statistics

(1 row)

Best