When troubleshooting performance-related issues in Artifactory with PostgreSQL, it is crucial to gather the appropriate information to facilitate effective analysis and optimization of the database's performance. Instances may arise where you encounter problems such as slowness, unresponsiveness in Artifactory, timeouts when retrieving large data through AQL, or delays in package search functionality. These challenges often stem from the underlying database struggling to execute the queries triggered by Artifactory.
To address these concerns, this article will provide you with a comprehensive guide on the essential steps to collect the necessary basic data in PostgreSQL.
By following these steps, you will be equipped with the information required to diagnose and help to find a way for improving the performance of your Artifactory instance