It's been a few years since I worked with slony, and you did not state which version of slony or PostgreSQL you are working with, nor did you indicate the O/S.
I think OP had pointed to using streaming....
That being said, you should be able to formulate a query with a join between sl_path & sl_node that gives you the information you need.