From be99adb1498420be74d05d3e328632b24b5725a6 Mon Sep 17 00:00:00 2001
From: Thong Kuah <tkuah@gitlab.com>
Date: Fri, 14 Dec 2018 10:38:03 +1300
Subject: Show pg_stat_activity before each test run

Maybe this will help us debug
https://gitlab.com/gitlab-org/gitlab-ee/issues/10154
---
 spec/support/pg_stat_activity.rb | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 spec/support/pg_stat_activity.rb

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
-- 
cgit v1.2.1