Question

query pg_stat_statements privileges

Posted August 26, 2020 894 views
PostgreSQL

Hi,

Even when I connect with doadmin I get query column showing “<insufficient privilege>”, I need to do some queries of my own on that view, how can I do that?

2 comments
  • Did you resolve this problem? I’m running into exactly the same situation.

  • Same “<insufficient privilege>” situation for me. Any hope of getting access? From SO, and out of desperation, I tried:

    > GRANT pg_read_all_stats TO user_name;
    ERROR:  must have admin option on role "pg_read_all_stats"
    

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

@smorales unfortunately no, I did not, and DigitalOcean is not interested to answer this question, so indirectly they are suggesting a radical solution.