Update database module with metrics.

Change Summary

This update introduces a new configuration parameter to enable metrics collection for the PostgreSQL database managed by ArgoCD. Specifically, the metrics.enabled parameter has been added and set to true.

Technical Details

• File Modified: IaC/modules/database/main.tf
• Added Parameter:

  parameter {
    name  = "metrics.enabled"
    value = "true"
  }
  

  This parameter is nested within the argocd_application resource for the PostgreSQL database.

• Resource: argocd_application "postgresql"
• Configuration Change: The addition of the metrics.enabled parameter allows the PostgreSQL instance to expose metrics endpoints, which can be scraped by monitoring systems like Prometheus.

Key Learnings & Insights

• Monitoring Importance: Enabling metrics collection is crucial for observability. It allows operations teams to monitor the health and performance of the database in real-time.
• Configuration-as-Code: Using Infrastructure as Code (IaC) to manage configuration parameters ensures consistency and reduces the risk of manual errors.
• Trade-offs: Enabling metrics may introduce a slight overhead in terms of resource usage. However, the benefits of enhanced monitoring typically outweigh this minor cost.

Impact Assessment

• System Observability: This change significantly improves the observability of the PostgreSQL database by providing metrics that can be used for performance tuning and alerting.
• Maintenance: Future maintenance tasks will be simpler as metrics-related configurations are now part of the IaC, ensuring consistency across environments.
• Performance: There may be a negligible performance impact due to the additional metrics collection, but this is generally acceptable given the benefits.

Developer Notes

• Gotchas: Ensure that the monitoring system (e.g., Prometheus) is correctly configured to scrape the new metrics endpoints.
• Future Improvements: Consider adding more granular metrics or custom metrics based on specific use cases to further enhance monitoring capabilities.