Thread: connections manager

connections manager

From
"Lic. Guillermo González"
Date:
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.

Thanks,

--
- - - - - - - - - - - - - - - - - - - - - -
Lic. Guillermo J. González Rodas
Ms. Ing. del Software
g.gonzalez@cybira.biz

CyBIra Consulting
Lapacho Nro. 161 c/ Av. Eusebio Ayala
Tel. (595-21) 557048 / 557173
Asunción - Paraguay
- - - - - - - - - - - - - - - - - - - - - -


Re: connections manager

From
Oliver Elphick
Date:
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@lfix.co.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