optimized_stats

Creates, updates, deletes, gets or lists an optimized_stats resource.

Overview

Name	optimized_stats
Type	Resource
Id	google.apigee.optimized_stats

Fields

The following fields are returned by SELECT queries:

organizations_environments_optimized_stats_get

Successful response

Name	Datatype	Description
Response	object	Wraps the stats response for JavaScript Optimized Scenario with a response key. For example: { "Response": { "TimeUnit": [], "metaData": { "errors": [], "notices": [ "Source:Postgres", "Table used: edge.api.aaxgroup001.agg_api", "PG Host:ruappg08-ro.production.apigeeks.net", "query served by:80c4ebca-6a10-4a2e-8faf-c60c1ee306ca" ] }, "resultTruncated": false, "stats": { "data": [ { "identifier": { "names": [ "apiproxy" ], "values": [ "sirjee" ] }, "metric": [ { "env": "prod", "name": "sum(message_count)", "values": [ 36.0 ] }, { "env": "prod", "name": "sum(is_error)", "values": [ 36.0 ] } ] } ] } } } (id: GoogleCloudApigeeV1OptimizedStatsResponse)

organizations_optimized_host_stats_get

Successful response

Name	Datatype	Description
Response	object	Wraps the stats response for JavaScript Optimized Scenario with a response key. For example: { "Response": { "TimeUnit": [], "metaData": { "errors": [], "notices": [ "Source:Postgres", "Table used: edge.api.aaxgroup001.agg_api", "PG Host:ruappg08-ro.production.apigeeks.net", "query served by:80c4ebca-6a10-4a2e-8faf-c60c1ee306ca" ] }, "resultTruncated": false, "stats": { "data": [ { "identifier": { "names": [ "apiproxy" ], "values": [ "sirjee" ] }, "metric": [ { "env": "prod", "name": "sum(message_count)", "values": [ 36.0 ] }, { "env": "prod", "name": "sum(is_error)", "values": [ 36.0 ] } ] } ] } } } (id: GoogleCloudApigeeV1OptimizedStatsResponse)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
organizations_environments_optimized_stats_get	select	organizationsId, environmentsId, optimizedStatsId	select, timeUnit, timeRange, filter, sort, sortby, aggTable, limit, offset, topk, tsAscending, realtime, sonar, tzo, accuracy	Similar to GetStats except that the response is less verbose.
organizations_optimized_host_stats_get	select	organizationsId, optimizedHostStatsId	select, timeUnit, timeRange, filter, sort, sortby, limit, offset, topk, tsAscending, realtime, tzo, accuracy, envgroupHostname	Similar to GetHostStats except that the response is less verbose.

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
environmentsId	string
optimizedHostStatsId	string
optimizedStatsId	string
organizationsId	string
accuracy	string
aggTable	string
envgroupHostname	string
filter	string
limit	string
offset	string
realtime	boolean
select	string
sonar	boolean
sort	string
sortby	string
timeRange	string
timeUnit	string
topk	string
tsAscending	boolean
tzo	string

SELECT examples

organizations_environments_optimized_stats_get

Similar to GetStats except that the response is less verbose.

SELECT
Response
FROM google.apigee.optimized_stats
WHERE organizationsId = '{{ organizationsId }}' -- required
AND environmentsId = '{{ environmentsId }}' -- required
AND optimizedStatsId = '{{ optimizedStatsId }}' -- required
AND select = '{{ select }}'
AND timeUnit = '{{ timeUnit }}'
AND timeRange = '{{ timeRange }}'
AND filter = '{{ filter }}'
AND sort = '{{ sort }}'
AND sortby = '{{ sortby }}'
AND aggTable = '{{ aggTable }}'
AND limit = '{{ limit }}'
AND offset = '{{ offset }}'
AND topk = '{{ topk }}'
AND tsAscending = '{{ tsAscending }}'
AND realtime = '{{ realtime }}'
AND sonar = '{{ sonar }}'
AND tzo = '{{ tzo }}'
AND accuracy = '{{ accuracy }}';

organizations_optimized_host_stats_get

Similar to GetHostStats except that the response is less verbose.

SELECT
Response
FROM google.apigee.optimized_stats
WHERE organizationsId = '{{ organizationsId }}' -- required
AND optimizedHostStatsId = '{{ optimizedHostStatsId }}' -- required
AND select = '{{ select }}'
AND timeUnit = '{{ timeUnit }}'
AND timeRange = '{{ timeRange }}'
AND filter = '{{ filter }}'
AND sort = '{{ sort }}'
AND sortby = '{{ sortby }}'
AND limit = '{{ limit }}'
AND offset = '{{ offset }}'
AND topk = '{{ topk }}'
AND tsAscending = '{{ tsAscending }}'
AND realtime = '{{ realtime }}'
AND tzo = '{{ tzo }}'
AND accuracy = '{{ accuracy }}'
AND envgroupHostname = '{{ envgroupHostname }}';