Tests Asserting No Open Transactions Failing

IT tests that check that open transactions have closed can intermittently fail due to the autovacuum process running at the same time.

The query checks that for open transactions looks for queries with a non-null backend_xmin to count open transactions.  Checking for transaction state of "idle in transaction" should be more reliable.