https://signoz.io logo
Join SlackCommunities
Powered by
This message was deleted.
# support
s
This message was deleted.
s
Can you elaborate what do you mean by ranking based on the name?
a
More specifically, I mean the tag 
graphql.operation.name
Is there any way to generate visual insight by querying traces with certain names? For example a use case could be a dashboard that displays which 
graphql.operation.name
is responsible for the highest latency sum.
Right now I see that we can query by 
graphql.operation.name
on the filter bar of the traces UI, but can we somehow group traces by this tag and then rank it? Perhaps we have to create custom metrics or something, what would you suggest?
Thanks so much
s
You could do that in the dashboards panel. For example say you want to query look at the list of graphql operations with some latency greater than X for last thirty minutes. The query would look like the following.
Copy code
SELECT
    toDateTime(toStartOfMinute(timestamp)) AS minute,
    tagMap['graphql.operation.name'] AS op_name,
    toFloat64(sum(durationNano)) AS value
FROM signoz_traces.signoz_index_v2
WHERE timestamp > toDateTime64(now() - toIntervalMinute(30), 0, 'UTC') AND tagMap['graphql.operation.name'] != ''
GROUP BY
    op_name,
    minute
ORDER BY minute, op_name, value DESC
Dashboards > Some dashboard > Create panel > ClickHouse Query
You can look at the schema for traces table and can write any queries you wish. The only mandatory requirement is that there should be column with datetime type, value column with float type and optional columns with string attribute type if there is some grouping
👀 1
a
@Allan Li if you want avg of the duration for each datapoint in the chart use 
avg(durationNano)
instead of 
sum(durationNano)
and to plot the values correctly use 
nanoseconds(ns)
as y-axis unit in the panel settings as in image attached
a
Thank you both for your help! I will take some time to digest this information.
@Srikanth Chekuri Where would I find the schema for traces table? Sorry I am very new to this.
Oh wait I think I found it on github 👍
s
It might be confusing on the GitHub because there are revisions. You can exec into clickhouse container and run 
SHOW CREATE TABLE signoz_traces.signoz_index_v2
👀 1
a
@Srikanth Chekuri hi, I created a clickhouse query that returns a list of graphql operation names, how would I display it? The dashboard panel only seems to have two operations (timeseries and value), how would I display a list of query results? Thanks
s
Those are the only two types of panels supported at the moment. CC @Pranay
a
ok I see, would your team consider adding a sandbox query that will display raw sql results on the dashboard?
s
Please raise a feature request here so we have something to track https://github.com/sigNoz/signoz
4 Views
Open in Slack
PreviousNext
Powered by