Brad Misterek
07/12/2023, 2:45 PMBrad Misterek
07/12/2023, 2:53 PMPranay
One of the graphs that I find very useful is the amount of time spend in different areas of the code (specifically, database, application, and eternal calls).Trying to understand this use case a bit better - was the out of the box graphs in SigNoz with latency, DBs and external not helpful for this. Can you share the dashboard which you used in Grafana so that we can get a better idea of what you were trying to see
Brad Misterek
07/13/2023, 11:42 AMBrad Misterek
07/13/2023, 11:42 AMhttps://i.ytimg.com/vi/EGMacfyuA9w/maxresdefault.jpg▾
Brad Misterek
07/13/2023, 11:43 AMBrad Misterek
07/13/2023, 11:44 AMBrad Misterek
07/13/2023, 11:51 AM# External
SELECT DATE_TRUNC('minute', timestamp) AS interval, SUM(durationNano) / 1000000 as ms
FROM signoz_traces.signoz_index_v2
WHERE externalHttpMethod!='' AND serviceName='myservice'
GROUP BY DATE_TRUNC('minute', timestamp) ORDER BY interval ;
# Database
SELECT DATE_TRUNC('minute', timestamp) AS time, SUM(durationNano) / 1000000
FROM signoz_traces.signoz_index_v2
WHERE dbName!='' AND serviceName='myservice'
GROUP BY DATE_TRUNC('minute', timestamp) ORDER BY time ;
And then my "other" bucket is just latency minus those two numbers.
Also, note -- I wouldn't say these are super great, but it is the road I'm going down, since this is the kind of information that I find useful. I'm not sure the Ruby OTEL collector gives me the best data to work with.
And, all that being said, I may have been able to build similar in the signoz dashboard. BUT, i think having something like that working out of the box would be amazing.Brad Misterek
07/13/2023, 11:53 AMBrad Misterek
07/13/2023, 12:39 PM