]> git.openstreetmap.org Git - chef.git/commitdiff
Enable some addition postgres collectors
authorTom Hughes <tom@compton.nu>
Sun, 24 Sep 2023 09:11:11 +0000 (10:11 +0100)
committerTom Hughes <tom@compton.nu>
Sun, 24 Sep 2023 09:11:11 +0000 (10:11 +0100)
cookbooks/postgresql/recipes/default.rb

index 7b5269b071be2bdd927f97fd120b9eb324acd18f..9f713b60e9834f28300df03169dd31a7d323fe92 100644 (file)
@@ -128,7 +128,14 @@ clusters.each do |name, details|
     scrape_interval "1m"
     scrape_timeout "1m"
     user "postgres"
     scrape_interval "1m"
     scrape_timeout "1m"
     user "postgres"
-    options "--collector.process_idle"
+    options %w[
+      --collector.database_wraparound
+      --collector.long_running_transactions
+      --collector.process_idle
+      --collector.stat_activity_autovacuum
+      --collector.stat_wal_receiver
+      --collector.statio_user_indexes
+    ]
     environment "DATA_SOURCE_NAME" => "postgres:///#{prometheus_database}?host=/run/postgresql&port=#{details[:port]}"
     restrict_address_families "AF_UNIX"
     remove_ipc false
     environment "DATA_SOURCE_NAME" => "postgres:///#{prometheus_database}?host=/run/postgresql&port=#{details[:port]}"
     restrict_address_families "AF_UNIX"
     remove_ipc false