Let me provide some manuals and links that offer insight into data retention policy and ways to prune old metrics using VM downsampling.
Data retention:
You can limit or disable tablestats if not really needed:
Victoria Metrics Downsampling/pruning:
Well, you can also check this blog post to validate or remove any orphan containers or volumes that exist somehow.
Since PMM 2.41.0, ClickHouse was upgraded from version 21.3.20.1 to 23.8.2.7, introducing changes in how logs are written and retained. If you are using PMM ≥ 2.41.0, clickhouse records are inserted into log tables every second, which can cause rapid table growth.