Hello everyone I configured my signoz for my three backend m

Question

Hello everyone I configured my signoz for my three backend microservices user department team I am using Nginx for Load balancer So it redirect request ip port user id on respective ports As signoz is able to show the ports where it redirect after going into Trace by this field net sock host port So as it shows the graphs and statistics for all the aggregated requests I want to club all the request by the port net sock host port to show its rps latency etc individually How we can enable and create graphs on basis of port

Ankit Nayan · Answer

< Ketan Sarode> so basically you want to see application metrics grouped by port And that port is available as `net sock host port` in tags in a trace

Ankit Nayan · Answer

Or are you talking about plotting some metrics from nginx

Ketan Sarode · Answer

want to see application grouped by port

Ketan Sarode · Answer

yes that port is available as `net sock host port` in tags in a trace

Ketan Sarode · Answer

Also want to know Is their some standard mechanism to grouped the metrics by Tags available in a trace

Ankit Nayan · Answer

< Ketan Sarode> for RPS ```select toStartOfInterval timestamp INTERVAL 1 MINUTE AS interval tagMap net sock host port as op name toFloat64 count as value from signoz traces signoz index v2 where serviceName= YOUR SERVICE NAME and kind= 2 and tagMap net sock host port = and timestamp gt now INTERVAL 30 MINUTE group by op name interval order by op name interval asc ```

Ankit Nayan · Answer

for 99th percentile ```select toStartOfInterval timestamp INTERVAL 1 MINUTE AS interval tagMap net sock host port as op name toFloat64 quantile 0 99 durationNano as value from signoz traces signoz index v2 where serviceName= YOUR SERVICE NAME and kind= 2 and timestamp gt now INTERVAL 30 MINUTE group by op name interval order by op name interval asc ```

Ankit Nayan · Answer

for avg duration ```select toStartOfInterval timestamp INTERVAL 1 MINUTE AS interval tagMap net sock host port as op name toFloat64 avg durationNano as value from signoz traces signoz index v2 where serviceName= frontend and kind= 2 and timestamp gt now INTERVAL 30 MINUTE group by op name interval order by op name interval asc ```

Ankit Nayan · Answer

you can freely use similar queries to plot using clickhouse sql query on trace data

Ankit Nayan · Answer

the place would be `Dashboards` gt `Add Panel` gt `CH Query` tab

Ketan Sarode · Answer

Ok thanks Will definitely try this out slightly smiling face

Ankit Nayan · Answer

let me know if you need further help slightly smiling face