Comment 1 for bug 531833

We can't get this level of detail out of the Slony tools themselves.

We might be able to get meaningful information out of the slony log files.

We could get the slony tools customized to provide less noise and more meaningful feedback.

Have there been blockages detected that were not caused by connections that should have been disconnected? pg_stat_activity can provide information on open connections, and we could write a report to aggregate all the servers if we need to.

Or is this more about getting 'I'm not blocked, I'm busy doing stuff' information? This information should all be in the slony log files. Currently it is buried in a lot of noise. We should consider switching to the Slony-I 2.x series which has apparently cleaned up the logging a lot.