Documentation
1 集計関数
特に明记されていない限り、ここにリストされているすべての机能は次の言语でサポートされています。
集计関数は次のいずれかで机能します。
- アイテムの履歴。例:
min(/host/key,1h) - foreach 関数 のパラメータ。例:
min(last_foreach(/*/key))
関数パラメーターに関する一般的な注意事项。
- 関数パラメータはコンマで区切られます。
- オプションの関数パラメーター (またはパラメーター部分) は
<>で示されます - 机能固有のパラメーターは、各机能で説明されています
/host/keyと(sec|#num)<:time shift>はパラメータを引用符で囲んではいけません
共通パラメータ
/host/keyはホストアイテムの履歴を参照する関数の一般的なパラメーターの一つ目です。必须です。(sec|#num)<:time shift>は、ホストのアイテム履歴を参照する関数の一般的なパラメーターの二つ目です。
Function details
Some general notes on function parameters:
- Function parameters are separated by a comma
- Optional function parameters (or parameter parts) are indicated by
<> - Function-specific parameters are described with each function
/host/keyand(sec|#num)<:time shift>parameters must never be quoted
avg(/host/key,(sec|#num)<:time shift>)
The average value of an item within the defined evaluation period.
Supported value types: Float, Integer.
Parameters: see common parameters.
Time shift is useful when there is a need to compare the current average value with the average value some time ago.
Examples:
avg(/host/key,1h) #the average value for the last hour until now
avg(/host/key,1h:now-1d) #the average value for an hour from 25 hours ago to 24 hours ago from now
avg(/host/key,#5) #the average value of the five latest values
avg(/host/key,#5:now-1d) #the average value of the five latest values excluding the values received in the last 24 hoursbucket_percentile(item filter,time period,percentage)
Calculates the percentile from the buckets of a histogram.
Parameters:
- item filter - see item filter;
- time period - see time period;
- percentage - percentage (0-100).
Comments:
- Supported only in calculated items;
- This function is an alias for
histogram_quantile(percentage/100, bucket_rate_foreach(item filter, time period, 1)).
count(func_foreach(item filter,<time period>))
The count of values in an array returned by a foreach function.
Supported value type: Integer.
Parameters:
- func_foreach - foreach function for which the number of returned values should be counted (with supported arguments). See foreach functions for details.
- item filter - see item filter;
- time period - see time period.
Using count() with a history-related foreach function (max_foreach, avg_foreach, etc.) may lead to performance implications, whereas using exists_foreach(), which works only with configuration data, will not have such effect.
Examples:
count(max_foreach(/*/net.if.in[*],1h)) #the number of net.if.in items that received data in the last hour until nowhistogram_quantile(quantile,bucket1,value1,bucket2,value2,...)
Calculates the φ-quantile from the buckets of a histogram.
Parameters:
- quantile - 0 ≤ φ ≤ 1;
- bucketN, valueN - manually entered pairs (>=2) of parameters or the response of bucket_rate_foreach.
Comments:
- Supported only in calculated items;
- Functionally corresponds to '' of PromQL;
- Returns -1 if values of the last 'Infinity' bucket ("+inf") are equal to 0.
Examples:
histogram_quantile(0.75,1.0,last(/host/rate_bucket[1.0]),"+Inf",last(/host/rate_bucket[Inf]))
histogram_quantile(0.5,bucket_rate_foreach(//item_key,30s))item.count(item filter)
The count of existing items in configuration that match the filter criteria.
Supported value type: Integer.
Parameter:
- item filter - criteria for item selection, allows referencing by host group, host, item key, and tags. Wildcards are supported. See item filter for more details.
Comments:
- Supported only in calculated items;
- Works as an alias for the count(exists_foreach(item_filter)) function.
Examples:
item_count(/*/agent.ping?[group="Host group 1"]) #the number of hosts with the *agent.ping* item in the "Host group 1"kurtosis(/host/key,(sec|#num)<:time shift>)
The "tailedness" of the probability distribution in collected values within the defined evaluation period. See also: .
Supported value types: Float, Integer.
Parameters: see common parameters.
Example:
mad(/host/key,(sec|#num)<:time shift>)
The median absolute deviation in collected values within the defined evaluation period. See also: .
Supported value types: Float, Integer.
Parameters: see common parameters.
Example:
max(/host/key,(sec|#num)<:time shift>)
The highest value of an item within the defined evaluation period.
Supported value types: Float, Integer.
Parameters: see common parameters.
Example:
max(/host/key,1h) - min(/host/key,1h) #calculate the difference between the maximum and minimum values within the last hour until now (the delta of values)min(/host/key,(sec|#num)<:time shift>)
The lowest value of an item within the defined evaluation period.
Supported value types: Float, Integer.
Parameters: see common parameters.
Example:
max(/host/key,1h) - min(/host/key,1h) #calculate the difference between the maximum and minimum values within the last hour until now (the delta of values)skewness(/host/key,(sec|#num)<:time shift>)
The asymmetry of the probability distribution in collected values within the defined evaluation period. See also: .
Supported value types: Float, Integer.
Parameters: see common parameters.
Example:
stddevpop(/host/key,(sec|#num)<:time shift>)
The population standard deviation in collected values within the defined evaluation period. See also: .
Supported value types: Float, Integer.
Parameters: see common parameters.
Example:
stddevsamp(/host/key,(sec|#num)<:time shift>)
The sample standard deviation in collected values within the defined evaluation period. See also: .
Supported value types: Float, Integer.
Parameters: see common parameters.
At least two data values are required for this function to work.
Example:
sum(/host/key,(sec|#num)<:time shift>)
The sum of collected values within the defined evaluation period.
Supported value types: Float, Integer.
Parameters: see common parameters.
Example:
sumofsquares(/host/key,(sec|#num)<:time shift>)
The sum of squares in collected values within the defined evaluation period.
Supported value types: Float, Integer.
Parameters: see common parameters.
Example:
varpop(/host/key,(sec|#num)<:time shift>)
The population variance of collected values within the defined evaluation period. See also: .
Supported value types: Float, Integer.
Parameters: see common parameters.
Example:
varsamp(/host/key,(sec|#num)<:time shift>)
The sample variance of collected values within the defined evaluation period. See also: .
Supported value types: Float, Integer.
Parameters: see common parameters.
At least two data values are required for this function to work.
Example:
サポートされているすべての関数を参照してください。