# Clickhouse cleanup query

**URL:** <https://forum.openreplay.com/t/clickhouse-cleanup-query/559>\
**Category:** Questions & Answers\
**Tags:** storage\
**Created:** [March 7, 2026, 12:03am UTC](https://forum.openreplay.com/t/clickhouse-cleanup-query/559 "2026-03-07T00:03:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![juangh15](https://avatars.discourse-cdn.com/v4/letter/j/76d3ee/32.png) [@juangh15](https://forum.openreplay.com/u/juangh15)\
**Post date:** [March 7, 2026, 12:03am UTC](https://forum.openreplay.com/t/clickhouse-cleanup-query/559/1 "2026-03-07T00:03:53Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![mccrackend](https://avatars.discourse-cdn.com/v4/letter/m/85f322/32.png) [@mccrackend](https://forum.openreplay.com/u/mccrackend)\
**Post date:** [March 23, 2026, 2:00pm UTC](https://forum.openreplay.com/t/clickhouse-cleanup-query/559/2 "2026-03-23T14:00:47Z")

</div>

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.