Ketan Sarode
11/07/2022, 6:56 AMAnkit Nayan
net.sock.host.port
in tags in a trace?Ketan Sarode
11/07/2022, 12:49 PMnet.sock.host.port
in tags in a traceAnkit Nayan
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 > now() - INTERVAL 30 MINUTE group by (op_name, interval) order by (op_name, interval) asc;
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 > now() - INTERVAL 30 MINUTE group by (op_name, interval) order by (op_name, interval) asc;
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 > now() - INTERVAL 30 MINUTE group by (op_name, interval) order by (op_name, interval) asc;
Dashboards
-> Add Panel
-> CH Query
tabKetan Sarode
11/07/2022, 4:15 PMAnkit Nayan