Hi, i setup signoz for k8s monitoring via otel, i want to connect directly to clickhouse so i can create custom queries. i checked the

signoz_metrics

db

distributed_time_series_v4

(assuming this is what i should use for getting metrics). where is metric value stored ?

It exists in

samples_v4

table with column name

value

is there a reason why the table doesn't contain labels ?

That would be redundant labels for each measurement and make the storage usage unnecessarily high.

so would joining on fingerprint would give correct result ? or is unix_milli required ?

Joining on fingerprint will give the correct result. The unix_milli on

samples

table indicates when measurement is produced.

awesome thank you

yes

for metrics, here is my query

SELECT ts.fingerprint, ts.metric_name, samples.unix_milli, samples.value
FROM
    distributed_time_series_v4 ts
    JOIN distributed_samples_v4 samples ON ts.fingerprint = samples.fingerprint
WHERE
    ts.metric_name = 'container_cpu_utilization'
    AND JSONExtractString (
        ts.labels, 'k8s_container_name'
    ) LIKE 'myapp%'
ORDER BY samples.unix_milli DESC
LIMIT 10;

The

time_series_v4

can contain duplicates. You should take care of that in the query. Why are you writing your own queries? Does the query builder not support what you are trying to achieve?

i need to do some custom logic, and use like api

Yes, the

distributed_time_series_v4

attempts to have one row for each unique time series, ``distributed_time_series_v4_6hrs`` one row for 6hrs and ``distributed_time_series_v4_1day`` one row for a day. So that when we query the large duration we can reduce the amount of data read which means faster queries.