PostgreSQL duration logging is not enabled

ID

azure_postgresql_log_duration

Severity

low

Vendor

Azure

Resource

Logging

Tags

non-reachable

Description

PostgreSQL duration logging is not enabled. It is recommended to activate this option for performance analysis.

For that you must configure the option log_duration=On.

Learn more about this topic at Azure PostgreSQL module.

Examples

---
- name: Example playbook
  hosts: localhost
  tasks:
    - name: Update PostgreSQL Server setting
      azure_rm_postgresqlconfiguration:
        resource_group: myResourceGroup
        server_name: myServer2
        name: log_duration
        value: Off

Mitigation / Fix

---
- name: Example playbook
  hosts: localhost
  tasks:
    - name: Update PostgreSQL Server setting
      azure_rm_postgresqlconfiguration:
        resource_group: myResourceGroup
        server_name: myServer2
        name: log_duration
        value: On