| 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: | 2010-01-29 19:54:37 |
| Message-ID: | 4B633CFD.9070707@esoft.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Well.. the "quick and dirty" start would be:
SELECT * FROM pg_stat_activity;
As for a good management tool, I would recommend pgAdmin3:
- 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!
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2010-01-29 19:55:16 | Re: [GENERAL] Amazon EC2 CPU Utilization |
| Previous Message | Gauthier, Dave | 2010-01-29 19:34:07 | Learning more about attaches |