Re: How to get information of active/inactive user connection for postgresql - Mailing list pgsql-general

Hi, Ed L,

Thank you so much! You gave me the answer as what I expected.

Regards,

Jing

 "Ed L." <pgsql@bluepolka.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);