{\rtf1\ansi\ansicpg1252\cocoartf1265
{\fonttbl\f0\fnil\fcharset0 Menlo-Regular;\f1\fnil\fcharset0 Menlo-Bold;}
{\colortbl;\red255\green255\blue255;\red46\green174\blue187;\red200\green20\blue201;}
\paperw11900\paperh16840\margl1440\margr1440\vieww25100\viewh14220\viewkind0
\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\pardirnatural

\f0\fs22 \cf0 \CocoaLigature0 # tail -f production.log\
Connecting to database specified by database.yml\
  
\f1\b \cf2 Setting Load (2.1ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3  (0.3ms)
\f0\b0 \cf0   BEGIN\
  
\f1\b \cf2 Setting Load (0.8ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'puppet_interval' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (1.0ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'puppet_interval' AND "settings"."id" != 1) LIMIT 1\
removing puppet_interval from cache\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'default_puppet_environment' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'default_puppet_environment' AND "settings"."id" != 2) LIMIT 1\
removing default_puppet_environment from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'modulepath' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'modulepath' AND "settings"."id" != 3) LIMIT 1\
removing modulepath from cache\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'document_root' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'document_root' AND "settings"."id" != 4) LIMIT 1\
removing document_root from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'puppetrun' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'puppetrun' AND "settings"."id" != 5) LIMIT 1\
removing puppetrun from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'puppet_server' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'puppet_server' AND "settings"."id" != 6) LIMIT 1\
removing puppet_server from cache\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'failed_report_email_notification' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'failed_report_email_notification' AND "settings"."id" != 7) LIMIT 1\
removing failed_report_email_notification from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'Default_variables_Lookup_Path' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'Default_variables_Lookup_Path' AND "settings"."id" != 9) LIMIT 1\
removing Default_variables_Lookup_Path from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'Enable_Smart_Variables_in_ENC' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.6ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'Enable_Smart_Variables_in_ENC' AND "settings"."id" != 10) LIMIT 1\
removing Enable_Smart_Variables_in_ENC from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'Parametrized_Classes_in_ENC' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'Parametrized_Classes_in_ENC' AND "settings"."id" != 11) LIMIT 1\
removing Parametrized_Classes_in_ENC from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'interpolate_erb_in_parameters' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'interpolate_erb_in_parameters' AND "settings"."id" != 48) LIMIT 1\
removing interpolate_erb_in_parameters from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'enc_environment' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'enc_environment' AND "settings"."id" != 12) LIMIT 1\
removing enc_environment from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_uuid_for_certificates' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'use_uuid_for_certificates' AND "settings"."id" != 13) LIMIT 1\
removing use_uuid_for_certificates from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'update_environment_from_facts' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.9ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'update_environment_from_facts' AND "settings"."id" != 14) LIMIT 1\
removing update_environment_from_facts from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'remove_classes_not_in_environment' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'remove_classes_not_in_environment' AND "settings"."id" != 15) LIMIT 1\
removing remove_classes_not_in_environment from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'host_group_matchers_inheritance' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'host_group_matchers_inheritance' AND "settings"."id" != 16) LIMIT 1\
removing host_group_matchers_inheritance from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'create_new_host_when_facts_are_uploaded' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'create_new_host_when_facts_are_uploaded' AND "settings"."id" != 49) LIMIT 1\
removing create_new_host_when_facts_are_uploaded from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'create_new_host_when_report_is_uploaded' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'create_new_host_when_report_is_uploaded' AND "settings"."id" != 53) LIMIT 1\
removing create_new_host_when_report_is_uploaded from cache\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'legacy_puppet_hostname' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'legacy_puppet_hostname' AND "settings"."id" != 50) LIMIT 1\
removing legacy_puppet_hostname from cache\
  
\f1\b \cf2  (0.2ms)
\f0\b0 \cf0   
\f1\b COMMIT
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" ORDER BY name LIMIT 1\
  
\f1\b \cf2  (0.1ms)
\f0\b0 \cf0   
\f1\b BEGIN
\f0\b0 \
  
\f1\b \cf3 Setting Load (2.0ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'administrator' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (1.7ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'administrator' AND "settings"."id" != 17) LIMIT 1
\f0\b0 \
removing administrator from cache\
  
\f1\b \cf3 Setting Load (1.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'foreman_url' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (1.3ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'foreman_url' AND "settings"."id" != 18) LIMIT 1
\f0\b0 \
removing foreman_url from cache\
  
\f1\b \cf3 Setting Load (1.1ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'email_reply_address' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (1.2ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'email_reply_address' AND "settings"."id" != 19) LIMIT 1
\f0\b0 \
removing email_reply_address from cache\
  
\f1\b \cf3 Setting Load (1.1ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'entries_per_page' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.9ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'entries_per_page' AND "settings"."id" != 20) LIMIT 1
\f0\b0 \
removing entries_per_page from cache\
  
\f1\b \cf3 Setting Load (0.9ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'authorize_login_delegation' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (1.4ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'authorize_login_delegation' AND "settings"."id" != 21) LIMIT 1
\f0\b0 \
removing authorize_login_delegation from cache\
  
\f1\b \cf3 Setting Load (1.0ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'authorize_login_delegation_api' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.9ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'authorize_login_delegation_api' AND "settings"."id" != 22) LIMIT 1
\f0\b0 \
removing authorize_login_delegation_api from cache\
  
\f1\b \cf3 Setting Load (0.8ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'idle_timeout' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'idle_timeout' AND "settings"."id" != 23) LIMIT 1
\f0\b0 \
removing idle_timeout from cache\
  
\f1\b \cf3 Setting Load (0.7ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'max_trend' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'max_trend' AND "settings"."id" != 24) LIMIT 1
\f0\b0 \
removing max_trend from cache\
  
\f1\b \cf3 Setting Load (0.6ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_gravatar' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'use_gravatar' AND "settings"."id" != 25) LIMIT 1
\f0\b0 \
removing use_gravatar from cache\
  
\f1\b \cf3  (0.4ms)
\f0\b0 \cf0   COMMIT\
  
\f1\b \cf2 Setting Load (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3  (0.2ms)
\f0\b0 \cf0   BEGIN\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'root_pass' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (1.1ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'root_pass' AND "settings"."id" != 26) LIMIT 1\
removing root_pass from cache\
  
\f1\b \cf2 Setting Load (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'unattended_url' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'unattended_url' AND "settings"."id" != 54) LIMIT 1\
removing unattended_url from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'safemode_render' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'safemode_render' AND "settings"."id" != 27) LIMIT 1\
removing safemode_render from cache\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_certificate' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'ssl_certificate' AND "settings"."id" != 28) LIMIT 1\
removing ssl_certificate from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_ca_file' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'ssl_ca_file' AND "settings"."id" != 29) LIMIT 1\
removing ssl_ca_file from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_priv_key' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'ssl_priv_key' AND "settings"."id" != 30) LIMIT 1\
removing ssl_priv_key from cache\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'manage_puppetca' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'manage_puppetca' AND "settings"."id" != 31) LIMIT 1\
removing manage_puppetca from cache\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ignore_puppet_facts_for_provisioning' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'ignore_puppet_facts_for_provisioning' AND "settings"."id" != 32) LIMIT 1\
removing ignore_puppet_facts_for_provisioning from cache\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'query_local_nameservers' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'query_local_nameservers' AND "settings"."id" != 33) LIMIT 1\
removing query_local_nameservers from cache\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'remote_addr' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.6ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'remote_addr' AND "settings"."id" != 34) LIMIT 1\
removing remote_addr from cache\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'token_duration' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.6ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'token_duration' AND "settings"."id" != 35) LIMIT 1\
removing token_duration from cache\
  
\f1\b \cf2 Setting Load (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'libvirt_default_console_address' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.6ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'libvirt_default_console_address' AND "settings"."id" != 36) LIMIT 1\
removing libvirt_default_console_address from cache\
  
\f1\b \cf2 Setting Load (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'update_ip_from_built_request' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.6ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'update_ip_from_built_request' AND "settings"."id" != 51) LIMIT 1\
removing update_ip_from_built_request from cache\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_shortname_for_vms' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.6ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'use_shortname_for_vms' AND "settings"."id" != 55) LIMIT 1\
removing use_shortname_for_vms from cache\
  
\f1\b \cf2  (0.2ms)
\f0\b0 \cf0   
\f1\b COMMIT
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.6ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" ORDER BY name LIMIT 1\
  
\f1\b \cf2  (0.2ms)
\f0\b0 \cf0   
\f1\b BEGIN
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.6ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'oauth_active' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'oauth_active' AND "settings"."id" != 37) LIMIT 1
\f0\b0 \
removing oauth_active from cache\
  
