Thread: info request : listing active connections

Vilson farias wrote:
> Greetings,
>
>   I've been looking for a way to list active connections from
>   clients to the postmaster. What kind of features does postgresql
>   has to make it possible?  I would like to list users, ips and
>   maybe calling application and plataform. Now, the only way I
>   know is through ps -ef | grep post. Is there some system table
>   where I can find information about active connections?

7.2 has pg_stat_activity table that shows connections and queries.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Hi Bruce,

  Thanks for quick answer. It's a great feature for newer releases for
PostgreSQL, but here I'm still using 7.1.2 (and few 7.0.3), so is there some
way in older versions?

Best regards.

----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Vilson farias" <vilson.farias@digitro.com.br>
Cc: <pgsql-admin@postgresql.org>
Sent: Tuesday, March 26, 2002 11:36 AM
Subject: Re: [ADMIN] info request : listing active connections


> Vilson farias wrote:
> > Greetings,
> >
> >   I've been looking for a way to list active connections from
> >   clients to the postmaster. What kind of features does postgresql
> >   has to make it possible?  I would like to list users, ips and
> >   maybe calling application and plataform. Now, the only way I
> >   know is through ps -ef | grep post. Is there some system table
> >   where I can find information about active connections?
>
> 7.2 has pg_stat_activity table that shows connections and queries.
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>

Vilson farias wrote:
> Hi Bruce,
>
>   Thanks for quick answer. It's a great feature for newer releases for
> PostgreSQL, but here I'm still using 7.1.2 (and few 7.0.3), so is there some
> way in older versions?
>

No, just ps.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026