Обсуждение: 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

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!
>