who can view pg_stat_activity?

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: who can view pg_stat_activity?
Date: 2018-02-07 16:57:35
Message-ID: CADyzmyyhWOENFLd9Jprv4xqnijBOyTZVsaCnfCN+aWdaRfQ7nw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Good morning,

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?

Thank you for your time.

--
*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

--
<http://www.drivedominion.com/transform-your-vue/>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2018-02-07 17:17:06 Re: who can view pg_stat_activity?
Previous Message Alexander Kukushkin 2018-02-07 16:24:03 RE: PostgreSQL Active-Active