\f1\b \cf3 Setting Load (0.6ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'oauth_consumer_key' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'oauth_consumer_key' AND "settings"."id" != 38) LIMIT 1
\f0\b0 \
removing oauth_consumer_key from cache\
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'oauth_consumer_secret' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'oauth_consumer_secret' AND "settings"."id" != 39) LIMIT 1
\f0\b0 \
removing oauth_consumer_secret from cache\
  
\f1\b \cf3 Setting Load (0.6ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'oauth_map_users' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'oauth_map_users' AND "settings"."id" != 40) LIMIT 1
\f0\b0 \
removing oauth_map_users from cache\
  
\f1\b \cf3 Setting Load (0.6ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'restrict_registered_puppetmasters' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (15.0ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'restrict_registered_puppetmasters' AND "settings"."id" != 41) LIMIT 1
\f0\b0 \
removing restrict_registered_puppetmasters from cache\
  
\f1\b \cf3 Setting Load (0.6ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'require_ssl_puppetmasters' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'require_ssl_puppetmasters' AND "settings"."id" != 42) LIMIT 1
\f0\b0 \
removing require_ssl_puppetmasters from cache\
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'trusted_puppetmaster_hosts' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'trusted_puppetmaster_hosts' AND "settings"."id" != 43) LIMIT 1
\f0\b0 \
removing trusted_puppetmaster_hosts from cache\
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_client_dn_env' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'ssl_client_dn_env' AND "settings"."id" != 44) LIMIT 1
\f0\b0 \
removing ssl_client_dn_env from cache\
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_client_verify_env' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.3ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'ssl_client_verify_env' AND "settings"."id" != 45) LIMIT 1
\f0\b0 \
removing ssl_client_verify_env from cache\
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'signo_sso' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.3ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'signo_sso' AND "settings"."id" != 46) LIMIT 1
\f0\b0 \
removing signo_sso from cache\
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'signo_url' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.3ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'signo_url' AND "settings"."id" != 47) LIMIT 1
\f0\b0 \
removing signo_url from cache\
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'login_delegation_logout_url' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'login_delegation_logout_url' AND "settings"."id" != 52) LIMIT 1
\f0\b0 \
removing login_delegation_logout_url from cache\
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'authorize_login_delegation_auth_source_user_autocreate' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'authorize_login_delegation_auth_source_user_autocreate' AND "settings"."id" != 56) LIMIT 1
\f0\b0 \
removing authorize_login_delegation_auth_source_user_autocreate from cache\
  
