From: Kevin Fenzi <kevin@xxxxxxxxx>
I'd like to log queries on db-koji01 for a short time to try and see whats causing us such pain.
After we have collected a bunch of queries we can revert this until we sort out what needs
to be changed. We may also change this log all to log just slow queries (per smooge's suggestion).
Hopefully this will get us the info we need to track this down.
Signed-off-by: Kevin Fenzi <kevin@xxxxxxxxx>
---
roles/postgresql_server/templates/postgresql.conf | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/roles/postgresql_server/templates/postgresql.conf b/roles/postgresql_server/templates/postgresql.conf
index 00320a8..c38a2fd 100644
--- a/roles/postgresql_server/templates/postgresql.conf
+++ b/roles/postgresql_server/templates/postgresql.conf
@@ -268,7 +268,7 @@ log_truncate_on_rotation = on # If on, an existing log file of the
# in all cases.
log_rotation_age = 1d # Automatic rotation of logfiles will
# happen after that time. 0 to disable.
-log_rotation_size = 0 # Automatic rotation of logfiles will
+log_rotation_size = 10000 # Automatic rotation of logfiles will
# happen after that much log output.
# 0 to disable.
@@ -357,8 +357,8 @@ log_checkpoints = on
# processes
# %% = '%'
# e.g. '<%u%%%d> '
-#log_lock_waits = off # log lock waits >= deadlock_timeout
-#log_statement = 'none' # none, ddl, mod, all
+log_lock_waits = on # log lock waits >= deadlock_timeout
+log_statement = 'all' # none, ddl, mod, all
log_temp_files = 0 # log temporary files equal or larger
# than specified size;
# -1 disables, 0 logs all temp files
--
1.8.3.1
_______________________________________________
infrastructure mailing list -- infrastructure@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to infrastructure-leave@xxxxxxxxxxxxxxxxxxxxxxx
Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@xxxxxxxxxxxxxxxxxxxxxxx
