Log statements taking longer than 1s on the main database
authorTom Hughes <tom@compton.nu>
Fri, 22 Dec 2017 11:21:37 +0000 (11:21 +0000)
committerTom Hughes <tom@compton.nu>
Fri, 22 Dec 2017 11:21:37 +0000 (11:21 +0000)
roles/db.rb

index f3c3244..d81ad24 100644 (file)
@@ -49,6 +49,7 @@ default_attributes(
         :max_wal_size => "1536MB",
         :checkpoint_completion_target => "0.8",
         :cpu_tuple_cost => "0.1",
+        :log_min_duration_statement => "1000",
         :late_authentication_rules => [
           { :address => "146.179.159.160/27" },
           { :address => "10.0.16.0/20" },