We currently run postgres 9.4. The only way to view the pg_stat_activity view that I can see is that you must be a superuser. I couldn't find anything in the documentation to confirm or refute this. Could you please confirm if this is true or if not, what privileges are required?