fetch logs
| filter dt.host_group.id == “XXXX” AND log.file.path == “XXXXX”
| parse content, “”"
DATA
‘(512M)’ // Literal string just before the ms value
SPACE // Space character before the desired value
(DIGIT ‘.’ DIGIT):value // The value column will contain the desired number, if it’s always in the form X.XXX
‘ms’ // To end the parsing
If you want to plot the values, or handle them as a number, you can use the following command:
| fieldsAdd value = toDouble(value)
Adding to @jmarbaix’s answer, you could also use this parse in case you don’t have that 512M as static:
parse content, “LD’->’ LD SPACE (DIGIT’.'DIGIT):value ‘ms’”
Note: if you convert it to double it will round the value to 2 decimal points. In which case, you can straight up transfomr it to double by doing: DOUBLE:value in the parse.