Add configurable statement_timeout to prune and vacuum workers

[ezekg]

Some of these queries need a longer statement_timeout than our default. This makes the timeouts configurable.

[sentry-io[bot]]

Suspect Issues

This pull request was deployed and Sentry observed the following issues:

• ‼️ ActiveRecord::StatementInvalid: PG::ActiveSqlTransaction: ERROR: VACUUM cannot run inside a transaction block (ActiveRecord::Sta... Sidekiq/VacuumAnalyzeEventLogsWorker View Issue
• ‼️ ActiveRecord::StatementInvalid: PG::ActiveSqlTransaction: ERROR: VACUUM cannot run inside a transaction block (ActiveRecord::Sta... Sidekiq/VacuumAnalyzeWebhookEventsWorker View Issue
• ‼️ ActiveRecord::StatementInvalid: PG::ActiveSqlTransaction: ERROR: VACUUM cannot run inside a transaction block (ActiveRecord::Sta... Sidekiq/VacuumAnalyzeMetricsWorker View Issue
• ‼️ ActiveRecord::StatementInvalid: PG::ActiveSqlTransaction: ERROR: VACUUM cannot run inside a transaction block (ActiveRecord::Sta... Sidekiq/VacuumAnalyzeRequestLogsWorker View Issue

_{Did you find this useful? React with a 👍 or 👎}