The problem with a selfhosted Plausible

Running out of diskspace quickly Link to heading

Pretty soon after setting up Plausible on Dokku the instance ran out of diskspace. Plausible is using ClickHouse and its storage files quickly used up the majority of the available diskspace. And that’s for a single site with very little traffic.

And looking at this github issue on Plausible CE, diskspace consumption will grow out of bounds regardless the traffic:

ClickHouse store folder grows uncontrollably and is not cleaned up

[…] I’m self-hosting Plausible CE using Docker Compose (with the official setup). Plausible 3.0.1. I’ve noticed that the plausible-ce_event-data volume (used by ClickHouse) keeps growing in size, even

• The events_v2 table only holds about 700k rows
• system.parts reports only a few dozen active parts, totaling ~10 MiB on disk
• Yet, the underlying ClickHouse store folder is currently over 44 GiB

For this reason I had to deinstall my selfhosted Plausible CE again and I’m again looking for a more fitting alternative (like maybe GoatCounter).