Clickhouse cleanup query

Questions & Answers
1

Hi, we have an installation of Openreplay on AWS, ubuntu, single instance, version v1.25.0.

We have all the componentes running with no issues but we started noticing the Clickhouse storage is growing too fast, but as the cleanup command only runs in postgres and s3/minio, the size of Clickhouse storage is not reduced after running the cleanup.

Could you please provide a query to perform cleanup of data on Clickhouse?

I can join the clickhouse pod with a clickhouse client if needed to run the query.

Thanks in advance!

2

I have the same question and self hosting setup, except running in GCP. I’m trying to find any documentation about how we’re to manage clickhouse data but not seeing it mentioned in the docs anywhere yet.