Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_stat_activity - Mailing list pgsql-admin

From Thomas Poty
Subject Re: pg_stat_activity
Date
Msg-id CAN_ctniac-z4_m4aLUrA6HtUeuZnPonR324W5eBvHSDTS7QZvw@mail.gmail.com
Whole thread Raw
In response to Re: pg_stat_activity  (Don Seiler <don@seiler.us>)
Responses Re: pg_stat_activity  (Ilhan çetin <iilhancetin@gmail.com>)
List pgsql-admin
Tree view
Hi Don,
I think you cannot run pg_activity if role is not superuser.
Regards,
Thomas

Le lun. 11 juin 2018 à 15:58, Don Seiler <don@seiler.us> a écrit :
On Mon, Jun 11, 2018 at 8:45 AM, Thomas Poty <thomas.poty@gmail.com> wrote:
It lists all statements including 'ALTER TABLE', 'VACUUM', 'CREATE INDEX', etc

Le lun. 11 juin 2018 à 15:38, Ron <ronljohnsonjr@gmail.com> a écrit :
Does pg_stat_activity only list SELECT statements, or does it also list
INSERT, DELETE and UPDATE statements?

 Keep in mind that you can only see those statements if you are the same user or are a superuser. I'm not sure yet if users in the pg_monitor role have visibility.

pgsql-admin by date:

Previous
From: Don Seiler
Date:
Subject: Re: pg_stat_activity
Next
From: Ilhan çetin
Date:
Subject: Re: pg_stat_activity