Logging and monitoring

Azure PostgreSQL Server Not Logging Durations

Risk Level

Informational (4)

Platform(s)
Compliance Frameworks

Description

Server {AzurePostgresDbServer} does not log sql statements duration. Durations Logging is useful to identify, troubleshoot and repair configuration errors and sub-optimal performance
  • Recommended Mitigation

    For each database, under server Parameters, set log_duration to ON