Current Query ?

From: "Khan, Mahmood Ahram" <Mahmood(dot)Khan(at)in(dot)unisys(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>, <pgsql-admin-owner(at)postgresql(dot)org>, <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Current Query ?
Date: 2007-09-05 11:27:12
Message-ID: D566E8CF3538B54D95B925CB69CB4D2A06BC0F35@inblr-exch1.eu.uis.unisys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I want to know what transactions are going on the server ?

From pg_stat_activity I am able to monitor for only Super User. I have
enabled the Stats_command_string also.

In the column current_query its only showing values for Super User only.
Why not for normal user.

Thanks & Regards

M.AHRAM KHAN

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-09-05 15:01:32 Re: Can't login to 8.2.4 if not superuser...
Previous Message Daniel Rubio 2007-09-05 07:31:05 No pg_dumplo on 8.2.4