Project

General

Profile

Actions

Bug #20354

open

n+1 count when listing vmware vm's

Added by Ohad Levy almost 8 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Compute resources - VMware
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

from the logs:

 [app] [I] Started GET "/compute_resources/29-/vms" for ::1 at 2017-07-20 09:58:25 +0300
 [app] [I] Processing by ComputeResourcesVmsController#index as HTML
 [app] [I]   Parameters: {"compute_resource_id"=>"29-"}
 [sql] [D]   ActiveRecord::SessionStore::Session Load (0.3ms)  SELECT  "sessions".* FROM "sessions" WHERE "sessions"."session_id" = ? ORDER BY "sessions"."id" ASC LIMIT ?  [["session_id", "01daaa37d34e6c9cd5273e70deb1b42b"], ["LIMIT", 1]]
 [sql] [D]   User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = ? LIMIT ?  [["id", 1], ["LIMIT", 1]]
 [app] [I] Current user: admin (administrator)
 [app] [D] Setting current user thread-local variable to admin
 [sql] [D]    (0.3ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization')
 [app] [D] Setting current organization thread-local variable to none
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location')
 [app] [D] Setting current location thread-local variable to none
 [sql] [D]   AuthSource Load (0.3ms)  SELECT  "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = ? LIMIT ?  [["id", 9], ["LIMIT", 1]]
 [sql] [D]    (0.2ms)  SELECT  "taxonomies"."id" FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT ?  [["LIMIT", 1]]
 [sql] [D]    (0.3ms)  SELECT  "taxonomies"."id" FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') LIMIT ?  [["LIMIT", 1]]
 [sql] [D]   ComputeResource Load (0.5ms)  SELECT  "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = ? ORDER BY compute_resources.name LIMIT ?  [["id", 29], ["LIMIT", 1]]
 [app] [I]   Rendering compute_resources_vms/index.html.erb within layouts/application
 [sql] [D]    (0.3ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502eeead-da13-8497-e824-68ea664a7a13'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e5b19-e349-9a78-bc8d-990f06724787'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e246d-5670-8948-57f9-5988ea6fa612'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e020d-9e0c-2421-fa6c-098902616bec'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e33dd-281d-db72-1fdd-72565d667910'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e3834-81b9-dd17-1ec1-986363a547e9'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e6003-eb43-b429-5126-6e1451c8cebe'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502efb57-9bbc-781f-6ea0-db5ec3e075d5'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e816a-f229-7051-7001-dad9d2239b5a'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e9c57-8716-2d97-49a2-b9e6a3a5cbb6'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e00b3-21d0-c896-6655-b8e9bbc1157e'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e0d13-7c21-0685-9cbe-7863be8bc02f'  [["compute_resource_id", 29]]
 [sql] [D]    (0.3ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e2bda-8c72-6273-f495-a85b38d41acc'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501ed7dc-fec1-73ae-41e3-a5c1dcae4086'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e9c97-4320-8c18-11c1-e12780aedef2'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e7477-7340-e187-1a1e-87850c17809c'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '50312c5e-851b-8e99-ed29-4524eaf71955'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502ee01c-f42d-7bd0-dab9-dbffb028a492'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502ec2a7-27b1-12b3-e454-988621f5b275'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e5e88-2cd8-5273-4191-47b92abd9349'  [["compute_resource_id", 29]]
 [sql] [D]    (0.3ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502edc4f-729b-a099-5431-a95933783c6c'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e3fbb-70d0-593a-b07b-702d5af45909'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e750b-c806-c091-9aeb-c9684416a0fc'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501ea5e7-d041-2c48-9ae4-904901f550e1'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '523ea6b0-9c58-3198-64da-2db8d5c27f5b'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501ebdfe-a5f1-153f-1f09-f55544a1c703'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502ef107-2042-5ac7-4690-e98a2b423558'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e7fac-f5d5-ab41-c749-0b7a601b5876'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e0d25-8e83-8006-ae19-d7536f11ceff'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e2193-611b-a879-c85e-6c893fb2f766'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e0533-c08c-4b41-7b38-dab314ac9d07'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e5008-16c5-e6f1-05fe-d73887478a54'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501eebe4-8a0b-b926-599f-e2f78982782a'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e3758-c2d4-48fb-8297-b4fe238cbb1e'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e8163-bfc6-2dae-8d38-688e9fe8f1bf'  [["compute_resource_id", 29]]
 [sql] [D]    (0.3ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e75d0-aa98-7642-fb1e-c24cea4d91a1'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501ee056-2345-c0f9-9d8b-4cbff31a0a8c'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501ef9ff-22f3-4507-c347-23b6f6b95d1c'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e0a0e-e886-21ab-f0f6-6b86745e354f'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e397f-f193-a349-8a75-993f1b75ccee'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501ed804-491a-1e2b-a0e5-9cd47a7ce1bd'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '50312ef9-c2ab-ab33-9377-dae2e3c862ac'  [["compute_resource_id", 29]]
 [sql] [D]    (0.3ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e60a2-27ca-dc38-34ce-64ced3bb783e'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502ed4f6-f641-01a3-eefd-9d63ad025e02'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501edc40-cdfb-e406-a239-9b85dff761e8'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e8c0a-3359-52f3-7236-5f044fe026f4'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502ee41e-c028-7143-bf16-c92fc342e75e'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e8db3-4bb8-b776-20aa-ed2d43fab649'  [["compute_resource_id", 29]]
 [sql] [D]    (0.2ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e08bb-0c92-bfaa-fcc1-09a569f5c463'  [["compute_resource_id", 29]]
 [sql] [D]    (0.1ms)  SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e0e31-ff68-3bd6-8bdf-adae3278c599'  [["compute_resource_id", 29]]
 [app] [I]   Rendered compute_resources_vms/index/_vmware.html.erb (227.7ms)
 [app] [I]   Rendered compute_resources_vms/index.html.erb within layouts/application (232.9ms)
 [app] [I]   Rendered layouts/_application_content.html.erb (0.9ms)
 [app] [I]   Rendering layouts/base.html.erb
 [app] [I]   Rendered home/_user_dropdown.html.erb (2.1ms)
 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization')
 [sql] [D]   Organization Load (0.1ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') ORDER BY "taxonomies"."title" ASC
 [app] [I]   Rendered home/_organization_dropdown.html.erb (3.4ms)
 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location')
 [sql] [D]   Location Load (0.1ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') ORDER BY "taxonomies"."title" ASC
 [app] [I]   Rendered home/_location_dropdown.html.erb (3.9ms)
 [app] [I]   Rendered home/_org_switcher.html.erb (9.0ms)
 [app] [I]   Rendered home/_submenu.html.erb (4.4ms)
 [app] [I]   Rendered home/_submenu.html.erb (3.1ms)
 [app] [I]   Rendered home/_submenu.html.erb (1.6ms)
 [app] [I]   Rendered home/_submenu.html.erb (1.1ms)
 [app] [I]   Rendered home/_submenu.html.erb (1.6ms)
 [app] [I]   Rendered home/_topbar.html.erb (30.2ms)
 [app] [I]   Rendered layouts/base.html.erb (301.4ms)
 [app] [I] Completed 200 OK in 48608ms (Views: 533.7ms | ActiveRecord: 10.8ms)

No data to display

Actions

Also available in: Atom PDF