Monitoring: Metrics Improve HTTP and DB collection

Is your feature request related to a problem?
Currently, we have minimal metrics collected from HTTP middleware, and all DB metrics are blocked. This limits our ability to monitor performance and troubleshoot issues effectively.

Describe the solution you'd like
Enhance metrics collection for both HTTP and DB. Specifically:

• HTTP metrics:

  1. Traffic at platform and endpoint level (excluding general endpoints like health)
  2. Latency
  3. Errors

• DB metrics:

  1. Query performance
  2. Slow queries
  3. Overview of connections (open/close/invalidate)
  4. Transactions (commit vs rollback ratio)