Thread: Learning more about attaches
Hi:
PG V8.3.4 running on Linux.
I have a DB with a bunch of users attached as gleaned from “ps auxww | grep postgres”. How can I learn more about these users, who they are if coming in via the net, what kind of resources they are using, what they are running, how I can kill them?
I’m open to any good DBA monitoring software downloads.
Thanks!
Well.. the "quick and dirty" start would be: SELECT * FROM pg_stat_activity; As for a good management tool, I would recommend pgAdmin3: http://www.pgadmin.org/ - Chris On 01/29/2010 12:34 PM, Gauthier, Dave wrote: > Hi: > > > > PG V8.3.4 running on Linux. > > > > I have a DB with a bunch of users attached as gleaned from “ps auxww | > grep postgres”. How can I learn more about these users, who they are if > coming in via the net, what kind of resources they are using, what they > are running, how I can kill them? > > > > I’m open to any good DBA monitoring software downloads. > > > > Thanks! >