@kapa.ai how can I free space on the postgres machine of airbyte? We have a table named attempts that is growing a lot

To free up space on your Postgres machine used by Airbyte, especially if the

attempts

table is growing significantly, you can manually prune (delete) old rows from the

attempts

table. This is a common issue in large or long-running Airbyte deployments, as there is currently no built-in automated cleanup for this table. Manually deleting older entries can help restore performance and free up disk space. However, be aware that this will remove historical sync attempt data, which may be needed for auditing or troubleshooting. There is an open feature request to make this process configurable and automated, but as of now, you need to handle it manually. The official recommendation is to periodically prune the

attempts

table, keeping only the recent history you need. For example, some users keep only a month's worth of data, which significantly reduces disk usage and improves system stability. There are no documented negative side effects from deleting old rows, but you will lose the history of those sync attempts in the Airbyte UI and API responses. Always back up your database before performing bulk deletions, just in case. Additionally, for cleaning up Temporal history (which can also consume a lot of space), you can set the

TEMPORAL_HISTORY_RETENTION_IN_DAYS

environment variable to a lower value to automatically clean up old Temporal logs and tables. However, this does not affect the

attempts

table, which still requires manual intervention for now [[Purging of old syncs from Airbyte databases](https://github.com/airbytehq/airbyte/discussions/55233)]. Summary of steps: 1. Manually delete old rows from the

attempts

table in your Airbyte Postgres database. 2. Optionally, set

TEMPORAL_HISTORY_RETENTION_IN_DAYS

to manage Temporal history retention (but this does not affect the

attempts

table). 3. Always back up your database before making changes. For more details and ongoing discussions, see the related [feature request](https://github.com/airbytehq/airbyte/discussions/62951) and [community guidance](https://github.com/airbytehq/airbyte/discussions/55233).

Could you please provide me a query in order to clean the attempts table prior to one month ago