Overview
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.
Environment
Sensage AP 5.0.1 version
Requirement
Access to Sensage AP environment
Root Cause
Large reports cached and lack of maintenance of Postgres database.
Resolution
Do the following to improve the performance of the Analyzer Console:
-
Delete cached results for all reports leaving only for a week.
-
Perform a
vacuumdbon the Postgres node to reclaim any free space and optimize the database operation.
Confirmation
Running reports should go back to standard execution times.
Comments
0 comments
Please sign in to leave a comment.