50.3. Viewing Housekeeping Rules #
In the navigation panel, go to Settings → Repository.
The table of housekeeping rules with the following columns will be displayed:
Name.
Maximum storage time: The maximum time the table data can be stored before deletion.
Auto-run: Specifies whether the housekeeping rule is auto-run or not.
Possible values:
Repeated: The housekeeping rule is auto-run.
Disabled: The housekeeping rule is not auto-run.
Schedule: The interval in the crontab format for cleaning the table.
Status.
Possible values:
Not Executed: The housekeeping rule was not executed.
Completed: The table is cleaned successfully.
Executing: The table is being cleaned.
Error: An error occurred when cleaning the table.
Canceled: The table cleaning was canceled.
Last run: The date and time the table was last cleaned.
Schema: The schema where the table is located.
Table: The table that is being cleaned.
Size: The total size of the table, including all indexes and TOAST data.
Deleted: The amount of deleted table data.
The horizontal indicator represents the value in a graphical form.
You can view the following table parameters by hovering over the displayed value:
Deleted.
Current size.
Previous size.
Decrease: The table size descrease percentage.
Actions.
For more information about available actions, refer to the corresponding instructions.