_deletedentitylogs take up disk space on C:\

Filippo_Nicolussi_P — Fri, 04 Mar 2022 20:23:45 GMT

Qlik Sense Enterprise soft deletes objects and stores the entities in the _deletedentytilog table in the QRS database.

A heavily used system with many tasks and frequent development activity, this table can consume a lot of disk space and could impact performance.

Environment:

Resolution

Note: Please perform a Repository database backup prior any changes.

As of Qlik Sense February 2019, an automatic clean up process cleans this table, the frequency of this process can be adjusted in the repository.exe.config file.

The following configuration options were added:

DeletedEntityLogMaintenance.Enabled - Defines if maintenance work should be enabled or not. Default true.
DeletedEntityLogMaintenance.Interval - Defines how often the maintenance work should run. Default 24 hours.

The following configuration options have been changed from previous versions:

DeletedEntityLogMaintenance.StartAt - Is no longer specified in local time. Instead the time is relative to UTC.
DeletedEntityLogMaintenance.CleaningThreshold - Renamed from CleaningThresholdInDays and is no longer an integer value. Instead the value is entered as a TimeSpan in format days.hh:mm:ss. Default 90.00:00:00. (Default value initially was 90 days, later versions was changed to 30, this value can be configured if its necessary to cleanup in shorter period of time).

But if space needs to be reclaimed faster, a workaround can be deployed:

If the table that is wasting space on C:\ drive is "_deletedentitylog" it is safe to empty the table manually:

Schedule a minimum of 30 min of down time and stop all Qlik Sense Services except for the Qlik Sense Repository Database service.
Connect to Postgres DB with PGAdmin Installing and Configuring pgAdmin 4 for Qlik Sense June 2017 Release and up
Select the QSR Database
Open Query tool
Issue the query
truncate "_deletedentitylog";
Restart Qlik Sense Services starting from Qlik Sense Repository Service and Qlik Sense Dispatcher

When truncating the table a new empty file will be created for that table.

In May 2021 a new parameter was introduced that allows to exclude logging entries that are highly contributing to the size of the table and are NOT valuable in terms of potential backtracking.

<add key="DeletedEntityLog.ExcludedEntities" value="TempContent;ExecutionResult;ExecutionResult.Detail;ExecutionSession" />

Re: _deletedentitylogs take up disk space on C:\

Filippo_Nicolussi_P — Tue, 04 Apr 2023 06:46:47 GMT

At today on Qlik Sense February 2023 here below list of options used to keep under control size of the table mentioned:

In multi-node scenario suggestion is to enable the maintenance only on two nodes (for example Central and one Failover Candidate) and to shift the StartAt for the second node.

article _deletedentitylogs take up disk space on C:\ in Official Support Articles

_deletedentitylogs take up disk space on C:\

Environment:

Resolution

Re: _deletedentitylogs take up disk space on C:\