Reference pillar runs out of heap space when extracting audit trails

The extraction of audit trails in the reference pillar and integrity service can cause a "OutOfMemoryError: Java heap space" when extracting audit trails.
It happens when the database contains many (millions) of audit trails, and many of the audits have not been collected yet - producing a large result set.
The is because the database query does not limit the number of results, and the database connection has not been set to only fetch a limited number of results at the time.