For TPS you can use below queries which you will need to run from postgresql across all orgs.
psql -h <hostname> -d apigee -U <user>
eg:
Query to return the 15 days with the highest number of messages per minute between March 30, 2019, and May 31, 2020.
SELECT timestamp,
SUM(message_count)/60.0 AS MAXTPS
FROM analytics."<ORG>.<ENV>.agg_api"
WHERE timestamp >= '2019-3-30 00:00:00'
AND timestamp < '2020-5-31 00:00:00'
GROUP BY 1
ORDER BY MAXTPS DESC
LIMIT 15;
eg:
Query to return the 15 days with the highest average number of messages per day between March 30, 2019, and May 31, 2020.
SELECT
DATE_TRUNC('day', timestamp AT time zone '-0:0:0')::timestamp without time zone AS time_unit,
SUM(message_count)/86400.0 AS AVGTPS
FROM analytics."<ORG>.<ENV>.agg_api"
WHERE timestamp >= '2019-3-30 00:00:00'
AND timestamp < '2020-5-31 00:00:00'
GROUP BY 1
ORDER BY AVGTPS DESC
LIMIT 15;
There are so many reasons to move towards apigee x as lot of new features/ integrations are in place which you may be missing out.You can pilot it and explore the difference and of all you don't have to worry about managing the infra part..If you still want to proceed with on-prem may be nice to talk if possible once you collect data.
LinkedIn
Twitter
