This message was deleted SigNoz Community #support

Join Slack

This message was deleted.

# support

Slackbot

01/17/2023, 10:52 AM

This message was deleted.

nitya-signoz

01/17/2023, 10:54 AM

You will need to convert

env

and

level

to selected fields first, from the UI. This will reduce the load on the database.

👀 1

Jason Brewer

01/17/2023, 10:54 AM

(chart preview)

Jason Brewer

01/17/2023, 10:56 AM

Is that simply by adding them to this list?

👍 1

nitya-signoz

01/17/2023, 10:56 AM

Then you will be able to use the columns directly

Copy code

select toStartOfInterval(fromUnixTimestamp64Nano(timestamp), INTERVAL 1 MINUTE) AS interval, quantile(0.9)(bytes) as value from signoz_logs.logs  where timestamp > toUnixTimestamp64Nano(now64() - INTERVAL 30 MINUTE)  group by interval order by interval asc;

Eg:- here I have used the

bytes

which is a selected field.

❤️ 1

Jason Brewer

01/17/2023, 10:58 AM

oh wow - so it's literally just as simple as something like this?

Copy code

select 
toStartOfInterval(fromUnixTimestamp64Nano(timestamp), INTERVAL 30 MINUTE) AS interval
, toFloat64(count()) as value
, level 
FROM signoz_logs.distributed_logs  
WHERE timestamp BETWEEN {{.start_timestamp_nano}} AND {{.end_timestamp_nano}} and level = 'error'
GROUP BY interval, level;

Jason Brewer

01/17/2023, 11:01 AM

I'm also a little confused about the difference between

signoz_logs.logs

and

signoz_logs.distributed_logs

. From reading other messages on here it seems like

distributed_logs

operates across a clickhouse cluster? I'm running the entire Signoz stack on a single machine via docker-compose. Presumably, for my set up at least, there should be no difference in the results returned between

signoz_logs.logs

and

signoz_logs.distributed_logs

nitya-signoz

01/17/2023, 11:02 AM

Yeah, please go ahead with

distributed_logs

, it is just a wrapper on top of

logs

for distributed support.

✅ 1

Jason Brewer

01/17/2023, 11:05 AM

I can confirm that this query runs exactly as expected:

Copy code

select 
toStartOfInterval(fromUnixTimestamp64Nano(timestamp), INTERVAL 30 MINUTE) AS interval
, toFloat64(count()) as value  
FROM signoz_logs.distributed_logs 
WHERE timestamp BETWEEN {{.start_timestamp_nano}} AND {{.end_timestamp_nano}} 
and level = 'error' 
and env = 'dev'
and service = 'graphql'
GROUP BY interval;

Thanks so much @nitya-signoz!

🎉 2

12 Views

Open in Slack

Previous Next