Stephan,
Thanks for your reply.
No I don't have indexes on the *_id fields in bus_pc_idc. Now that you
point it out it make perfect sense why this query would
take a while and give the impression it's hanging - it's all those seq
scans.
Thank you kindly, I really appreicate it.
Regards
Rudi.