I currently have a self-hosted Signoz but would like to estimate our costs of switching to Cloud using the Pricing calculator. Between Clickhouse compression and aggregates, it's not clear if COUNT(*) queries on those tables were enough to figure out our Trace / Logs GB and Metrics samples usage. Are there queries I can run against Clickhouse / Signoz to get values to use in the calculator? Thanks!

Hey Hien, 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 SigNoz 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 me over DM.

Thanks Vishal! The initial Support response also mentioned just signing up for a Trial account and piping data to it and our on-prem instance. Is billing / usage data for Signoz cloud exposed enough that we can view it after a few days?

Is billing / usage data for Signoz cloud exposed enough that we can view it after a few days?

Yes billing usage on cloud is updated every 24hrs