Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Learning more about attaches
- From: Chris Ernst <cernst(at)esoft(dot)com>
- To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
- Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Learning more about attaches
- Date: Fri, 29 Jan 2010 12:54:37 -0700
- Message-id: <4B633CFD.9070707@esoft.com> <text/plain>
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! >
- References:
- Learning more about attaches
- From: Gauthier, Dave
- Learning more about attaches
- Prev by Date: Learning more about attaches
- Next by Date: Re: Amazon EC2 CPU Utilization
- Previous by thread: Learning more about attaches
- Next by thread: Possible to set postgres in case insensitive mode ?
- Indexes: