top_query_statistics

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

Overview

Name	top_query_statistics
Type	Resource
Id	azure.maria_db.top_query_statistics

Fields

vw_top_query_statistics

Name	Datatype	Description
aggregation_function	text	field from the properties object
database_names	text	field from the properties object
end_time	text	field from the properties object
metric_display_name	text	field from the properties object
metric_name	text	field from the properties object
metric_value	text	field from the properties object
metric_value_unit	text	field from the properties object
queryStatisticId	text	field from the properties object
query_execution_count	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

top_query_statistics

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	queryStatisticId, resourceGroupName, serverName, subscriptionId	Retrieve the query statistic for specified identifier.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId, data__properties	Retrieve the Query-Store top queries for specified metric and aggregation.

SELECT examples

Retrieve the query statistic for specified identifier.

vw_top_query_statistics

SELECT
aggregation_function,
database_names,
end_time,
metric_display_name,
metric_name,
metric_value,
metric_value_unit,
queryStatisticId,
query_execution_count,
query_id,
resourceGroupName,
serverName,
start_time,
subscriptionId
FROM azure.maria_db.vw_top_query_statistics
WHERE queryStatisticId = '{{ queryStatisticId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

top_query_statistics

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