Learning more about attaches

Started by Gauthier, Daveabout 16 years ago2 messagesgeneral

dave.gauthier@intel.com

about 16 years ago

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!

Chris Ernst

cernst@esoft.com

about 16 years ago

In reply to: Gauthier, Dave (#1)

Re: Learning more about attaches

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

Show quoted text

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!