The Heavy Database Query Monitor add-on for Creatio provides advanced monitoring and analysis of resource-intensive database queries. It allows system administrators and developers to track, evaluate, and optimize queries that may be affecting system performance. The add-on is designed to improve operational efficiency by identifying slow or problematic queries and presenting them in a user-friendly interface for further analysis. Users can define customizable thresholds for what constitutes a "heavy" query, tailoring the monitoring system to their specific needs.

Use Case Scenarios:

• Performance Troubleshooting:
  A system administrator notices that the Creatio system is slowing down during peak hours. Using the add-on, they identify specific queries that are taking longer than expected to execute, analyze their performance metrics, and either adjust the query logic or notify the development team to optimize the code.

• Proactive Monitoring:
  A database administrator can set up alerts for queries that exceed certain execution time thresholds. Whenever a query runs for too long, the add-on sends an alert, allowing the admin to investigate and resolve the issue before it impacts the end-user experience.

• Optimizing Complex Queries:
  A developer working on a new feature for Creatio notices that a particular query is underperforming. By using the add-on to review historical performance data and query execution metrics, they are able to identify inefficiencies and manually optimize the query, significantly reducing its execution time.

• Load Balancing & Scaling Decisions:
  Based on the historical data collected by the add-on, a technical architect can make informed decisions about scaling infrastructure or optimizing the load balance of queries during high-traffic periods.

This add-on is ideal for organizations that prioritize system efficiency and need a streamlined way to monitor and address heavy database queries.

Deployment and Compatibility:
The add-on is currently available exclusively for on-site Creatio installations using PostgreSQL databases. Support for other database systems may be considered in future updates.