Version:

Spock cleanup resolutions

NAME

spock.cleanup_resolutions()

SYNOPSIS

spock.cleanup_resolutions([days integer])

RETURNS

bigint — the number of rows deleted from spock.resolutions.

DESCRIPTION

Deletes rows from spock.resolutions whose log_time is older than the retention window. Returns the number of rows deleted.

This function is a superuser-only manual trigger for the same cleanup that the apply worker runs automatically once per day. It is useful for immediate cleanup via pg_cron or when the apply worker has not been running.

When days is provided it takes precedence over spock.resolutions_retention_days, including when the GUC is set to 0 (automatic cleanup disabled). If days is omitted, the GUC value is used; if the GUC is also 0, the function returns 0 without deleting anything.

ARGUMENTS

Argument	Type	Default	Description
`days`	`integer`	`NULL`	Retention window in days. Overrides `spock.resolutions_retention_days` for this call. Pass an explicit value to perform a one-off cleanup when automatic cleanup is disabled (`resolutions_retention_days = 0`).

EXAMPLE

Delete conflict history rows older than the configured retention window:

SELECT spock.cleanup_resolutions();

Delete rows older than 60 days, regardless of the GUC setting:

SELECT spock.cleanup_resolutions(60);