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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin


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





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-2017 The PostgreSQL Global Development Group