Follow these steps to estimate your usage:

1. Truncate your usage tables:

•

truncate table signoz_metrics.usage on cluster cluster

•

truncate table signoz_metrics.usage on cluster cluster

•

truncate table signoz_logs.usage on cluster cluster

2. Restart your otel collectors

3. Keep on running and ingesting normal volumes for over 24hrs

4. Now connect to Clickhouse: https://signoz.io/docs/operate/clickhouse/connect-to-clickhouse/

Run below queries to get dump of usage tables:

```SELECT *

FROM signoz_logs.usage

INTO OUTFILE 'logs_usage.csv'

FORMAT CSVWithNames```

```SELECT *

FROM signoz_traces.usage

INTO OUTFILE 'traces_usage.csv'

FORMAT CSVWithNames```

```SELECT *

FROM signoz_metrics.usage

INTO OUTFILE 'metrics_usage.csv'

FORMAT CSVWithNames```

Share this usage data with us.