database_statistics

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

Overview

Name	database_statistics
Type	Resource
Id	ovh.hosting_web.database_statistics

Fields

The following fields are returned by SELECT queries:

list

A value set tagged with its unit and serie name

Name	Datatype	Description
serie_name	string	(wire: serieName)
unit	string
values	array

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	name, period, service_name, type		Get database statistics. Returns the number of statements or their mean execution time over a period.

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.

Name	Datatype	Description
api_host	string	The 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"}})
name	string	Database name (like mydb.mysql.db or mydb.postgres.db)
period	string	Available periods for statistics
service_name	string	The internal name of your hosting (wire: serviceName)
type	string	Types of statistics available for the database

SELECT examples

list

Get database statistics. Returns the number of statements or their mean execution time over a period.

SELECT
serie_name,
unit,
values
FROM ovh.hosting_web.database_statistics
WHERE name = '{{ name }}' -- required
AND period = '{{ period }}' -- required
AND service_name = '{{ service_name }}' -- required
AND type = '{{ type }}' -- required
;