\f1\b \cf3  (0.2ms)
\f0\b0 \cf0   COMMIT\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'entries_per_page' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3  (0.7ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" \
  
\f1\b \cf2  (0.1ms)
\f0\b0 \cf0   
\f1\b BEGIN
\f0\b0 \
  
\f1\b \cf3  (0.3ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Manager'\
  
\f1\b \cf2 Role Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Manager'
\f0\b0 \
  
\f1\b \cf3  (0.6ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Edit partition tables'\
  
\f1\b \cf2 Role Load (0.3ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Edit partition tables'
\f0\b0 \
  
\f1\b \cf3  (0.3ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'View hosts'\
  
\f1\b \cf2 Role Load (0.2ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'View hosts'
\f0\b0 \
  
\f1\b \cf3  (0.2ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Edit hosts'\
  
\f1\b \cf2 Role Load (0.2ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Edit hosts'
\f0\b0 \
  
\f1\b \cf3  (0.2ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Viewer'\
  
\f1\b \cf2 Role Load (0.2ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Viewer'
\f0\b0 \
  
\f1\b \cf3  (0.2ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Site manager'\
  
\f1\b \cf2 Role Load (0.2ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Site manager'
\f0\b0 \
  
\f1\b \cf3 Role Load (0.4ms)
\f0\b0 \cf0   SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = 1 LIMIT 1\
  
\f1\b \cf2 Role Load (0.2ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = 2 LIMIT 1
\f0\b0 \
  
\f1\b \cf3  (0.1ms)
\f0\b0 \cf0   COMMIT\
  
\f1\b \cf2 SQL (0.8ms)
\f0\b0 \cf0   
\f1\b SELECT "users"."id" FROM "users" 
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.3ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'email_reply_address' ORDER BY name LIMIT 1\
ENCRYPTION_KEY is not defined, so encryption is turned off for ComputeResource.\
  
\f1\b \cf2 Feature Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "features".* FROM "features" 
\f0\b0 \
  
\f1\b \cf3 TemplateKind Load (0.9ms)
\f0\b0 \cf0   SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'PXELinux')\
  
\f1\b \cf2 TemplateKind Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'PXEGrub')
\f0\b0 \
  
\f1\b \cf3 TemplateKind Load (0.4ms)
\f0\b0 \cf0   SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'iPXE')\
  
\f1\b \cf2 TemplateKind Load (0.3ms)
\f0\b0 \cf0   
\f1\b SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'provision')
\f0\b0 \
  
\f1\b \cf3 TemplateKind Load (0.3ms)
\f0\b0 \cf0   SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'finish')\
  
\f1\b \cf2 TemplateKind Load (2.6ms)
\f0\b0 \cf0   
\f1\b SELECT "template_kinds".* FROM "template_kinds" 
\f0\b0 \
Started PUT "/hosts/mysql-01.domain.local" for 172.16.24.25 at Tue Feb 04 15:33:02 +0100 2014\
Processing by HostsController#update as */*\
  Parameters: \{"capabilities"=>"build", "authenticity_token"=>"DJ4g025bIe/3U53QgvkdelUdJvqfPcRPb0v68Dox7Cs=", "utf8"=>"\uc0\u10003 ", "host"=>\{"ptable_id"=>"9", "lookup_values_attributes"=>"[FILTERED]", "comment"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"9", "progress_report_id"=>"[FILTERED]", "enabled"=>"1", "managed"=>"t", "interfaces_attributes"=>\{"new_interfaces"=>\{"_destroy"=>"false", "provider"=>"IPMI", "mac"=>"", "type"=>"Nic::Managed", "domain_id"=>"", "name"=>"", "ip"=>""\}\}, "is_owned_by"=>"1-Users", "operatingsystem_id"=>"1", "root_pass"=>"[FILTERED]", "hostgroup_id"=>"20", "mac"=>"00:1a:4a:a8:0c:9a", "puppetclass_ids"=>[""], "architecture_id"=>"1", "compute_attributes"=>\{"cluster"=>"cabb87e2-2113-445a-85b4-1827f33c96c1", "cores"=>"2", "volumes_attributes"=>\{"new_volumes"=>\{"storage_domain"=>"45fb22d8-e50b-4fb6-9a9c-6912e04906a3", "_delete"=>"", "size_gb"=>"", "id"=>""\}, "0"=>\{"storage_domain"=>"8f1b7c42-6231-4359-8145-674d30a9c6b3", "_delete"=>"", "size_gb"=>"25", "id"=>"eb8f785c-95c2-4944-b308-9d58df666dfd"\}\}, "interfaces_attributes"=>\{"new_interfaces"=>\{"network"=>"46a826d8-301d-4811-9dc4-aad12f1149ac", "_delete"=>"", "name"=>""\}, "0"=>\{"network"=>"f52fb80b-023b-4ae8-8302-8c4f4186f77f", "_delete"=>"", "name"=>"nic1", "id"=>"253851f7-47f4-41fc-b536-5a1ebc270ba7"\}\}, "memory"=>"2147483648", "template"=>"00000000-0000-0000-0000-000000000000"\}, "domain_id"=>"6", "provision_method"=>"build", "medium_id"=>"5", "disk"=>"", "name"=>"mysql-01", "puppet_proxy_id"=>"9", "subnet_id"=>"13", "overwrite"=>"false", "ip"=>"10.110.0.11"\}, "id"=>"mysql-01.domain.local"\}\
  
\f1\b \cf3 User Load (1.3ms)
\f0\b0 \cf0   SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]\
Setting current user thread-local variable to admin\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'authorize_login_delegation' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.7ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'idle_timeout' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Host::Base Load (3.2ms)
\f0\b0 \cf0   
\f1\b SELECT "hosts".* FROM "hosts" WHERE "hosts"."name" = 'mysql-01.domain.local' LIMIT 1
\f0\b0 \
Setting current organization thread-local variable to none\
Setting current location thread-local variable to none\
  
\f1\b \cf3  (0.2ms)
\f0\b0 \cf0   BEGIN\
  
\f1\b \cf2 User Load (1.0ms)
\f0\b0 \cf0   
\f1\b SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY firstname LIMIT 1
\f0\b0   [["id", 1]]\
  
\f1\b \cf3 Puppetclass Load (2.2ms)
\f0\b0 \cf0   SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "host_classes" ON "puppetclasses"."id" = "host_classes"."puppetclass_id" WHERE "host_classes"."host_id" = 147 ORDER BY puppetclasses.name\
  
\f1\b \cf2 LookupKey Load (1.4ms)
\f0\b0 \cf0   
\f1\b SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."id" = 742 ORDER BY lookup_keys.key LIMIT 1
\f0\b0 \
  
\f1\b \cf3 LookupValue Exists (1.0ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "lookup_values" WHERE ("lookup_values"."match" = 'fqdn=mysql-01' AND "lookup_values"."lookup_key_id" = 742) LIMIT 1\
  
\f1\b \cf2 Host::Managed Load (0.9ms)
\f0\b0 \cf0   
\f1\b SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."name" = 'mysql-01' LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Hostgroup Load (1.3ms)
\f0\b0 \cf0   SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 20 ORDER BY hostgroups.label LIMIT 1\
  
\f1\b \cf2 Environment Load (1.0ms)
\f0\b0 \cf0   
\f1\b SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Domain Load (1.0ms)
\f0\b0 \cf0   SELECT "domains".* FROM "domains" WHERE "domains"."id" = 6 ORDER BY domains.name LIMIT 1\
  
\f1\b \cf2 SmartProxy Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 9 ORDER BY smart_proxies.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 CACHE (0.0ms)
\f0\b0 \cf0   SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 9 ORDER BY smart_proxies.name LIMIT 1\
  
\f1\b \cf2 ComputeProfile Load (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT "compute_profiles".* FROM "compute_profiles" WHERE "compute_profiles"."id" = 4 ORDER BY compute_profiles.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Operatingsystem Load (1.0ms)
\f0\b0 \cf0   SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY operatingsystems.name LIMIT 1\
  
\f1\b \cf2 Architecture Load (1.1ms)
\f0\b0 \cf0   
\f1\b SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ComputeResource Load (1.3ms)
\f0\b0 \cf0   SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = 3 ORDER BY compute_resources.name LIMIT 1\
  
\f1\b \cf2 Medium Load (1.0ms)
\f0\b0 \cf0   
\f1\b SELECT "media".* FROM "media" WHERE "media"."id" = 5 ORDER BY media.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Ptable Load (0.9ms)
\f0\b0 \cf0   SELECT "ptables".* FROM "ptables" WHERE "ptables"."id" = 9 ORDER BY ptables.name LIMIT 1\
  
\f1\b \cf2 Subnet Load (1.1ms)
\f0\b0 \cf0   
\f1\b SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" = 13 ORDER BY vlanid LIMIT 1
\f0\b0 \
Connecting to database specified by database.yml\
  
\f1\b \cf3 LookupValue Load (0.8ms)
\f0\b0 \cf0   SELECT "lookup_values".* FROM "lookup_values" WHERE "lookup_values"."match" = 'fqdn=mysql-01.domain.local'\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_uuid_for_certificates' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Host::Base Exists (0.6ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "hosts" WHERE ("hosts"."name" = 'mysql-01.domain.local' AND "hosts"."id" != 147) LIMIT 1\
  
\f1\b \cf2 SmartProxy Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 7 ORDER BY smart_proxies.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'token_duration' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Host::Managed Exists (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND ("hosts"."ip" = '10.110.0.11' AND "hosts"."id" != 147) LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Hostgroup Load (1.1ms)
\f0\b0 \cf0   SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (9, 13) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry\
  
\f1\b \cf2 Hostgroup Load (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (9) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'root_pass' ORDER BY name LIMIT 1\
  
\f1\b \cf2 CACHE (0.0ms)
\f0\b0 \cf0   
\f1\b SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (9) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
\f0\b0 \
  
\f1\b \cf3 CACHE (0.0ms)
\f0\b0 \cf0   SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" = 13 ORDER BY vlanid LIMIT 1\
  
\f1\b \cf2 SmartProxy Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 10 ORDER BY smart_proxies.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_certificate' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_ca_file' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Load (6.2ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_priv_key' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'query_local_nameservers' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 CACHE (0.0ms)
\f0\b0 \cf0   SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 10 ORDER BY smart_proxies.name LIMIT 1\
  
\f1\b \cf2 CACHE (0.0ms)
\f0\b0 \cf0   
\f1\b SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 7 ORDER BY smart_proxies.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3  (0.3ms)
\f0\b0 \cf0   SHOW max_identifier_length\
  
\f1\b \cf2 Setting Load (2.2ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf2 ConfigTemplate Load (11.5ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" INNER JOIN "template_combinations" "template_combinations_config_templates_join" ON "template_combinations_config_templates_join"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations_config_templates_join"."environment_id" WHERE "template_kinds"."name" = 'PXELinux' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (2.4ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" WHERE "template_kinds"."name" = 'PXELinux' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (3.9ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "template_kinds"."name" = 'PXELinux' AND "operatingsystems"."id" = 1 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (3.0ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "template_kinds"."name" = 'PXELinux' AND "operatingsystems"."id" = 1 AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf3  (0.4ms)
\f0\b0 \cf0   BEGIN\
  
\f1\b \cf2 Setting Load (0.9ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'puppet_interval' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf2 CACHE (0.0ms)
\f0\b0 \cf0   
\f1\b SELECT "media".* FROM "media" WHERE "media"."id" = 5 ORDER BY media.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 CACHE (0.0ms)
\f0\b0 \cf0   SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1\
  
\f1\b \cf2 CACHE (0.0ms)
\f0\b0 \cf0   
\f1\b SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY operatingsystems.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.6ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'manage_puppetca' ORDER BY name LIMIT 1\
  
\f1\b \cf3 Setting Exists (0.9ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'puppet_interval' AND "settings"."id" != 1) LIMIT 1\
removing puppet_interval from cache\
  
\f1\b \cf2 Ptable Exists (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "ptables" INNER JOIN "operatingsystems_ptables" ON "ptables"."id" = "operatingsystems_ptables"."ptable_id" WHERE "operatingsystems_ptables"."operatingsystem_id" = 1 AND "ptables"."id" = 9 ORDER BY ptables.name LIMIT 1
\f0\b0 \
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'default_puppet_environment' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.6ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'default_puppet_environment' AND "settings"."id" != 2) LIMIT 1\
  
\f1\b \cf3 Medium Exists (0.6ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 1 AND "media"."id" = 5 ORDER BY media.name LIMIT 1\
removing default_puppet_environment from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'modulepath' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf2 Architecture Exists (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "architectures" INNER JOIN "architectures_operatingsystems" ON "architectures"."id" = "architectures_operatingsystems"."architecture_id" WHERE "architectures_operatingsystems"."operatingsystem_id" = 1 AND "architectures"."id" = 1 LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.6ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'modulepath' AND "settings"."id" != 3) LIMIT 1\
removing modulepath from cache\
  
\f1\b \cf3 Puppetclass Load (0.5ms)
\f0\b0 \cf0   SELECT DISTINCT puppetclasses.id,puppetclasses.name FROM "puppetclasses" INNER JOIN "host_classes" ON "puppetclasses"."id" = "host_classes"."puppetclass_id" WHERE "host_classes"."host_id" = 147 ORDER BY puppetclasses.name\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'document_root' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'document_root' AND "settings"."id" != 4) LIMIT 1\
removing document_root from cache\
  
\f1\b \cf2  (0.4ms)
\f0\b0 \cf0   
\f1\b COMMIT
\f0\b0 \
Redirected to https://fm-01.domain.local/hosts/mysql-01.domain.local\
Setting current location thread-local variable to none\
Setting current organization thread-local variable to none\
Completed 302 Found in 2333.7ms (ActiveRecord: 73.9ms)\
  
\f1\b \cf2 Setting Load (0.9ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'puppetrun' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.9ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'puppetrun' AND "settings"."id" != 5) LIMIT 1\
removing puppetrun from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'puppet_server' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'puppet_server' AND "settings"."id" != 6) LIMIT 1\
removing puppet_server from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'failed_report_email_notification' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'failed_report_email_notification' AND "settings"."id" != 7) LIMIT 1\
removing failed_report_email_notification from cache\
  
\f1\b \cf2 Setting Load (1.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'Default_variables_Lookup_Path' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.8ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'Default_variables_Lookup_Path' AND "settings"."id" != 9) LIMIT 1\
removing Default_variables_Lookup_Path from cache\
  
\f1\b \cf2 Setting Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'Enable_Smart_Variables_in_ENC' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'Enable_Smart_Variables_in_ENC' AND "settings"."id" != 10) LIMIT 1\
removing Enable_Smart_Variables_in_ENC from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'Parametrized_Classes_in_ENC' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'Parametrized_Classes_in_ENC' AND "settings"."id" != 11) LIMIT 1\
removing Parametrized_Classes_in_ENC from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'interpolate_erb_in_parameters' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'interpolate_erb_in_parameters' AND "settings"."id" != 48) LIMIT 1\
removing interpolate_erb_in_parameters from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'enc_environment' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'enc_environment' AND "settings"."id" != 12) LIMIT 1\
removing enc_environment from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_uuid_for_certificates' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'use_uuid_for_certificates' AND "settings"."id" != 13) LIMIT 1\
removing use_uuid_for_certificates from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'update_environment_from_facts' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'update_environment_from_facts' AND "settings"."id" != 14) LIMIT 1\
removing update_environment_from_facts from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'remove_classes_not_in_environment' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'remove_classes_not_in_environment' AND "settings"."id" != 15) LIMIT 1\
removing remove_classes_not_in_environment from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'host_group_matchers_inheritance' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'host_group_matchers_inheritance' AND "settings"."id" != 16) LIMIT 1\
removing host_group_matchers_inheritance from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'create_new_host_when_facts_are_uploaded' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'create_new_host_when_facts_are_uploaded' AND "settings"."id" != 49) LIMIT 1\
removing create_new_host_when_facts_are_uploaded from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'create_new_host_when_report_is_uploaded' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'create_new_host_when_report_is_uploaded' AND "settings"."id" != 53) LIMIT 1\
removing create_new_host_when_report_is_uploaded from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'legacy_puppet_hostname' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'legacy_puppet_hostname' AND "settings"."id" != 50) LIMIT 1\
removing legacy_puppet_hostname from cache\
  
\f1\b \cf2  (0.2ms)
\f0\b0 \cf0   
\f1\b COMMIT
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" ORDER BY name LIMIT 1\
  
\f1\b \cf2  (0.1ms)
\f0\b0 \cf0   
\f1\b BEGIN
\f0\b0 \
  
\f1\b \cf3 Setting Load (1.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'administrator' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (6.2ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'administrator' AND "settings"."id" != 17) LIMIT 1
\f0\b0 \
removing administrator from cache\
  
\f1\b \cf3 Setting Load (1.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'foreman_url' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (1.6ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'foreman_url' AND "settings"."id" != 18) LIMIT 1
\f0\b0 \
removing foreman_url from cache\
  
\f1\b \cf3 Setting Load (1.1ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'email_reply_address' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (1.1ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'email_reply_address' AND "settings"."id" != 19) LIMIT 1
\f0\b0 \
removing email_reply_address from cache\
  
\f1\b \cf3 Setting Load (1.2ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'entries_per_page' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.8ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'entries_per_page' AND "settings"."id" != 20) LIMIT 1
\f0\b0 \
removing entries_per_page from cache\
  
\f1\b \cf3 Setting Load (1.0ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'authorize_login_delegation' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (1.2ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'authorize_login_delegation' AND "settings"."id" != 21) LIMIT 1
\f0\b0 \
removing authorize_login_delegation from cache\
  
\f1\b \cf3 Setting Load (0.8ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'authorize_login_delegation_api' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (1.1ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'authorize_login_delegation_api' AND "settings"."id" != 22) LIMIT 1
\f0\b0 \
removing authorize_login_delegation_api from cache\
  
\f1\b \cf3 Setting Load (0.7ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'idle_timeout' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'idle_timeout' AND "settings"."id" != 23) LIMIT 1
\f0\b0 \
removing idle_timeout from cache\
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'max_trend' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'max_trend' AND "settings"."id" != 24) LIMIT 1
\f0\b0 \
removing max_trend from cache\
  
\f1\b \cf3 Setting Load (0.8ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_gravatar' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'use_gravatar' AND "settings"."id" != 25) LIMIT 1
\f0\b0 \
removing use_gravatar from cache\
  
\f1\b \cf3  (0.4ms)
\f0\b0 \cf0   COMMIT\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3  (0.1ms)
\f0\b0 \cf0   BEGIN\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'root_pass' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.7ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'root_pass' AND "settings"."id" != 26) LIMIT 1\
removing root_pass from cache\
  
\f1\b \cf2 Setting Load (0.8ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'unattended_url' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'unattended_url' AND "settings"."id" != 54) LIMIT 1\
removing unattended_url from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'safemode_render' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'safemode_render' AND "settings"."id" != 27) LIMIT 1\
removing safemode_render from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_certificate' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'ssl_certificate' AND "settings"."id" != 28) LIMIT 1\
removing ssl_certificate from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_ca_file' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.3ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'ssl_ca_file' AND "settings"."id" != 29) LIMIT 1\
removing ssl_ca_file from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_priv_key' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'ssl_priv_key' AND "settings"."id" != 30) LIMIT 1\
removing ssl_priv_key from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'manage_puppetca' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'manage_puppetca' AND "settings"."id" != 31) LIMIT 1\
removing manage_puppetca from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ignore_puppet_facts_for_provisioning' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'ignore_puppet_facts_for_provisioning' AND "settings"."id" != 32) LIMIT 1\
removing ignore_puppet_facts_for_provisioning from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'query_local_nameservers' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'query_local_nameservers' AND "settings"."id" != 33) LIMIT 1\
removing query_local_nameservers from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'remote_addr' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'remote_addr' AND "settings"."id" != 34) LIMIT 1\
removing remote_addr from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'token_duration' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'token_duration' AND "settings"."id" != 35) LIMIT 1\
removing token_duration from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'libvirt_default_console_address' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.5ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'libvirt_default_console_address' AND "settings"."id" != 36) LIMIT 1\
removing libvirt_default_console_address from cache\
  
\f1\b \cf2 Setting Load (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'update_ip_from_built_request' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'update_ip_from_built_request' AND "settings"."id" != 51) LIMIT 1\
removing update_ip_from_built_request from cache\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_shortname_for_vms' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Exists (0.4ms)
\f0\b0 \cf0   SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'use_shortname_for_vms' AND "settings"."id" != 55) LIMIT 1\
removing use_shortname_for_vms from cache\
  
\f1\b \cf2  (0.2ms)
\f0\b0 \cf0   
\f1\b COMMIT
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" ORDER BY name LIMIT 1\
  
\f1\b \cf2  (0.2ms)
\f0\b0 \cf0   
\f1\b BEGIN
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'oauth_active' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'oauth_active' AND "settings"."id" != 37) LIMIT 1
\f0\b0 \
removing oauth_active from cache\
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'oauth_consumer_key' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'oauth_consumer_key' AND "settings"."id" != 38) LIMIT 1
\f0\b0 \
removing oauth_consumer_key from cache\
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'oauth_consumer_secret' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.3ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'oauth_consumer_secret' AND "settings"."id" != 39) LIMIT 1
\f0\b0 \
removing oauth_consumer_secret from cache\
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'oauth_map_users' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'oauth_map_users' AND "settings"."id" != 40) LIMIT 1
\f0\b0 \
removing oauth_map_users from cache\
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'restrict_registered_puppetmasters' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (15.1ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'restrict_registered_puppetmasters' AND "settings"."id" != 41) LIMIT 1
\f0\b0 \
removing restrict_registered_puppetmasters from cache\
  
\f1\b \cf3 Setting Load (0.5ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'require_ssl_puppetmasters' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'require_ssl_puppetmasters' AND "settings"."id" != 42) LIMIT 1
\f0\b0 \
removing require_ssl_puppetmasters from cache\
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'trusted_puppetmaster_hosts' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'trusted_puppetmaster_hosts' AND "settings"."id" != 43) LIMIT 1
\f0\b0 \
removing trusted_puppetmaster_hosts from cache\
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_client_dn_env' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.9ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'ssl_client_dn_env' AND "settings"."id" != 44) LIMIT 1
\f0\b0 \
removing ssl_client_dn_env from cache\
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_client_verify_env' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.3ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'ssl_client_verify_env' AND "settings"."id" != 45) LIMIT 1
\f0\b0 \
removing ssl_client_verify_env from cache\
  
\f1\b \cf3 Setting Load (0.3ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'signo_sso' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'signo_sso' AND "settings"."id" != 46) LIMIT 1
\f0\b0 \
removing signo_sso from cache\
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'signo_url' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.3ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'signo_url' AND "settings"."id" != 47) LIMIT 1
\f0\b0 \
removing signo_url from cache\
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'login_delegation_logout_url' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.3ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'login_delegation_logout_url' AND "settings"."id" != 52) LIMIT 1
\f0\b0 \
removing login_delegation_logout_url from cache\
  
