Thread: backends and pg_stat_activity

backends and pg_stat_activity

From

Joseph Shraibman

Date:

17 October 2005, 20:04:28

Is there a way to get the ip address of the connections listed in
pg_stat_activity?

Re: backends and pg_stat_activity

From

"Magnus Hagander"

Date:

17 October 2005, 20:40:07

> Is there a way to get the ip address of the connections
> listed in pg_stat_activity?

It is - in 8.1 :)

Until then, I think you'll need to do a netstat -nap or such a command
and match the pids. Manually.


//Magnus