Re: pg_stat_activity

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jun 11, 2018 at 8:45 AM, Thomas Poty <thomas.poty@xxxxxxxxx> wrote:
It lists all statements including 'ALTER TABLE', 'VACUUM', 'CREATE INDEX', etc

Le lun. 11 juin 2018 à 15:38, Ron <ronljohnsonjr@xxxxxxxxx> 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.

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux