query pg_stat_statements privileges

Posted August 26, 2020 894 views


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?

  • 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.