Re: connections manager

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: "\"Lic(dot) Guillermo" González" <g(dot)gonzalez(at)cybira(dot)biz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: connections manager
Date: 2004-09-20 08:59:51
Message-ID: 1095670791.17403.51.camel@linda
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 2004-09-16 at 15:09, "Lic. Guillermo González" wrote:
> Hi,
>
> I would like to know if there is a script or software that can bring me
> information about the connections on my PostgreSQL databases.

select * from pg_stat_activity;

--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"But my God shall supply all your need according to his
riches in glory by Christ Jesus." Philippians 4:19

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chuming Chen 2004-09-20 12:31:03 pg_dumpall failed
Previous Message Robb Shecter 2004-09-19 21:55:16 Re: All ops on one particular table cause a hang?