Skip to main content

statistics

Creates, updates, deletes, gets or lists a statistics resource.

Overview​

Namestatistics
TypeResource
Idovh.over_the_box.statistics

Fields​

The following fields are returned by SELECT queries:

Device Statistics Datapoints

NameDatatypeDescription
namestringName of the serie
pointsarrayList of point
tagsarrayList of tags
unitstringUnit of the serie (bps, byte, n/a)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectmetrics_type, service_nameperiodReturns the load, free memory or traffic series of the device for an hourly, daily, weekly or monthly period, each series with its unit, tags and timestamped points. (Beta version)

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
api_hoststringThe OVHcloud API host. Selected by OVH_ENDPOINT (ovh-eu, ovh-ca or ovh-us; default ovh-eu). (default: api.eu.ovhcloud.com, x-stackQL-envVarSelector: {"envVar":"OVH_ENDPOINT","default":"ovh-eu","values":{"ovh-eu":"api.eu.ovhcloud.com","ovh-ca":"api.ca.ovhcloud.com","ovh-us":"api.us.ovhcloud.com"}})
metrics_typestringType of metrics you want to retrieve (wire: metricsType)
service_namestringService name (wire: serviceName)
periodstringPeriod (default is daily)

SELECT examples​

Returns the load, free memory or traffic series of the device for an hourly, daily, weekly or monthly period, each series with its unit, tags and timestamped points. (Beta version)

SELECT
name,
points,
tags,
unit
FROM ovh.over_the_box.statistics
WHERE metrics_type = '{{ metrics_type }}' -- required
AND service_name = '{{ service_name }}' -- required
AND period = '{{ period }}'
;