Brad Misterek07/12/2023, 2:45 PM
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 Misterek07/13/2023, 11:42 AM
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.
# 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 ;