From 0d5f8536e0ddf09a6b923e1bc01f79f27e3ba05d Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Fri, 22 Dec 2017 11:21:37 +0000
Subject: [PATCH 1/1] Log statements taking longer than 1s on the main database

---
 roles/db.rb | 1 +
 1 file changed, 1 insertion(+)

diff --git a/roles/db.rb b/roles/db.rb
index f3c324422..d81ad24d9 100644
--- a/roles/db.rb
+++ b/roles/db.rb
@@ -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" },
-- 
2.43.2