Stats API with custom metric takes very long time to respond

[#1]

Hi,

The stats endpoint with custom dimension takes 60s to 120s (~85 seconds)

Endpoint - https://api.enterprise.apigee.com/v1/organizations/ORG_NAME/environments/stage/stats/

Sample request

curl --request GET \
  --url 'https://api.enterprise.apigee.com/v1/organizations/ORG_NAME/environments/stage/stats/?select=sum(custom_metric)&timeRange=8%2F2%2F2016%2018%3A30~8%2F17%2F2016%2006%3A38&timeUnit=day&filter=(developer_email%20eq%20'\''bharath%20c6%40indix.com'\'')' \ 
  --header 'authorization: Basic xxxxxxxxxxxxxx' \
  --header 'content-type: application/json'

Thanks

[spadmanabhan]

hello Jeevan, can you exclude current date in the query and measure the times. Example: in the query you provided, change the end date to 8/16 rather than 8/17. Please let us know of the timings in that case.