I have tried to minimize the database size by deleting logs older than 400 days.
It must reduce the database size to at least %50 of it.
After pressing “Purge DB Now” and after a long time there is no change in database size and Matomo says “ Last deletion was on: Sep 21, 2018 ”
Current database size: 168.4 G
Estimated database size after purge: 146.2 G
Estimated space saved: 22.1 G
Is there any SQL scripts to do it directly and safely in DB?