| From: | "Onyx" <omueller(at)i3(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Connections to DB |
| Date: | 2005-10-27 17:21:26 |
| Message-ID: | 20051027172128.AB5B6A48D2@mail.frii.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
How can I view the current, persistent connections to a database? Is there
a way to do this with 'psql' or with some other PostgreSQL bundled
tool/utility (~pgsql_directory/bin), instead of resorting to the underlying
operating system commands (ie: netstat -a | grep postgres)?
I am interested in finding out the following: 1) How many connections are
there to the database? 2) How long have they persisted? 3) What is the
idle time of the connections?
Any help would be appreciated. Thanks!
- Onyx
---
Onyx Mueller
Software Engineer
i-cubed : information integration & imaging LLC
201 Linden Street : Third Floor
Fort Collins, CO 80524
970-482-4400 voice
970-482-4499 fax
www.i3.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2005-10-27 17:37:36 | Re: Connections to DB |
| Previous Message | Claire McLister | 2005-10-27 17:21:14 | Re: [GENERAL] Map of Postgresql Users (OT) |