Thread: Currently connected users...

Currently connected users...

From
Dhimant Patel
Date:
I'm a beginner Postgres user, and need quick hint from someone.


How could I know which users are currently connected to postgres instance?


Thanks,
DP.

Re: Currently connected users...

From
Andreas Kretschmer
Date:
Dhimant Patel <drp4kri@gmail.com> wrote:

> I'm a beginner Postgres user, and need quick hint from someone.
>
>
> How could I know which users are currently connected to postgres instance?

You can use pg_stat_activity:

select * from pg_stat_activity

Or, if you need only the usernames:

select usename from pg_stat_activity ;


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

Re: Currently connected users...

From
Thomas Kellerer
Date:
Dhimant Patel, 21.01.2010 17:40:
> I'm a beginner Postgres user, and need quick hint from someone.
>
>
> How could I know which users are currently connected to postgres instance?
>

http://www.postgresql.org/docs/current/static/monitoring.html

More precisely:
http://www.postgresql.org/docs/current/static/monitoring-stats.html#MONITORING-STATS-VIEWS

Thomas