swagger: '2.0' info: version: 2020-08-01-preview title: Microsoft Azure AccessControlClient AccessConnector TopQueryStatistics API schemes: - https tags: - name: TopQueryStatistics paths: ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMariaDB/servers/{serverName}/topQueryStatistics/{queryStatisticId} : get: tags: - TopQueryStatistics operationId: microsoftAzureTopquerystatisticsGet x-ms-examples: TopQueryStatisticsGet: $ref: ./examples/TopQueryStatisticsGet.json description: Retrieve the query statistic for specified identifier. parameters: - $ref: '#/parameters/ApiVersionParameter' - $ref: '#/parameters/SubscriptionIdParameter' - $ref: '#/parameters/ResourceGroupParameter' - $ref: '#/parameters/ServerNameParameter' - $ref: '#/parameters/QueryStatisticIdParameter' responses: '200': description: OK schema: $ref: '#/definitions/QueryStatistic' summary: Microsoft Azure Get Subscriptions Subscriptionid Resourcegroups Resourcegroupname Providers Microsoft Dbformariadb Servers Servername Topquerystatistics Querystatisticid ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMariaDB/servers/{serverName}/topQueryStatistics : get: tags: - TopQueryStatistics operationId: microsoftAzureTopquerystatisticsListbyserver x-ms-examples: TopQueryStatisticsListByServer: $ref: ./examples/TopQueryStatisticsListByServer.json description: Retrieve the Query-Store top queries for specified metric and aggregation. parameters: - $ref: '#/parameters/ApiVersionParameter' - $ref: '#/parameters/SubscriptionIdParameter' - $ref: '#/parameters/ResourceGroupParameter' - $ref: '#/parameters/ServerNameParameter' - name: parameters in: body required: true schema: $ref: '#/definitions/TopQueryStatisticsInput' description: The required parameters for retrieving top query statistics. responses: '200': description: OK schema: $ref: '#/definitions/TopQueryStatisticsResultList' x-ms-pageable: nextLinkName: nextLink summary: Microsoft Azure Get Subscriptions Subscriptionid Resourcegroups Resourcegroupname Providers Microsoft Dbformariadb Servers Servername Topquerystatistics definitions: QueryStatistic: properties: properties: $ref: '#/definitions/QueryStatisticProperties' x-ms-client-flatten: true description: The properties of a query statistic. allOf: - $ref: ../../../../../common-types/resource-management/v1/types.json#/definitions/ProxyResource description: Represents a Query Statistic. TopQueryStatisticsResultList: description: A list of query statistics. type: object properties: value: description: The list of top query statistics. type: array items: $ref: '#/definitions/QueryStatistic' readOnly: true nextLink: description: Link to retrieve next page of results. type: string readOnly: true TopQueryStatisticsInputProperties: properties: numberOfTopQueries: type: integer format: int32 description: Max number of top queries to return. aggregationFunction: type: string description: Aggregation function name. observedMetric: type: string description: Observed metric name. observationStartTime: type: string format: date-time description: Observation start time. observationEndTime: type: string format: date-time description: Observation end time. aggregationWindow: type: string description: Aggregation interval type in ISO 8601 format. required: - numberOfTopQueries - aggregationFunction - observedMetric - observationStartTime - observationEndTime - aggregationWindow description: The properties for input to get top query statistics TopQueryStatisticsInput: properties: properties: $ref: '#/definitions/TopQueryStatisticsInputProperties' x-ms-client-flatten: true description: The properties of a wait statistics input. required: - properties description: Input to get top query statistics QueryStatisticProperties: properties: queryId: type: string description: Database query identifier. startTime: type: string format: date-time description: Observation start time. endTime: type: string format: date-time description: Observation end time. aggregationFunction: type: string description: Aggregation function name. databaseNames: type: array items: type: string description: The list of database names. queryExecutionCount: type: integer format: int64 description: Number of query executions in this time interval. metricName: type: string description: Metric name. metricDisplayName: type: string description: Metric display name. metricValue: type: number format: double description: Metric value. metricValueUnit: type: string description: Metric value unit. description: The properties of a query statistic. parameters: ApiVersionParameter: name: api-version in: query required: true type: string description: The API version to use for the request. ServerNameParameter: name: serverName in: path required: true type: string description: The name of the server. x-ms-parameter-location: method ResourceGroupParameter: name: resourceGroupName in: path required: true type: string description: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal. x-ms-parameter-location: method QueryStatisticIdParameter: name: queryStatisticId in: path required: true type: string description: The Query Statistic identifier. x-ms-parameter-location: method SubscriptionIdParameter: name: subscriptionId in: path required: true type: string description: The subscription ID that identifies an Azure subscription. x-ms-parameterized-host: hostTemplate: '{endpoint}' useSchemePrefix: false parameters: - $ref: '#/parameters/Endpoint'