This message was deleted.

Can you share the output of this query?

SELECT
    database,
    table,
    formatReadableSize(sum(data_compressed_bytes) AS size) AS compressed,
    formatReadableSize(sum(data_uncompressed_bytes) AS usize) AS uncompressed,
    round(usize / size, 2) AS compr_rate,
    sum(rows) AS rows,
    count() AS part_count
FROM system.parts
WHERE (active = 1) AND (database LIKE '%') AND (table LIKE '%')
GROUP BY
    database,
    table
ORDER BY size DESC;

It gives you the tables and their sizes. We will know which ones have the maximum size and take some action

thx for your reply, where can i run this query?

You need to connect to clickhouse and run this.

Hello, this is my screenshot of the query

The compressed data is around ~5GB in total for SigNoz so you may have something else taking up the remaining disk space. Please refer to this guide for setting retention https://signoz.io/docs/userguide/retention-period/