50.4. Viewing Detailed Housekeeping Rule Information #
In the navigation panel, go to Settings → Repository.
Click
next to the housekeeping rule.
The window with detailed information about the housekeeping rule will open. On Last run, the following parameters related to the last table cleaning are displayed:
Status.
Start: The date and time the table cleaning started.
End: The date and time the table cleaning ended.
Duration: The duration of the table cleaning.
Cleaning process ID.
Table size before vacuuming.
Table size after vacuuming.
Deleted: The amount of deleted table data.
The horizontal indicator represents the value in a graphical form.
On Parameters, the following housekeeping rule parameters are displayed:
Instance: The instance where the repository database is located.
ID.
Type: Specifies whether this is the system or user housekeeping rule.
Possible values:
System
User
Schema: The schema where the table is located.
Table: The table that is being cleaned.
Timestamp column: The table column that contains the timestamp for determining the data age.
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 in the crontab format: The interval in the crontab format for cleaning the table.
Description.
Additional conditions: The table of housekeeping rule conditions.
This table includes the following columns:
Field: The table field for the housekeeping rule condition.
Condition: The logical operator of the housekeeping rule condition.
Possible values:
=
≠
IN
NOT IN
LIKE
NOT LIKE
>
<
≥
≤
REGEXP
NOT REGEXP
Value: The value of the housekeeping rule condition.