Is there a way to enable pg_stat_statements?

I’d like to monitor the performance of the database and my queries, tools like pg_stat_statements would be extremely helpful.

However, CREATE extension pg_stat_statements ; has the following error,

ERROR:  permission denied to create extension "pg_stat_statements"
HINT:  Must be superuser to create this extension.

Since users are provisioned from the console, and are not granted superuser, I don’t currently have a way to enable any telemetry extensions.

Will there be an option to enable extensions from the API / console? or is there a way for us to get a permission to create extensions?

1 Like