Thread: Where is the connection info

In postgres, how do I find out how many connections are allowed per
user? Where those connections are stored? Who has the connections? Etc.

Kenny Cason
Kenny.Cason@Boeing.com

On K, 2004-12-01 at 18:28, Cason, Kenny wrote:
> In postgres, how do I find out how many connections are allowed per
> user? Where those connections are stored? Who has the connections? Etc.

You can start from:

show all;

select * from pg_stat_activity;

---------
Hannu