Created attachment 1025460 [details]
foreman-debug

Description of problem:
Opening the Products page takes about 3min for 22 Products,then scrolling takes another 3min

Version-Release number of selected component (if applicable):
Satellite 6

How reproducible:
Every time.

Steps to Reproduce:
Try to visit Product page with >=22 products

Actual results:
The products page loads very slowly.


Expected results:
It should be faster, this system has 4vCPU's and 16GB of RAM assigned.

Additional info:
number of database selects per tables (2nd column is table name, 1st is number of selects):

$ grep SELECT select | cut -d\" -f4 | sort | uniq -c | sort -n
      1 users
     95 katello_sync_plans
    107 katello_providers
    172 katello_task_statuses
    184 katello_products
    254 katello_content_views
   1683 katello_content_view_versions
   1691 taxonomies
   4346 katello_repositories
  34586 katello_environments
$

Various selects of katello_environments (sorting WHERE clauses):

$ sort katello_environments.txt | uniq -c | sort -n
..
    637  "katello_content_view_environments"."content_view_version_id" = 118
    637  "katello_content_view_environments"."content_view_version_id" = 57
..
    639  "katello_content_view_environments"."content_view_version_id" = 52
    639  "katello_content_view_environments"."content_view_version_id" = 53
$

Removing redundant content views / versions would speed up the listing.