Delete / purge records from queriable_log?

Q&A
1

Hello,

I am running community 7.11 and about to migrate to 2023.2. 

When backing up schema, I realized the queriable_log table is huge because very old log records, several years old.

Is it safe to run a simple SQL delete on this table (year base), thus keep the latest but deleting old records? Documentation deals with disabling logging, I still want to keep it, but no point keeping very old stuff.

Regards

Stéphane

2

Hi Stéphane,

Indeed, queriable_log table is not used by Bonita runtime to work properly. In fact, this table is more for audit. It can be queried through LogAPI.

You can then clean up this table as you wish, without altering Bonita runtime.

Hope this answers your question.

Regards,
Emmanuel