| From: | Jan Wieck <janwieck(at)yahoo(dot)com> |
|---|---|
| To: | ambre(at)ebutec(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Number of Connections ? |
| Date: | 2001-11-28 13:01:14 |
| Message-ID: | 200111281301.fASD1Ec04092@saturn.jw.home |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Erwin Ambrosch wrote:
> Hi,
>
> is there a query to ask my PostgeSql backend how much connections are
> currently open?
New functionality in v7.2. Given your configuration starts at
least the collector daemon (defaults to get started,
configuration is in postgres.conf), you can
SELECT count(*) from pg_stat_activity;
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ben-Nes Michael | 2001-11-28 13:38:03 | ver 7.2 |
| Previous Message | Khan | 2001-11-28 11:51:00 | PostgreSQL ODBC for Windows |