Bumps [github.com/stretchr/testify](https://github.com/stretchr/testify) from 1.9.0 to 1.10.0.
- [Release notes](https://github.com/stretchr/testify/releases)
- [Commits](stretchr/testify@v1.9.0...v1.10.0)

---
updated-dependencies:
- dependency-name: github.com/stretchr/testify
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

Bumps [github.com/jackc/pgx/v5](https://github.com/jackc/pgx) from 5.7.1 to 5.7.2.
- [Changelog](https://github.com/jackc/pgx/blob/master/CHANGELOG.md)
- [Commits](jackc/pgx@v5.7.1...v5.7.2)

---
updated-dependencies:
- dependency-name: github.com/jackc/pgx/v5
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

Bumps [github.com/pashagolub/pgxmock/v4](https://github.com/pashagolub/pgxmock) from 4.3.0 to 4.4.0.
- [Release notes](https://github.com/pashagolub/pgxmock/releases)
- [Commits](pashagolub/pgxmock@v4.3.0...v4.4.0)

---
updated-dependencies:
- dependency-name: github.com/pashagolub/pgxmock/v4
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

Turned out issuing `txid_current()` at the beginning of every chain
transaction is creating a session that's sits idle in transaction for
the duration of the entire chain. In current case, with a single task
`{kind == PROGRAM}`, that idle transaction doesn't do anything aside
from pin the `xmin` horizon and block vacuum for 6+ hours.
The same issue occurs for SQL tasks that are `Remote` or `Autonomous`.