Обсуждение: Viewing Client Connections..

Is there a way in postgres to view current client connections? including
statistics.. how long did it take for him to connect and disconnect.. etc

TIA

select * from pg_stat_activity; will get you who's connected... I'm not too
sure about the other stats, but you can try to mine the table pg_statistic...
There may be some other system views that might do the trick.

CG



--- Jerome Macaranas <jerome@gmanmi.tv> wrote:
> Is there a way in postgres to view current client connections? including
> statistics.. how long did it take for him to connect and disconnect.. etc
>
> TIA
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com