\f1\b \cf3 Setting Load (0.4ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'authorize_login_delegation_auth_source_user_autocreate' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Setting Exists (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT 1 AS one FROM "settings" WHERE ("settings"."name" = 'authorize_login_delegation_auth_source_user_autocreate' AND "settings"."id" != 56) LIMIT 1
\f0\b0 \
removing authorize_login_delegation_auth_source_user_autocreate from cache\
  
\f1\b \cf3  (0.1ms)
\f0\b0 \cf0   COMMIT\
  
\f1\b \cf2 Setting Load (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'entries_per_page' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3  (0.8ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" \
  
\f1\b \cf2  (0.1ms)
\f0\b0 \cf0   
\f1\b BEGIN
\f0\b0 \
  
\f1\b \cf3  (0.4ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Manager'\
  
\f1\b \cf2 Role Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Manager'
\f0\b0 \
  
\f1\b \cf3  (0.5ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Edit partition tables'\
  
\f1\b \cf2 Role Load (0.2ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Edit partition tables'
\f0\b0 \
  
\f1\b \cf3  (0.3ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'View hosts'\
  
\f1\b \cf2 Role Load (0.2ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'View hosts'
\f0\b0 \
  
\f1\b \cf3  (0.3ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Edit hosts'\
  
\f1\b \cf2 Role Load (0.2ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Edit hosts'
\f0\b0 \
  
\f1\b \cf3  (0.2ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Viewer'\
  
\f1\b \cf2 Role Load (0.2ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Viewer'
\f0\b0 \
  
\f1\b \cf3  (0.2ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Site manager'\
  
\f1\b \cf2 Role Load (0.2ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Site manager'
\f0\b0 \
  
\f1\b \cf3 Role Load (0.4ms)
\f0\b0 \cf0   SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = 1 LIMIT 1\
  
\f1\b \cf2 Role Load (0.2ms)
\f0\b0 \cf0   
\f1\b SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = 2 LIMIT 1
\f0\b0 \
  
\f1\b \cf3  (0.1ms)
\f0\b0 \cf0   COMMIT\
  
\f1\b \cf2 SQL (0.8ms)
\f0\b0 \cf0   
\f1\b SELECT "users"."id" FROM "users" 
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.3ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'email_reply_address' ORDER BY name LIMIT 1\
ENCRYPTION_KEY is not defined, so encryption is turned off for ComputeResource.\
  
\f1\b \cf2 Feature Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "features".* FROM "features" 
\f0\b0 \
  
\f1\b \cf3 TemplateKind Load (0.9ms)
\f0\b0 \cf0   SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'PXELinux')\
  
\f1\b \cf2 TemplateKind Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'PXEGrub')
\f0\b0 \
  
\f1\b \cf3 TemplateKind Load (0.3ms)
\f0\b0 \cf0   SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'iPXE')\
  
\f1\b \cf2 TemplateKind Load (0.3ms)
\f0\b0 \cf0   
\f1\b SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'provision')
\f0\b0 \
  
\f1\b \cf3 TemplateKind Load (0.3ms)
\f0\b0 \cf0   SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'finish')\
  
\f1\b \cf2 TemplateKind Load (2.5ms)
\f0\b0 \cf0   
\f1\b SELECT "template_kinds".* FROM "template_kinds" 
\f0\b0 \
Started GET "/hosts/mysql-01.domain.local" for 172.16.24.25 at Tue Feb 04 15:33:18 +0100 2014\
Started GET "/tasks/4b7730be-1efa-42ea-80e5-bf6db3e272e4" for 172.16.24.25 at Tue Feb 04 15:33:18 +0100 2014\
Processing by HostsController#show as */*\
  Parameters: \{"id"=>"mysql-01.domain.local"\}\
  
\f1\b \cf3 User Load (1.0ms)
\f0\b0 \cf0   SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]\
Setting current user thread-local variable to admin\
  
\f1\b \cf2 Setting Load (0.8ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'authorize_login_delegation' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.6ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'idle_timeout' ORDER BY name LIMIT 1\
  
\f1\b \cf2 Host::Base Load (0.9ms)
\f0\b0 \cf0   
\f1\b SELECT "hosts".* FROM "hosts" WHERE "hosts"."name" = 'mysql-01.domain.local' LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Report Load (3.3ms)
\f0\b0 \cf0   SELECT status FROM "reports" WHERE "reports"."host_id" = 147 AND (reported_at > '2014-01-28 14:33:18.823671') ORDER BY reported_at\
  
\f1\b \cf2 Operatingsystem Load (0.9ms)
\f0\b0 \cf0   
\f1\b SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY operatingsystems.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ComputeResource Load (0.8ms)
\f0\b0 \cf0   SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = 3 ORDER BY compute_resources.name LIMIT 1\
  
\f1\b \cf2 SmartProxy Load (1.1ms)
\f0\b0 \cf0   
\f1\b SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 9 ORDER BY smart_proxies.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Setting Load (0.7ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'puppetrun' ORDER BY name LIMIT 1\
  
\f1\b \cf2  (0.9ms)
\f0\b0 \cf0   
\f1\b SELECT COUNT(*) FROM "reports" WHERE "reports"."host_id" = 147
\f0\b0 \
  
\f1\b \cf3 Report Load (1.0ms)
\f0\b0 \cf0   SELECT "reports".* FROM "reports" WHERE "reports"."host_id" = 147 LIMIT 1\
  
\f1\b \cf2  (1.1ms)
\f0\b0 \cf0   
\f1\b SELECT COUNT(*) FROM "reports" WHERE "reports"."host_id" = 147 AND (reported_at > '2014-01-28 14:33:19.359305')
\f0\b0 \
  
\f1\b \cf3 Nic::Base Load (0.9ms)
\f0\b0 \cf0   SELECT "nics".* FROM "nics" WHERE "nics"."host_id" = 147 AND "nics"."type" = 'Nic::BMC' LIMIT 1\
  
\f1\b \cf2  (1.4ms)
\f0\b0 \cf0   
\f1\b SELECT COUNT(*) FROM "fact_values" WHERE "fact_values"."host_id" = 147
\f0\b0 \
  
\f1\b \cf3 CACHE (0.0ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "reports" WHERE "reports"."host_id" = 147\
  
\f1\b \cf2  (1.2ms)
\f0\b0 \cf0   
\f1\b SELECT COUNT(*) FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" = 'Puppet'
\f0\b0 \
  
\f1\b \cf3 Domain Load (0.6ms)
\f0\b0 \cf0   SELECT "domains".* FROM "domains" WHERE "domains"."id" = 6 ORDER BY domains.name LIMIT 1\
  
\f1\b \cf2 Environment Load (1.1ms)
\f0\b0 \cf0   
\f1\b SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Architecture Load (0.5ms)
\f0\b0 \cf0   SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1\
  
\f1\b \cf2 Hostgroup Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 20 ORDER BY hostgroups.label LIMIT 1
\f0\b0 \
  
\f1\b \cf3 User Load (1.1ms)
\f0\b0 \cf0   SELECT "users".* FROM "users" WHERE "users"."id" = 1 ORDER BY firstname LIMIT 1\
  
\f1\b \cf2 Setting Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_uuid_for_certificates' ORDER BY name LIMIT 1
\f0\b0 \
  Rendered hosts/_overview.html.erb (364.0ms)\
  Rendered hosts/_metrics.html.erb (1.8ms)\
  
\f1\b \cf3 TemplateKind Load (0.7ms)
\f0\b0 \cf0   SELECT "template_kinds".* FROM "template_kinds" ORDER BY name\
  
\f1\b \cf2 ConfigTemplate Load (11.6ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" INNER JOIN "template_combinations" "template_combinations_config_templates_join" ON "template_combinations_config_templates_join"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations_config_templates_join"."environment_id" WHERE "template_kinds"."name" = 'PXEGrub' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (12.5ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" WHERE "template_kinds"."name" = 'PXEGrub' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (2.7ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "template_kinds"."name" = 'PXEGrub' AND "operatingsystems"."id" = 1 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (1.5ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "template_kinds"."name" = 'PXEGrub' AND "operatingsystems"."id" = 1 AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (9.1ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" INNER JOIN "template_combinations" "template_combinations_config_templates_join" ON "template_combinations_config_templates_join"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations_config_templates_join"."environment_id" WHERE "template_kinds"."name" = 'PXELinux' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (1.8ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" WHERE "template_kinds"."name" = 'PXELinux' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (2.1ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "template_kinds"."name" = 'PXELinux' AND "operatingsystems"."id" = 1 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (1.8ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "template_kinds"."name" = 'PXELinux' AND "operatingsystems"."id" = 1 AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (9.8ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" INNER JOIN "template_combinations" "template_combinations_config_templates_join" ON "template_combinations_config_templates_join"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations_config_templates_join"."environment_id" WHERE "template_kinds"."name" = 'ZTP' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (1.8ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" WHERE "template_kinds"."name" = 'ZTP' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (2.5ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "template_kinds"."name" = 'ZTP' AND "operatingsystems"."id" = 1 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (1.4ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "template_kinds"."name" = 'ZTP' AND "operatingsystems"."id" = 1 AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (9.1ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" INNER JOIN "template_combinations" "template_combinations_config_templates_join" ON "template_combinations_config_templates_join"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations_config_templates_join"."environment_id" WHERE "template_kinds"."name" = 'finish' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (1.7ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" WHERE "template_kinds"."name" = 'finish' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (2.1ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "template_kinds"."name" = 'finish' AND "operatingsystems"."id" = 1 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (1.4ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "template_kinds"."name" = 'finish' AND "operatingsystems"."id" = 1 AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (8.7ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" INNER JOIN "template_combinations" "template_combinations_config_templates_join" ON "template_combinations_config_templates_join"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations_config_templates_join"."environment_id" WHERE "template_kinds"."name" = 'iPXE' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (2.0ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" WHERE "template_kinds"."name" = 'iPXE' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (2.0ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "template_kinds"."name" = 'iPXE' AND "operatingsystems"."id" = 1 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (1.6ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "template_kinds"."name" = 'iPXE' AND "operatingsystems"."id" = 1 AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (10.2ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" INNER JOIN "template_combinations" "template_combinations_config_templates_join" ON "template_combinations_config_templates_join"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations_config_templates_join"."environment_id" WHERE "template_kinds"."name" = 'provision' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (3.1ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" WHERE "template_kinds"."name" = 'provision' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (3.1ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "template_kinds"."name" = 'provision' AND "operatingsystems"."id" = 1 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (3.4ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "template_kinds"."name" = 'provision' AND "operatingsystems"."id" = 1 AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (12.9ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" INNER JOIN "template_combinations" "template_combinations_config_templates_join" ON "template_combinations_config_templates_join"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations_config_templates_join"."environment_id" WHERE "template_kinds"."name" = 'script' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (2.5ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" WHERE "template_kinds"."name" = 'script' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (3.1ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "template_kinds"."name" = 'script' AND "operatingsystems"."id" = 1 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (1.8ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "template_kinds"."name" = 'script' AND "operatingsystems"."id" = 1 AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (12.8ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" INNER JOIN "template_combinations" "template_combinations_config_templates_join" ON "template_combinations_config_templates_join"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations_config_templates_join"."environment_id" WHERE "template_kinds"."name" = 'user_data' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (2.4ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "template_combinations"."hostgroup_id" WHERE "template_kinds"."name" = 'user_data' AND "operatingsystems"."id" = 1 AND "hostgroups"."id" = 20 ORDER BY config_templates.name LIMIT 1\
  
\f1\b \cf2 ConfigTemplate Load (2.7ms)
\f0\b0 \cf0   
\f1\b SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "template_kinds"."name" = 'user_data' AND "operatingsystems"."id" = 1 AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 ConfigTemplate Load (1.9ms)
\f0\b0 \cf0   SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "template_kinds"."name" = 'user_data' AND "operatingsystems"."id" = 1 AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1\
Processing by TasksController#show as */*\
  Parameters: \{"id"=>"4b7730be-1efa-42ea-80e5-bf6db3e272e4"\}\
  
\f1\b \cf3 User Load (1.4ms)
\f0\b0 \cf0   SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]\
Setting current user thread-local variable to admin\
  Rendered tasks/_list.html.erb (2.6ms)\
Completed 200 OK in 23.7ms (Views: 13.7ms | ActiveRecord: 3.2ms)\
  Rendered compute_resources_vms/show/_ovirt.html.erb (524.2ms)\
  
\f1\b \cf2 CACHE (0.0ms)
\f0\b0 \cf0   
\f1\b SELECT "nics".* FROM "nics" WHERE "nics"."host_id" = 147 AND "nics"."type" = 'Nic::BMC' LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Report Load (3.0ms)
\f0\b0 \cf0   SELECT "reports".* FROM "reports" WHERE "reports"."host_id" = 147 AND (reported_at > '2014-01-28 14:33:20.590993') ORDER BY reported_at\
  
\f1\b \cf2 Report Load (2.7ms)
\f0\b0 \cf0   
\f1\b SELECT "reports".* FROM "reports" WHERE "reports"."host_id" = 147 AND (reported_at > '2014-01-28 14:33:20.989049') ORDER BY reported_at
\f0\b0 \
  Rendered hosts/show.html.erb within layouts/application (1842.7ms)\
  
\f1\b \cf3 Setting Load (0.7ms)
\f0\b0 \cf0   SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_gravatar' ORDER BY name LIMIT 1\
  Rendered home/_user_dropdown.html.erb (10.5ms)\
Read fragment views/tabs_and_title_records-1 0.2ms\
  Rendered home/_org_switcher.html.erb (1.2ms)\
  Rendered home/_submenu.html.erb (6.9ms)\
  Rendered home/_submenu.html.erb (251.2ms)\
  Rendered home/_submenu.html.erb (5.7ms)\
  Rendered home/_submenu.html.erb (4.2ms)\
  Rendered home/_submenu.html.erb (5.5ms)\
Write fragment views/tabs_and_title_records-1 1.7ms\
  Rendered home/_topbar.html.erb (300.8ms)\
  Rendered layouts/base.html.erb (305.9ms)\
Completed 200 OK in 2558.3ms (Views: 1993.3ms | ActiveRecord: 179.9ms)\
Started GET "/hosts/mysql-01.domain.local/edit" for 172.16.24.25 at Tue Feb 04 15:33:21 +0100 2014\
Processing by HostsController#edit as */*\
  Parameters: \{"id"=>"mysql-01.domain.local"\}\
  
\f1\b \cf2 User Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1
\f0\b0   [["id", 1]]\
Setting current user thread-local variable to admin\
  
\f1\b \cf3 Host::Base Load (1.2ms)
\f0\b0 \cf0   SELECT "hosts".* FROM "hosts" WHERE "hosts"."name" = 'mysql-01.domain.local' LIMIT 1\
  
\f1\b \cf2 Environment Load (2.0ms)
\f0\b0 \cf0   
\f1\b SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Architecture Load (0.8ms)
\f0\b0 \cf0   SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1\
  
\f1\b \cf2 Domain Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "domains".* FROM "domains" WHERE "domains"."id" = 6 ORDER BY domains.name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 Operatingsystem Load (0.7ms)
\f0\b0 \cf0   SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY operatingsystems.name LIMIT 1\
  
\f1\b \cf2 Medium Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "media".* FROM "media" WHERE "media"."id" = 5 ORDER BY media.name LIMIT 1
\f0\b0 \
  Rendered hosts/_progress.html.erb (1.8ms)\
Setting current organization thread-local variable to none\
Setting current location thread-local variable to none\
  
\f1\b \cf3  (0.9ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" = 'Puppet'\
  
\f1\b \cf2  (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT COUNT(*) FROM "hostgroups" INNER JOIN "user_hostgroups" ON "hostgroups"."id" = "user_hostgroups"."hostgroup_id" WHERE "user_hostgroups"."user_id" = 1
\f0\b0 \
  
\f1\b \cf3 Hostgroup Load (0.8ms)
\f0\b0 \cf0   SELECT "hostgroups".* FROM "hostgroups" ORDER BY hostgroups.label\
  
\f1\b \cf2 ComputeResource Load (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT "compute_resources".* FROM "compute_resources" ORDER BY type, name
\f0\b0 \
  
\f1\b \cf3 Environment Load (0.4ms)
\f0\b0 \cf0   SELECT "environments".* FROM "environments" ORDER BY environments.name\
  
\f1\b \cf2  (0.8ms)
\f0\b0 \cf0   
\f1\b SELECT COUNT(*) FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" = 'Puppet CA'
\f0\b0 \
  
\f1\b \cf3 SmartProxy Load (0.7ms)
\f0\b0 \cf0   SELECT "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" = 'Puppet CA' ORDER BY smart_proxies.name\
  
\f1\b \cf2 CACHE (0.0ms)
\f0\b0 \cf0   
\f1\b SELECT COUNT(*) FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" = 'Puppet'
\f0\b0 \
  
\f1\b \cf3 SmartProxy Load (1.0ms)
\f0\b0 \cf0   SELECT "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" = 'Puppet' ORDER BY smart_proxies.name\
  
\f1\b \cf2 Puppetclass Load (0.8ms)
\f0\b0 \cf0   
\f1\b SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "host_classes" ON "puppetclasses"."id" = "host_classes"."puppetclass_id" WHERE "host_classes"."host_id" = 147 ORDER BY puppetclasses.name
\f0\b0 \
  Rendered puppetclasses/_selectedClasses.html.erb (0.0ms)\
  
\f1\b \cf3 Hostgroup Load (0.6ms)
\f0\b0 \cf0   SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 20 ORDER BY hostgroups.label LIMIT 1\
  
\f1\b \cf2 Puppetclass Load (1.3ms)
\f0\b0 \cf0   
\f1\b SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "hostgroup_classes" ON "hostgroup_classes"."puppetclass_id" = "puppetclasses"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "hostgroup_classes"."hostgroup_id" WHERE "hostgroups"."id" IN (9, 13, 20) ORDER BY puppetclasses.name
\f0\b0 \
  
\f1\b \cf3 CACHE (0.0ms)
\f0\b0 \cf0   SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "hostgroup_classes" ON "hostgroup_classes"."puppetclass_id" = "puppetclasses"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "hostgroup_classes"."hostgroup_id" WHERE "hostgroups"."id" IN (9, 13, 20) ORDER BY puppetclasses.name\
  
\f1\b \cf2 Puppetclass Load (2.1ms)
\f0\b0 \cf0   
\f1\b SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 1 ORDER BY puppetclasses.name
\f0\b0 \
  Rendered puppetclasses/_classes.html.erb (1233.7ms)\
  Rendered puppetclasses/_class_selection.html.erb (1526.4ms)\
  
\f1\b \cf3 ComputeResource Load (0.7ms)
\f0\b0 \cf0   SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = 3 ORDER BY compute_resources.name LIMIT 1\
  Rendered compute_resources_vms/form/ovirt/_network.html.erb (434.4ms)\
  Rendered compute_resources_vms/form/ovirt/_network.html.erb (445.5ms)\
  Rendered compute_resources_vms/form/ovirt/_volume.html.erb (386.6ms)\
  Rendered compute_resources_vms/form/ovirt/_volume.html.erb (414.5ms)\
  Rendered compute_resources_vms/form/_ovirt.html.erb (2781.3ms)\
  Rendered hosts/_compute.html.erb (3137.7ms)\
  
\f1\b \cf2 Domain Load (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT "domains".* FROM "domains" INNER JOIN "user_domains" ON "domains"."id" = "user_domains"."domain_id" WHERE "user_domains"."user_id" = 1 ORDER BY domains.name
\f0\b0 \
  
\f1\b \cf3 Domain Load (0.9ms)
\f0\b0 \cf0   SELECT "domains".* FROM "domains" ORDER BY domains.name\
  
\f1\b \cf2  (0.9ms)
\f0\b0 \cf0   
\f1\b SELECT COUNT(*) FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 6
\f0\b0 \
  
\f1\b \cf3 CACHE (0.0ms)
\f0\b0 \cf0   SELECT COUNT(*) FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 6\
  
\f1\b \cf2 Subnet Load (0.9ms)
\f0\b0 \cf0   
\f1\b SELECT "subnets".* FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 6 ORDER BY vlanid
\f0\b0 \
  Rendered common/_domain.html.erb (26.0ms)\
  
\f1\b \cf3 Nic::Base Load (0.6ms)
\f0\b0 \cf0   SELECT "nics".* FROM "nics" WHERE "nics"."host_id" = 147\
  
\f1\b \cf2 CACHE (0.0ms)
\f0\b0 \cf0   
\f1\b SELECT "domains".* FROM "domains" ORDER BY domains.name
\f0\b0 \
  
\f1\b \cf3 CACHE (0.0ms)
\f0\b0 \cf0   SELECT "domains".* FROM "domains" ORDER BY domains.name\
  
\f1\b \cf2 CACHE (0.0ms)
\f0\b0 \cf0   
\f1\b SELECT "domains".* FROM "domains" ORDER BY domains.name
\f0\b0 \
  Rendered hosts/_interfaces.html.erb (26.7ms)\
  
\f1\b \cf3 Architecture Load (9.6ms)
\f0\b0 \cf0   SELECT "architectures".* FROM "architectures" \
  
\f1\b \cf2 Operatingsystem Load (0.8ms)
\f0\b0 \cf0   
\f1\b SELECT "operatingsystems".* FROM "operatingsystems" INNER JOIN "architectures_operatingsystems" ON "operatingsystems"."id" = "architectures_operatingsystems"."operatingsystem_id" WHERE "architectures_operatingsystems"."architecture_id" = 1 ORDER BY operatingsystems.name
\f0\b0 \
  Rendered common/os_selection/_architecture.html.erb (265.5ms)\
  
\f1\b \cf3 Medium Load (0.8ms)
\f0\b0 \cf0   SELECT "media".* FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 1 ORDER BY media.name\
  
\f1\b \cf2 Ptable Load (0.7ms)
\f0\b0 \cf0   
\f1\b SELECT "ptables".* FROM "ptables" INNER JOIN "operatingsystems_ptables" ON "ptables"."id" = "operatingsystems_ptables"."ptable_id" WHERE "operatingsystems_ptables"."operatingsystem_id" = 1 ORDER BY ptables.name
\f0\b0 \
  Rendered common/os_selection/_operatingsystem.html.erb (16.4ms)\
  Rendered hosts/_operating_system.html.erb (543.0ms)\
  Rendered hosts/_unattended.html.erb (4059.2ms)\
  
\f1\b \cf3 CACHE (0.0ms)
\f0\b0 \cf0   SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "hostgroup_classes" ON "hostgroup_classes"."puppetclass_id" = "puppetclasses"."id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "hostgroup_classes"."hostgroup_id" WHERE "hostgroups"."id" IN (9, 13, 20) ORDER BY puppetclasses.name\
  
\f1\b \cf2  (0.8ms)
\f0\b0 \cf0   
\f1\b SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (181, 179, 173, 169, 175, 182, 183, 168, 172, 178, 176) GROUP BY puppetclass_id
\f0\b0 \
  
\f1\b \cf3  (1.4ms)
\f0\b0 \cf0   SELECT COUNT(*) AS count_all, environment_classes.puppetclass_id AS environment_classes_puppetclass_id FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."lookup_key_id" = "lookup_keys"."id" WHERE "environment_classes"."puppetclass_id" IN (181, 179, 173, 169, 175, 182, 183, 168, 172, 178, 176) GROUP BY environment_classes.puppetclass_id\
  
\f1\b \cf2 LookupKey Load (1.6ms)
\f0\b0 \cf0   
\f1\b SELECT DISTINCT "lookup_keys".* FROM "lookup_keys" INNER JOIN "environment_classes" ON "lookup_keys"."id" = "environment_classes"."lookup_key_id" WHERE "environment_classes"."puppetclass_id" = 169 AND "lookup_keys"."override" = 't' AND "environment_classes"."environment_id" = 1 AND (environment_classes.lookup_key_id is NOT NULL) ORDER BY lookup_keys.key
\f0\b0 \
  
\f1\b \cf3 LookupKey Load (0.7ms)
\f0\b0 \cf0   SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" = 169 ORDER BY lookup_keys.key\
  
\f1\b \cf2 SQL (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "host_classes"."puppetclass_id" FROM "host_classes" WHERE "host_classes"."host_id" = 147
\f0\b0 \
  
\f1\b \cf3 SQL (0.4ms)
\f0\b0 \cf0   SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (9, 13, 20)\
  
\f1\b \cf2 Setting Load (1.3ms)
\f0\b0 \cf0   
\f1\b SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'remove_classes_not_in_environment' ORDER BY name LIMIT 1
\f0\b0 \
  
\f1\b \cf3 SQL (1.5ms)
\f0\b0 \cf0   SELECT "lookup_keys"."id" AS t0_r0, "lookup_keys"."key" AS t0_r1, "lookup_keys"."created_at" AS t0_r2, "lookup_keys"."updated_at" AS t0_r3, "lookup_keys"."puppetclass_id" AS t0_r4, "lookup_keys"."default_value" AS t0_r5, "lookup_keys"."path" AS t0_r6, "lookup_keys"."description" AS t0_r7, "lookup_keys"."validator_type" AS t0_r8, "lookup_keys"."validator_rule" AS t0_r9, "lookup_keys"."is_param" AS t0_r10, "lookup_keys"."key_type" AS t0_r11, "lookup_keys"."override" AS t0_r12, "lookup_keys"."required" AS t0_r13, "lookup_keys"."lookup_values_count" AS t0_r14, "environment_classes"."id" AS t1_r0, "environment_classes"."puppetclass_id" AS t1_r1, "environment_classes"."environment_id" AS t1_r2, "environment_classes"."lookup_key_id" AS t1_r3 FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."override" = 't' AND "environment_classes"."environment_id" = 1 AND "environment_classes"."puppetclass_id" IN (181, 179, 173, 169, 175, 182, 183, 168, 172, 178, 176) ORDER BY lookup_keys.key\
  
\f1\b \cf2 LookupKey Load (1.4ms)
\f0\b0 \cf0   
\f1\b SELECT DISTINCT "lookup_keys".* FROM "lookup_keys" INNER JOIN "environment_classes" ON "lookup_keys"."id" = "environment_classes"."lookup_key_id" WHERE "environment_classes"."puppetclass_id" = 182 AND "lookup_keys"."override" = 't' AND "environment_classes"."environment_id" = 1 AND (environment_classes.lookup_key_id is NOT NULL) ORDER BY lookup_keys.key
\f0\b0 \
  
\f1\b \cf3 LookupKey Load (0.6ms)
\f0\b0 \cf0   SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" = 182 ORDER BY lookup_keys.key\
  
\f1\b \cf2 SQL (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "host_classes"."puppetclass_id" FROM "host_classes" WHERE "host_classes"."host_id" = 147
\f0\b0 \
  
\f1\b \cf3 SQL (0.5ms)
\f0\b0 \cf0   SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (9, 13, 20)\
  
\f1\b \cf2 CACHE (0.0ms)
\f0\b0 \cf0   
\f1\b SELECT "lookup_keys"."id" AS t0_r0, "lookup_keys"."key" AS t0_r1, "lookup_keys"."created_at" AS t0_r2, "lookup_keys"."updated_at" AS t0_r3, "lookup_keys"."puppetclass_id" AS t0_r4, "lookup_keys"."default_value" AS t0_r5, "lookup_keys"."path" AS t0_r6, "lookup_keys"."description" AS t0_r7, "lookup_keys"."validator_type" AS t0_r8, "lookup_keys"."validator_rule" AS t0_r9, "lookup_keys"."is_param" AS t0_r10, "lookup_keys"."key_type" AS t0_r11, "lookup_keys"."override" AS t0_r12, "lookup_keys"."required" AS t0_r13, "lookup_keys"."lookup_values_count" AS t0_r14, "environment_classes"."id" AS t1_r0, "environment_classes"."puppetclass_id" AS t1_r1, "environment_classes"."environment_id" AS t1_r2, "environment_classes"."lookup_key_id" AS t1_r3 FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."override" = 't' AND "environment_classes"."environment_id" = 1 AND "environment_classes"."puppetclass_id" IN (181, 179, 173, 169, 175, 182, 183, 168, 172, 178, 176) ORDER BY lookup_keys.key
\f0\b0 \
  
\f1\b \cf3 LookupKey Load (1.2ms)
\f0\b0 \cf0   SELECT DISTINCT "lookup_keys".* FROM "lookup_keys" INNER JOIN "environment_classes" ON "lookup_keys"."id" = "environment_classes"."lookup_key_id" WHERE "environment_classes"."puppetclass_id" = 168 AND "lookup_keys"."override" = 't' AND "environment_classes"."environment_id" = 1 AND (environment_classes.lookup_key_id is NOT NULL) ORDER BY lookup_keys.key\
  
\f1\b \cf2 LookupKey Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" = 168 ORDER BY lookup_keys.key
\f0\b0 \
  
\f1\b \cf3 SQL (0.4ms)
\f0\b0 \cf0   SELECT "host_classes"."puppetclass_id" FROM "host_classes" WHERE "host_classes"."host_id" = 147\
  
\f1\b \cf2 SQL (0.4ms)
\f0\b0 \cf0   
\f1\b SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (9, 13, 20)
\f0\b0 \
  
\f1\b \cf3 CACHE (0.0ms)
\f0\b0 \cf0   SELECT "lookup_keys"."id" AS t0_r0, "lookup_keys"."key" AS t0_r1, "lookup_keys"."created_at" AS t0_r2, "lookup_keys"."updated_at" AS t0_r3, "lookup_keys"."puppetclass_id" AS t0_r4, "lookup_keys"."default_value" AS t0_r5, "lookup_keys"."path" AS t0_r6, "lookup_keys"."description" AS t0_r7, "lookup_keys"."validator_type" AS t0_r8, "lookup_keys"."validator_rule" AS t0_r9, "lookup_keys"."is_param" AS t0_r10, "lookup_keys"."key_type" AS t0_r11, "lookup_keys"."override" AS t0_r12, "lookup_keys"."required" AS t0_r13, "lookup_keys"."lookup_values_count" AS t0_r14, "environment_classes"."id" AS t1_r0, "environment_classes"."puppetclass_id" AS t1_r1, "environment_classes"."environment_id" AS t1_r2, "environment_classes"."lookup_key_id" AS t1_r3 FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."override" = 't' AND "environment_classes"."environment_id" = 1 AND "environment_classes"."puppetclass_id" IN (181, 179, 173, 169, 175, 182, 183, 168, 172, 178, 176) ORDER BY lookup_keys.key\
  Rendered puppetclasses/_class_parameters.html.erb (866.2ms)\
  Rendered puppetclasses/_classes_parameters.html.erb (885.0ms)\
  
\f1\b \cf2 CommonParameter Load (1.0ms)
\f0\b0 \cf0   
\f1\b SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('CommonParameter') ORDER BY parameters.name
\f0\b0 \
  
\f1\b \cf3 DomainParameter Load (0.7ms)
\f0\b0 \cf0   SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('DomainParameter') AND "parameters"."reference_id" = 6 ORDER BY parameters.name\
  
\f1\b \cf2 OsParameter Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('OsParameter') AND "parameters"."reference_id" = 1 ORDER BY parameters.name
\f0\b0 \
  
\f1\b \cf3 Hostgroup Load (0.6ms)
\f0\b0 \cf0   SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (9, 13, 20) ORDER BY hostgroups.label\
  
\f1\b \cf2 GroupParameter Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('GroupParameter') AND "parameters"."reference_id" = 9 ORDER BY parameters.name
\f0\b0 \
  
\f1\b \cf3 GroupParameter Load (0.5ms)
\f0\b0 \cf0   SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('GroupParameter') AND "parameters"."reference_id" = 13 ORDER BY parameters.name\
  
\f1\b \cf2 GroupParameter Load (0.8ms)
\f0\b0 \cf0   
\f1\b SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('GroupParameter') AND "parameters"."reference_id" = 20 ORDER BY parameters.name
\f0\b0 \
  Rendered common_parameters/_inherited_parameters.html.erb (4.9ms)\
  
\f1\b \cf3 LookupValue Load (0.7ms)
\f0\b0 \cf0   SELECT "lookup_values".* FROM "lookup_values" WHERE "lookup_values"."match" = 'fqdn=mysql-01.domain.local'\
  Rendered common_parameters/_puppetclass_parameter.html.erb (4.7ms)\
  Rendered common_parameters/_puppetclasses_parameters.html.erb (11.4ms)\
  
\f1\b \cf2 HostParameter Load (0.6ms)
\f0\b0 \cf0   
\f1\b SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('HostParameter') AND "parameters"."reference_id" = 147 ORDER BY parameters.name
\f0\b0 \
  Rendered common_parameters/_parameter.html.erb (4.3ms)\
  Rendered common_parameters/_parameters.html.erb (260.4ms)\
  
\f1\b \cf3 User Load (0.7ms)
\f0\b0 \cf0   SELECT "users".* FROM "users" WHERE "users"."id" = 1 ORDER BY firstname LIMIT 1\
  
\f1\b \cf2 User Load (0.5ms)
\f0\b0 \cf0   
\f1\b SELECT "users".* FROM "users" ORDER BY firstname
\f0\b0 \
  
\f1\b \cf3 Usergroup Load (0.5ms)
\f0\b0 \cf0   SELECT "usergroups".* FROM "usergroups" ORDER BY usergroups.name\
Setting current location thread-local variable to none\
Setting current organization thread-local variable to none\
  Rendered hosts/_form.html.erb (7153.6ms)\
  Rendered hosts/edit.html.erb within layouts/application (7170.6ms)\
  Rendered home/_user_dropdown.html.erb (235.5ms)\
Read fragment views/tabs_and_title_records-1 0.5ms\
  Rendered home/_topbar.html.erb (238.1ms)\
  Rendered layouts/base.html.erb (240.9ms)\
Completed 200 OK in 7709.9ms (Views: 7359.2ms | ActiveRecord: 65.6ms)}