I would like to create a notebook query in order to check for the average lock time a specific service is experiencing

[SharonGellerTip]

I want to monitor the average lock time a specific service is experiencing using a DQL query

[LukeHearth · Accepted solution]

Hi @SharonGellerTip 

It may be that the metric you are looking for might not be available in Grail as of yet you can allways check what we have available as built in metrics here

If you do find that the metric you are looking for is in that list then you can write some DQL like this to get the result you are looking for: timeseries Lock_Time=avg(<metric_name>)

Here is an example of querying avg CPU consumption:

timeseries cpu=avg(dt.host.cpu.usage)