Reports are taking a long time or are not running in the Analyzer Console. This article shares information for improving the performance of Analyzer Console.
Sensage AP 5.0.1 version
Access to Sensage AP environment
Large reports cached and lack of maintenance of Postgres database.
Do the following to improve the performance of the Analyzer Console:
Delete cached results for all reports leaving only for a week.
vacuumdbon the Postgres node to reclaim any free space and optimize the database operation.
Running reports should go back to standard execution times.