Thread: Viewing connections

Viewing connections

From
"Campano, Troy"
Date:
Is there an easy way to see what connections are open in a PostgreSQL server?
Any way to see if they are active?

thank you!

~ Troy Campano ~

Re: Viewing connections

From
Robert Treat
Date:
On Thu, 2003-01-02 at 15:55, Campano, Troy wrote:
> Is there an easy way to see what connections are open in a PostgreSQL server?
> Any way to see if they are active?
>
> thank you!
>

ps -ax (or different flags if you like) will show open connections and
should have bits / pieces of the queries being run on those connections.
You can also do a select * from pg_stat_activity from psql to get a look
at the current queries.

Robert Treat