wait_statistics

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

Overview

Name	wait_statistics
Type	Resource
Id	azure.maria_db.wait_statistics

Fields

vw_wait_statistics

Name	Datatype	Description
count	text	field from the properties object
database_name	text	field from the properties object
end_time	text	field from the properties object
event_name	text	field from the properties object
event_type_name	text	field from the properties object
query_id	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
start_time	text	field from the properties object
subscriptionId	text	field from the properties object
total_time_in_ms	text	field from the properties object
user_id	text	field from the properties object
waitStatisticsId	text	field from the properties object

wait_statistics

Name	Datatype	Description
properties	object	The properties of a wait statistic.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, serverName, subscriptionId, waitStatisticsId	Retrieve wait statistics for specified identifier.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId, data__properties	Retrieve wait statistics for specified aggregation window.

SELECT examples

Retrieve wait statistics for specified identifier.

vw_wait_statistics

SELECT
count,
database_name,
end_time,
event_name,
event_type_name,
query_id,
resourceGroupName,
serverName,
start_time,
subscriptionId,
total_time_in_ms,
user_id,
waitStatisticsId
FROM azure.maria_db.vw_wait_statistics
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND waitStatisticsId = '{{ waitStatisticsId }}';

wait_statistics

SELECT
properties
FROM azure.maria_db.wait_statistics
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND waitStatisticsId = '{{ waitStatisticsId }}';