John Gibson <gib@edgate.com> writes:
> Unfortunately, I am stuck on how to get all three into the monitor table
> with the same timestamp.
Do all the work in a single SERIALIZABLE transaction. That gives you a
static, consistent view of the database for as long as you need.
regards, tom lane