Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

 

 

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group