Dan Tulovsky
07/18/2025, 1:17 PMDan Tulovsky
07/18/2025, 1:45 PMHien Le
07/18/2025, 4:30 PMFollow 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.
Dan Tulovsky
07/18/2025, 4:31 PMDan Tulovsky
07/18/2025, 4:31 PM