insufficient privilege on query column from pg_stat_statements?
I am attempting to do some profiling to see if I have specific queries in need of optimization. I am performing queries as suggested in the docs (https://supabase.com/docs/guides/platform/performance). However, for the queries I am interested in, I am getting
<insufficient privilege>
<insufficient privilege>
as the value for the
query
query
column so I cannot see what the actual query was. The queries in question were originally executed by the
anon
anon
role.
A stripped down version of my profiling query just to illustrate the issue is:
select auth.rolname, statements.queryfrom pg_stat_statements as statements inner join pg_authid as auth on statements.userid = auth.oidwhere rolname='anon';
select auth.rolname, statements.queryfrom pg_stat_statements as statements inner join pg_authid as auth on statements.userid = auth.oidwhere rolname='anon';
Is there a grant I can add to the default dashboard user (which I assume is
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.