Disable table monitor for promscale postgres instance
authorTom Hughes <tom@compton.nu>
Mon, 1 Feb 2021 20:21:24 +0000 (20:21 +0000)
committerTom Hughes <tom@compton.nu>
Mon, 1 Feb 2021 20:22:00 +0000 (20:22 +0000)
cookbooks/postgresql/attributes/default.rb
cookbooks/postgresql/templates/default/postgres_queries.yml.erb
cookbooks/timescaledb/recipes/default.rb

index 4882e77b1a260161c24b3215b40a1b60ea9276c1..cc8c9a59ef00d73f995444f46d70164ce4d5a149 100644 (file)
@@ -1,5 +1,6 @@
 default[:postgresql][:versions] = []
 default[:postgresql][:clusters] = {}
+default[:postgresql][:monitor_tables] = true
 default[:postgresql][:settings][:defaults][:port] = "5432"
 default[:postgresql][:settings][:defaults][:max_connections] = "100"
 default[:postgresql][:settings][:defaults][:ssl] = "true"
index a61359d19ada2a6620830fd1ee8d7e13000ddf90..c2fc048c8391cf8ff1f86bbd2d334d550246d04f 100644 (file)
@@ -13,6 +13,7 @@ pg_postmaster:
     - start_time_seconds:
         usage: "GAUGE"
         description: "Time at which postmaster started"
+<% if node[:postgresql][:monitor_tables] -%>
 
 pg_stat_user_tables:
   query: "SELECT current_database() datname, schemaname, relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, n_mod_since_analyze, COALESCE(last_vacuum, '1970-01-01Z'), COALESCE(last_vacuum, '1970-01-01Z') as last_vacuum, COALESCE(last_autovacuum, '1970-01-01Z') as last_autovacuum, COALESCE(last_analyze, '1970-01-01Z') as last_analyze, COALESCE(last_autoanalyze, '1970-01-01Z') as last_autoanalyze, vacuum_count, autovacuum_count, analyze_count, autoanalyze_count FROM pg_stat_user_tables"
@@ -120,7 +121,8 @@ pg_statio_user_tables:
     - tidx_blks_hit:
         usage: "COUNTER"
         description: "Number of buffer hits in this table's TOAST table indexes (if any)"
-        
+<% end -%>
+
 pg_database:
   query: "SELECT pg_database.oid AS datid, pg_database.datname, pg_database_size(pg_database.datname) AS size_bytes FROM pg_database"
   master: true
index 4ae90c361c7966afb0b87dabf815e096b15683cb..776cab65534782ed50de637ad37205ee595fbed7 100644 (file)
@@ -30,6 +30,7 @@ memory_gb = (node[:memory][:total].to_f / 1024 / 1024).ceil
 
 node.default_unless[:postgresql][:versions] = []
 node.default[:postgresql][:versions] |= [database_version]
+node.default[:postgresql][:monitor_tables] = false
 node.default[:postgresql][:settings][database_version][:max_connections] = 500
 node.default[:postgresql][:settings][database_version][:shared_buffers] = "#{memory_gb / 4}GB"
 node.default[:postgresql][:settings][database_version][:work_mem] = "#{memory_gb * 128 / 50 / node[:cpu][:total]}MB"