Hi Team, I have a trace filter as

gc_type.(string) IN "GC"

Which is showing all the traces for our GC Events in our node service, I want to add a dashboard for this on Signoz, with 2 main metrics, the time difference between 2 GCs and the time spent on a GC operation, can someone please help, should I write a Clickhouse query or Query Builder can do this for me ?

@Divyanshu Negi not sure about the 1st but 2nd should be doable in clickhouse query. BTW which language and framework are you using? They should expose GC related metrics too

i am using nestJS framework with Typescript

I see...nodejs runtime metrics like eventloop lag and GC metrics is still not merged

@Divyanshu Negi Here’s a Query which returns avg time spent on a GC span.

SELECT toStartOfInterval(timestamp, INTERVAL 60 SECOND) AS ts, 
avg(durationNano) as value 
from signoz_traces.distributed_signoz_index_v2 where timestamp between
{{.start_datetime}} AND {{.end_datetime}} 
AND stringTagMap['gc_type']='GC' group by ts order by ts

@Vishal Sharma we should replace

now() - INTERVAL 30 MINUTE

with template variables

can you please share the template variable here, would help make the dashboard dynamic for us

@Divyanshu Negi Already updated the query with template variable: https://signoz-community.slack.com/archives/C01HWQ1R0BC/p1683546499779229?thread_ts=1683518495.199619&cid=C01HWQ1R0BC