1 files changed, 39 insertions, 0 deletions
diff --git a/lib/gitlab/database/health_status/indicators/autovacuum_active_on_table.rb b/lib/gitlab/database/health_status/indicators/autovacuum_active_on_table.rb
new file mode 100644
index 00000000000..6bf2bbf0c70
--- /dev/null
+++ b/lib/gitlab/database/health_status/indicators/autovacuum_active_on_table.rb
@@ -0,0 +1,39 @@
+# frozen_string_literal: true
+
+module Gitlab
+  module Database
+    module HealthStatus
+      module Indicators
+        class AutovacuumActiveOnTable
+          def initialize(context)
+            @tables = context.tables
+          end
+
+          def evaluate
+            return Signals::NotAvailable.new(self.class, reason: 'indicator disabled') unless enabled?
+
+            autovacuum_active_on = active_autovacuums_for(tables)
+
+            if autovacuum_active_on.empty?
+              Signals::Normal.new(self.class, reason: 'no autovacuum running on any relevant tables')
+            else
+              Signals::Stop.new(self.class, reason: "autovacuum running on: #{autovacuum_active_on.join(', ')}")
+            end
+          end
+
+          private
+
+          attr_reader :tables
+
+          def enabled?
+            Feature.enabled?(:batched_migrations_health_status_autovacuum, type: :ops)
+          end
+
+          def active_autovacuums_for(tables)
+            Gitlab::Database::PostgresAutovacuumActivity.for_tables(tables)
+          end
+        end
+      end
+    end
+  end
+end