Viewing Client Connections..

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