Analytics data storage purging

[abhitechm2009]

Hi Team,

I have one query regarding the analytics data storage duration before it get purged.

If I am querying the data of 6 months before the current date in Postgress sql command prompt , i am getting no records as data gets purged after 180 days. but when I select the same date range in Apigee Analytics UI data is getting displayed. Behavior of both should be consistent.

So I want to know what is the reason for this ? As analytics data on UI is fetched frrom Postgress only so why it is getting displayed there?

[#2]

Hi, on which server you are running the query command? Is that master? Is the purging set by you explicitly?

[deepakroy888]

I am seeing the same issue.. we are using the master node

[#4]

The edge UI by default fetches analytics data from the standby server. So, if you have purged in master and still the data is available in standby this could be a reason. So, I would suggest to set purge in both master and standby and see if still you see the same issue.

[deepakroy888]

Acutally i am getting the data even after purging the master node for 1 dimensions query(https://api.enterprise.apigee.com/v1/o/{org_name}/environments/{env_name}/stats/apiproxy) but for multiple dimensions query the data is not coming(https://api.enterprise.apigee.com/v1/o/{org_name}/environments/{env_name}/stats/apiproxy,apiproducts).

Is it different sources from which the query is executed.. Any information will be helpful...

Thanks in Advances

[#6]

can you get into the master and standby both psql command line and find the oldest data available using psql query? That will give the actual data available information.