From: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
---|---|
To: | Flower Sun <sun_2002_flower(at)yahoo(dot)com>, Pgsql Group <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to get information of active/inactive user connection for postgresql |
Date: | 2003-03-19 17:02:55 |
Message-ID: | 200303191002.55276.pgsql@bluepolka.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wednesday March 19 2003 9:59, Flower Sun wrote:
> Hi, Ed L,
> Thank you so much! You gave me the answer as what I expected.
> Regards,
> Jing
Neil Conway's comment reminds me there is a much simpler and more reliable
way:
select * from pg_stat_activity
I gave you my customized version.
Ed
> "Ed L." <pgsql(at)bluepolka(dot)net> wrote:On Wednesday March 19 2003 8:59,
Flower Sun wrote:
> > Do you know what's the command to get information of active/inactive
> > user connection(session) for postgresql?
>
> SELECT pg_stat_get_backend_pid(S.backendid) AS pid, db.datname AS
> database, dbu.usename AS user, pg_stat_get_backend_activity(S.backendid)
> AS current_query
> FROM pg_user dbu, pg_database db, (SELECT pg_stat_get_backend_idset() AS
> backendid) AS S,
> WHERE db.oid = pg_stat_get_backend_dbid(S.backendid)
> AND dbu.usesysid = pg_stat_get_backend_userid(S.backendid);
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2003-03-19 17:11:34 | Re: ssl |
Previous Message | eiannucci | 2003-03-19 17:00:46 | subscribe nomail |