Merge branch 'check_pg_stat_activity' into 'master'

Show pg_stat_activity before each test run

See merge request gitlab-org/gitlab-ce!25723

1 files changed, 19 insertions, 0 deletions

diff --git a/spec/support/pg_stat_activity.rb b/spec/support/pg_stat_activity.rb
new file mode 100644
index 00000000000..f93fba08a19
--- /dev/null
+++ b/spec/support/pg_stat_activity.rb
@@ -0,0 +1,19 @@
+# frozen_string_literal: true
+
+RSpec.configure do |config|
+  config.before do
+    if Gitlab::Database.postgresql? && ENV['PG_STAT_WARNING_THRESHOLD']
+      warning_threshold = ENV['PG_STAT_WARNING_THRESHOLD'].to_i
+      results = ActiveRecord::Base.connection.execute('SELECT * FROM pg_stat_activity')
+      ntuples = results.ntuples
+
+      warn("pg_stat_activity count: #{ntuples}")
+
+      if ntuples > warning_threshold
+        results.each do |result|
+          warn result.inspect
+        end
+      end
+    end
+  end
+end