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?