| From: | Chris Gamache <cgg007(at)yahoo(dot)com> |
|---|---|
| To: | jerome(at)gmanmi(dot)tv, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Viewing Client Connections.. |
| Date: | 2003-08-13 13:42:35 |
| Message-ID: | 20030813134235.33313.qmail@web13801.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmanmi(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | krystoffff | 2003-08-13 13:43:42 | How to get the total number of rows with a query "limit" ? |
| Previous Message | Robert Creager | 2003-08-13 13:40:07 | Re: How to prevent vacuum and reindex from deadlocking. |