I can reproduce the issue in v1.14.0 and v1.14.1 as well. This does not happen on all of my Postgres instances, the one I am trying to actively monitor that exhibits the problem is through the ssh port forward.
Running ssh -v -L 5433:<server>:5432 <user>@<server> seems to show a constant traffic stream, with messages like this repeating:
debug2: channel 5: window 1997018 sent adjust 100134
debug2: channel 5: window 1997018 sent adjust 100134
debug2: channel 5: window 1997018 sent adjust 100134
debug2: channel 5: window 1997018 sent adjust 100134
debug2: channel 5: window 1997018 sent adjust 100134
debug2: channel 5: window 1997018 sent adjust 100134
From: MattK <mksql@yahoo.com> To: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org> Sent: Saturday, March 17, 2012 2:06 PM Subject: [pgadmin-support] Server status hanging on OS X
When connecting to a v8.4.9 server on with PgAdmin v1.14.2 on OS X (SL and Lion) and launching the Server Status window, PgAdmin displays the status window with highlighted process info, but then the entire application becomes unresponsive, and shows as not responding in the Mac activity monitor, consuming ~10% CPU.
This issue was also present in PgAdmin v1.14.1, but seemed to occur less frequently (subjective). The server is question is accessed by a local ssh forward (ssh -L), but this may or not be related, as I have been able to use this configuration in the past without issue.
I also use DbVisualizer, which has a similar but less detailed display (essentially pg_stat_activity), that does not seem to have any issue through the same connection. I can execute "select * from pg_stat_activity" via a PgAdmin query successfully on the connection.
What other information can I collect to diagnose the cause?
