Skip to content

Instantly share code, notes, and snippets.

@xorpaul

xorpaul/ForemanTrendSlow.md

Last active January 3, 2016 11:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save xorpaul/8456338 to your computer and use it in GitHub Desktop.
Save xorpaul/8456338 to your computer and use it in GitHub Desktop.
Download ZIP
More than 1 minute to show a trend graph.
Raw
ForemanTrendSlow.md 
Started GET "/" for 172.20.11.5 at 2014-01-16 15:55:59 +0100
Processing by DashboardController#index as HTML
Redirected to http://foreman.domain.tld/users/login
Filter chain halted as :require_login rendered or redirected
Completed 302 Found in 2.5ms (ActiveRecord: 0.0ms)
Started GET "/trends/282-operating-system-by-codename" for 172.17.26.137 at 2014-01-16 15:56:08 +0100
Processing by TrendsController#show as HTML
  Parameters: {"id"=>"282-operating-system-by-codename"}
  User Load (0.9ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
  Trend Load (1.0ms)  SELECT "trends".* FROM "trends" WHERE "trends"."id" = $1 LIMIT 1  [["id", "282-operating-system-by-codename"]]
  FactTrend Load (17.1ms)  SELECT "trends".* FROM "trends" WHERE "trends"."type" IN ('FactTrend') AND "trends"."trendable_type" = 'FactName' AND "trends"."trendable_id" = 182 AND (fact_value IS NOT NULL) ORDER BY fact_value
  FactName Load (0.7ms)  SELECT "fact_names".* FROM "fact_names" WHERE "fact_names"."id" IN (182) ORDER BY fact_names.name
  SQL (5570.5ms)  SELECT "trends"."id" AS t0_r0, "trends"."trendable_type" AS t0_r1, "trends"."trendable_id" AS t0_r2, "trends"."name" AS t0_r3, "trends"."type" AS t0_r4, "trends"."fact_value" AS t0_r5, "trends"."fact_name" AS t0_r6, "trends"."created_at" AS t0_r7, "trends"."updated_at" AS t0_r8, "trend_counters"."id" AS t1_r0, "trend_counters"."trend_id" AS t1_r1, "trend_counters"."count" AS t1_r2, "trend_counters"."created_at" AS t1_r3, "trend_counters"."updated_at" AS t1_r4 FROM "trends" LEFT OUTER JOIN "trend_counters" ON "trend_counters"."trend_id" = "trends"."id" WHERE "trends"."type" IN ('FactTrend') AND "trends"."trendable_type" = 'FactName' AND "trends"."trendable_id" = 182 AND (fact_value IS NOT NULL) AND (trend_counters.created_at > '2013-10-18 14:56:08.463871') ORDER BY trend_counters.created_at
Started GET "/" for 172.20.11.5 at 2014-01-16 15:56:59 +0100
Processing by DashboardController#index as HTML
Redirected to http://foreman.domain.tld/users/login
Filter chain halted as :require_login rendered or redirected
Completed 302 Found in 1.7ms (ActiveRecord: 0.0ms)
  Rendered trends/show.html.erb within layouts/application (63174.7ms)
  Rendered home/_user_dropdown.html.erb (1.4ms)
Read fragment views/tabs_and_title_records-1 0.1ms
  Rendered home/_topbar.html.erb (1.2ms)
Completed 200 OK in 63217.9ms (Views: 57622.4ms | ActiveRecord: 5590.2ms)
Started GET "/" for 172.20.11.5 at 2014-01-16 15:58:00 +0100
Processing by DashboardController#index as HTML
Redirected to http://foreman.domain.tld/users/login
Filter chain halted as :require_login rendered or redirected
Completed 302 Found in 2.8ms (ActiveRecord: 0.0ms)
Started GET "/" for 172.20.11.5 at 2014-01-16 15:58:59 +0100
Processing by DashboardController#index as HTML
Redirected to http://foreman.domain.tld/users/login
Filter chain halted as :require_login rendered or redirected
Completed 302 Found in 2.4ms (ActiveRecord: 0.0ms)
Raw
ForemanTrendSlow2.md 
Started GET "/trends/134-cron-vs-daemon-puppet-client" for 172.17.26.137 at 2014-01-16 16:08:05 +0100
Processing by TrendsController#show as HTML
  Parameters: {"id"=>"134-cron-vs-daemon-puppet-client"}
  User Load (2.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
  Setting Load (1.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'idle_timeout' ORDER BY name LIMIT 1
  Trend Load (2.0ms)  SELECT "trends".* FROM "trends" WHERE "trends"."id" = $1 LIMIT 1  [["id", "134-cron-vs-daemon-puppet-client"]]
  Setting Load (2.0ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'max_trend' ORDER BY name LIMIT 1
  FactTrend Load (8.0ms)  SELECT "trends".* FROM "trends" WHERE "trends"."type" IN ('FactTrend') AND "trends"."trendable_type" = 'FactName' AND "trends"."trendable_id" = 97 AND (fact_value IS NOT NULL) ORDER BY fact_value
  FactName Load (1.5ms)  SELECT "fact_names".* FROM "fact_names" WHERE "fact_names"."id" IN (97) ORDER BY fact_names.name
  SQL (977.0ms)  SELECT "trends"."id" AS t0_r0, "trends"."trendable_type" AS t0_r1, "trends"."trendable_id" AS t0_r2, "trends"."name" AS t0_r3, "trends"."type" AS t0_r4, "trends"."fact_value" AS t0_r5, "trends"."fact_name" AS t0_r6, "trends"."created_at" AS t0_r7, "trends"."updated_at" AS t0_r8, "trend_counters"."id" AS t1_r0, "trend_counters"."trend_id" AS t1_r1, "trend_counters"."count" AS t1_r2, "trend_counters"."created_at" AS t1_r3, "trend_counters"."updated_at" AS t1_r4 FROM "trends" LEFT OUTER JOIN "trend_counters" ON "trend_counters"."trend_id" = "trends"."id" WHERE "trends"."type" IN ('FactTrend') AND "trends"."trendable_type" = 'FactName' AND "trends"."trendable_id" = 97 AND (fact_value IS NOT NULL) AND (trend_counters.created_at > '2013-10-18 15:08:06.874214') ORDER BY trend_counters.created_at
  Rendered trends/show.html.erb within layouts/application (12292.9ms)
  Setting Load (0.9ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_gravatar' ORDER BY name LIMIT 1
  Rendered home/_user_dropdown.html.erb (8.5ms)
Read fragment views/tabs_and_title_records-1 0.1ms
  Rendered home/_org_switcher.html.erb (0.5ms)
  Rendered home/_settings.html.erb (12.3ms)
Write fragment views/tabs_and_title_records-1 0.9ms
  Rendered home/_topbar.html.erb (20.5ms)
Completed 200 OK in 12723.5ms (Views: 11553.6ms | ActiveRecord: 1011.2ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment