Hi,

my foreman installation hosts about 1500 systems and is hosted on a rather powerful machine. Since updating to 1.17, building the host list is abysmally slow, like > 30 seconds for the first page of 100 hosts, while a ruby process is taking a complete core. The rest of the system including disk and database is idle in this situation.

The culprit was identified as the column_view plugin. Deinstalled it, and the first page of 100 hosts now displays in less than three seconds. We are of course now missing the additional columns generated by the plugin, which is a price to pay.

Here is our /etc/foreman/plugins/foreman_column_view.yaml:

:column_view:
  :architecture:
    :title: Architecture
    :after: last_report
    :content: facts_hash['architecture']
  :uptime:
    :title: Uptime
    :after: architecture
    :content: facts_hash['uptime']
  :token:
    :title:   Token
    :after:   owner
    :content: token
    :view:    :hosts_properties
  :owner:
    :title:   Owner
    :after:  model
    :content: owner

It would be nice if the column_view plugin could be adapted to reduce its performance impact.

Greetings
Marc