Where is the connection info

Started by Cason, Kennyabout 21 years ago2 messages
#1Cason, Kenny
kenny.cason@boeing.com

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

#2Hannu Krosing
hannu@tm.ee
In reply to: Cason, Kenny (#1)
Re: Where is the connection info

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