Description of problem:

Capsules page can take a minutes or more to load when the following conditions are met:

• Many Capsules. 10 or more.
• Many organizations (10 or more)  associated to the Capsules.
• Many locations (hundreds or more) associated to the Capsules.
• Each Capsules synced a few thousands of repositories (large content_counts field).

How reproducible:

When the above conditions are met

Is this issue a regression from an earlier version:

Could be. Since Capsule content_counts is introduced.

Business Impact / Additional info:

This is caused by the "eager_load" in the smart_proxies_controller.rb

  def resource_base
    super.eager_load(:locations, :organizations)
  end 

It generates a slow queries which returned many duplicate row that included the large json binary content_counts field which is appeared to be the performance bottleneck.