Move cycle analytics calculations to SQL.

1. Use Arel for composable queries.
2. For a project with ~10k issues, the page loads in around 600ms.
   Previously, a project with ~5k issues would have a ~20s page load
   time.

1 files changed, 25 insertions, 0 deletions

diff --git a/app/models/cycle_analytics/table_references.rb b/app/models/cycle_analytics/table_references.rb
new file mode 100644
index 00000000000..f276723ee0e
--- /dev/null
+++ b/app/models/cycle_analytics/table_references.rb
@@ -0,0 +1,25 @@
+class CycleAnalytics
+  module TableReferences
+    class << self
+      def issues
+        Issue.arel_table
+      end
+
+      def issue_metrics
+        Issue::Metrics.arel_table
+      end
+
+      def merge_requests
+        MergeRequest.arel_table
+      end
+
+      def merge_request_metrics
+        MergeRequest::Metrics.arel_table
+      end
+
+      def merge_requests_closing_issues
+        MergeRequestsClosingIssues.arel_table
+      end
+    end
+  end
+end