by default 'log_min_duration = 1000' should be configured for PostgreSQL
To gather more data when checking support cases, having 'log_min_duration = 1000' in PostgreSQL config by default would be great.
'log_min_duration = 500' should be in PostgreSQL config file on both freshly installed and upgraded Satellite:
- grep log_min_duration /var/lib/pgsql/data/postgresql.conf
Tuning profiles already have 'log_min_duration = 500'
Note this can be also achieved via /etc/foreman-installer/custom-hiera.yaml by:
By including it as default, users can only disable it by setting the value to -1 in custom-hiera.yaml.
Fixes #27846 - Add Postgresql log_min_duration
With this change, queries taking longer than a second will be logged.
This makes it easier to debug performance issues.
Users can disable this by setting the value to -1 via another hiera
#3 Updated by Ewoud Kohl van Wijngaarden 10 months ago
- Status changed from Ready For Testing to Closed
Applied in changeset installer|27cae009024c45201d6c373723011d974d39d950.