Postgres Pro
Downloads
Home   >   mailing lists

Re: active connections - Mailing list pgsql-general

From A. Kretschmer
Subject Re: active connections
Date
Msg-id 20071030181442.GB1496@a-kretschmer.de
Whole thread Raw
In response to active connections  (João Paulo Zavanela <joao_zava@globo.com>)
List pgsql-general
Tree view 
am  Tue, dem 30.10.2007, um 14:51:33 -0300 mailte João Paulo Zavanela folgendes:
> Hi,
>
> I would like to know how many active connections exist.
> Is necessary show the number ip of client.

ask pg_stat_activity

(select * from pg_stat_activity;)

Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: João Paulo Zavanela
Date:
Subject: active connections
Next
From: Decibel!
Date:
Subject: Updated .vim file