Purge/Delete the historical data from pgwatch(db: base)

[Sarang-Dharme-od]

We are running pgwatch container using cybertec/pgwatch2-postgres:1.9.0 docker image. We has been storing/persisting postgres data in docker volume(named pg) on host (-v pg:/var/lib/postgresql). At the moment our disk is full(100%) due to database base. Is there any way I can purge/delete the historical data from pgwatch to release disk space on my server?

[pashagolub]

Hello,

yeah, sure! You can easily delete old data if you don't need it. Please, check the Storage Monitoring section of our official manual for the hints!

Kind regards

[Sarang-Dharme-od]

Hello @pashagolub

As per the reference document Storage Monitoring, I have set PW2_PG_RETENTION_DAYS enviroment variable to 4 days. However, It's not working for me. No effect on retention. Can you please advice?

code Snippet:
services:
pgwatch:
container_name: pgwatch2
image: "cybertec/pgwatch2-postgres:1.9.0"
environment:
PW2_TESTDB: "true"
PW2_DATASTORE: "postgres"
PW2_PG_RETENTION_DAYS: 4

[pashagolub]

Can you please elaborate more on "not working"? Some tables are growing? What are they? Settings are not applied?

Also please consider our Producst support service.

[Sarang-Dharme-od]

@pashagolub I have set PW2_PG_RETENTION_DAYS enviroment variable to 4 days. Ideally data older than 4 days should not be visible in dashboard as it should be purged/deleted. However, Still data is being persisted for 15-16 days. I have attached screenshot of the dashboard.

[pashagolub]

Aha, thanks for the clarification. According to the logic old metrics never deleted at once, because this may kill the server. Instead it deleted in chunks.

If you're sure you need to delete everything, please, find the proper SQL following the link provided.