Logging and monitoring

PostgreSQL instance with ‘log_duration’ disabled

Risk Level

Informational (4)

Platform(s)
Compliance Frameworks

Description

Enabling the log_duration setting causes the duration of each completed statement to be logged. Monitoring the time taken to execute the queries can be crucial in identifying any resource hogging queries and assessing the performance of the server. Further steps such as load balancing and use of optimized queries can be taken to ensure the performance and stability of the server.
  • Recommended Mitigation

    Make sure 'log_duration' database flag is set to 'on'