Running cap & u for a process that is taking longer than 10 minutes to run and timing out
This had ManageIQ/manageiq#9611 applied run locally from a db dump of 101
| class | count |
|---|---|
| Ems | 1 |
| EmsFolder | 6 |
| Host | 200 |
| MiqAlert | 25 |
| MiqAlertSet | 0 |
| MiqQueue | 6,454 |
| MiqTask | 65,062 |
| Relationship | 20,642 |
| ResourcePool | 220 |
| Storage | 221 |
| Tag | 131 |
| Tagging | 20,034 |
| Vm | 10,000 |
| Zone | 1 |
| ms | bytes | objects | ms- | queries | query (ms) | rows | comments |
|---|---|---|---|---|---|---|---|
| 184,147.8 | 374,115,368* | 150,562,778 | 0.0 | 77,765 | 57,977.9 | 109,380 | before-1 |
| 184,104.8 | 28.3 | 1 | 19.1 | 1 | .Metric::Capture.perf_capture_timer |
||
| 19.1 | 0.4 | 1 | ..SELECT "zones".* |
||||
| 51.4 | 51.4 | 1 | 41.5 | 1,656 | ..Metric::Capture.perf_capture_health_check |
||
| 41.5 | 5.0 | 1,656 | ...SELECT "miq_queue"."method_name", "miq_queue"."created_on" |
||||
| 2,144.0 | 0.2 | ..Metric::Targets.capture_targets |
|||||
| 2,143.4 | 2,034.2 | 11 | 994.1 | 11,045 | ...Metric::Targets.capture_infra_targets |
||
| 1.5 | 1 | 1.0 | 1 | ....SELECT "ext_management_systems".* |
|||
| 6.6 | 1 | 1.2 | 200 | ....SELECT "hosts".* |
|||
| 81.6 | 1 | 13.6 | 20 | ....SELECT "ems_clusters".* |
|||
| 30.2 | 3 | 30.1 | ....SELECT "taggings".* |
||||
| 18.8 | 1 | 3.2 | 600 | ....SELECT "host_storages".* |
|||
| 49.6 | 1 | 3.0 | 221 | ....SELECT "storages".* |
|||
| 764.9 | 1 | 73.7 | 10,000 | ....SELECT "vms".* |
|||
| 20.5 | 1 | 0.5 | 1 | ....SELECT "miq_regions".* |
|||
| 20.4 | 1 | 18.1 | 2 | ....SELECT "tags".* |
|||
| 12.0 | 12.0 | ....Metric::Targets.capture_storage_targets |
|||||
| 97.2 | 97.2 | ....Metric::Targets.capture_vm_targets |
|||||
| 753.6 | 753.6 | 202 | 135.3 | ..Metric::Capture.calc_targets_by_rollup_parent |
|||
| 0.5 | 1 | 0.5 | ...SELECT "miq_sets".* |
||||
| 2.1 | 1 | 2.1 | ...SELECT "tags"."id" AS t0_r0, "tags"."name" AS t0_r1, "taggings"."id" AS t1_r0, "taggings"."taggable_i |
||||
| 132.7 | 200 | 132.7 | ...SELECT "taggings"."id" AS t0_r0, "taggings"."taggable_id" AS t0_r1, "taggings"."tag_id" AS t0_r2, "ta |
||||
| 255.1 | 255.1 | 80 | 83.5 | 20 | ..Metric::Capture.calc_tasks_by_rollup_parent |
||
| 27.3 | 20 | 11.7 | 20 | ...SELECT "miq_tasks".* |
|||
| 4.7 | 20 | 4.7 | ...BEGIN |
||||
| 43.3 | 20 | 43.3 | ...INSERT INTO "miq_tasks" |
||||
| 8.2 | 20 | 8.2 | ...COMMIT |
||||
| 79.0 | 79.0 | ..Metric::Capture.calc_target_options |
|||||
| 177,974.9 | 177,974.9 | 77,466 | 56,556.3 | 96,658 | ..Metric::Capture.queue_captures |
||
| 13,047.7 | 5,421 | 12,849.8 | 1,658 | ...SELECT "miq_queue".* |
|||
| 696.4 | 3,940 | 696.4 | ...BEGIN |
||||
| 2.8 | 2 | 2.8 | ...UPDATE "miq_queue" SET "miq_callback" = .{150}, "updated_on" = .{28}, "lock_version" = 1 |
||||
| 824.6 | 3,940 | 824.6 | ...COMMIT |
||||
| 3,618.8 | 3,763 | 3,618.8 | ...INSERT INTO "miq_queue" |
||||
| 1.2 | 2 | 1.2 | ...UPDATE "miq_queue" SET "miq_callback" = .{170}, "updated_on" = .{28}, "lock_version" = 3 |
||||
| 5.1 | 12 | 5.1 | ...UPDATE "miq_queue" SET "miq_callback" = .{161}, "updated_on" = .{28}, "lock_version" = 2 |
||||
| 9.5 | 15 | 9.5 | ...UPDATE "miq_queue" SET "miq_callback" = .{151}, "updated_on" = .{28}, "lock_version" = 1 |
||||
| 21.2 | 36 | 21.2 | ...UPDATE "miq_queue" SET "miq_callback" = .{211}, "updated_on" = .{28}, "lock_version" = 7 |
||||
| 7.0 | 11 | 7.0 | ...UPDATE "miq_queue" SET "miq_callback" = .{171}, "updated_on" = .{28}, "lock_version" = 3 |
||||
| 6.0 | 13 | 6.0 | ...UPDATE "miq_queue" SET "miq_callback" = .{212}, "updated_on" = .{28}, "lock_version" = 7 |
||||
| 3.1 | 6 | 3.1 | ...UPDATE "miq_queue" SET "miq_callback" = .{202}, "updated_on" = .{28}, "lock_version" = 6 |
||||
| 6.8 | 12 | 6.8 | ...UPDATE "miq_queue" SET "miq_callback" = .{172}, "updated_on" = .{28}, "lock_version" = 3 |
||||
| 4.0 | 9 | 4.0 | ...UPDATE "miq_queue" SET "miq_callback" = .{192}, "updated_on" = .{28}, "lock_version" = 5 |
||||
| 9.4 | 17 | 9.4 | ...UPDATE "miq_queue" SET "miq_callback" = .{182}, "updated_on" = .{28}, "lock_version" = 4 |
||||
| 7.8 | 15 | 7.8 | ...UPDATE "miq_queue" SET "miq_callback" = .{162}, "updated_on" = .{28}, "lock_version" = 2 |
||||
| 10.1 | 19 | 10.1 | ...UPDATE "miq_queue" SET "miq_callback" = .{152}, "updated_on" = .{28}, "lock_version" = 1 |
||||
| 0.3 | 1 | 0.3 | ...UPDATE "miq_queue" SET "miq_callback" = .{160}, "updated_on" = .{28}, "lock_version" = 2 |
||||
| 0.6 | 1 | 0.6 | ...UPDATE "miq_queue" SET "miq_callback" = .{210}, "updated_on" = .{28}, "lock_version" = 7 |
||||
| 1.8 | 4 | 1.8 | ...UPDATE "miq_queue" SET "miq_callback" = .{201}, "updated_on" = .{28}, "lock_version" = 6 |
||||
| 0.5 | 1 | 0.5 | ...UPDATE "miq_queue" SET "miq_callback" = .{191}, "updated_on" = .{28}, "lock_version" = 5 |
||||
| 0.4 | 1 | 0.4 | ...UPDATE "miq_queue" SET "miq_callback" = .{200}, "updated_on" = .{28}, "lock_version" = 6 |
||||
| 9,541.1 | 5,221 | 8,179.3 | 10,000 | ...SELECT "taggings"."id" AS t0_r0, "taggings"."taggable_id" AS t0_r1, "taggings"."tag_id" AS t0_r2, "ta |
|||
| 10,918.3 | 10,000 | 9,262.2 | 30,000 | ...SELECT "relationships".* |
|||
| 10,059.2 | 30,000 | 8,792.1 | 30,000 | ...SELECT "relationships".* |
|||
| 5,146.1 | 10,000 | 3,544.5 | 20,000 | ...SELECT "ems_folders".* |
|||
| 2,605.0 | 5,000 | 1,975.8 | 5,000 | ...SELECT "resource_pools".* |
|||
| 0.6 | 2 | 0.6 | ...SELECT "miq_sets".* |
||||
| 0.9 | 2 | 0.9 | ...SELECT "tags"."id" AS t0_r0, "tags"."name" AS t0_r1, "taggings"."id" AS t1_r0, "taggings"."taggable_i |
||||
| 2,818.6 | 2,818.6 | 4 | 148.1 | ..MiqTask.delete_older |
|||
| 84.5 | 1 | 84.5 | ...SELECT "miq_tasks"."id" |
||||
| 0.2 | 1 | 0.2 | ...BEGIN |
||||
| 63.0 | 1 | 63.0 | ...INSERT INTO "miq_queue" |
||||
| 0.4 | 1 | 0.4 | ...COMMIT |
| ms | bytes | objects | ms- | queries | query (ms) | rows | comments |
|---|---|---|---|---|---|---|---|
| 155,554.0 | 231,559,632* | 149,381,684 | 0.0 | 82,210 | 43,010.9 | 106,048 | truncated-1 |
| 155,488.2 | 5.1 | 2 | 1.2 | 2 | .Metric::Capture.perf_capture_timer |
||
| 0.8 | 1 | 0.6 | 1 | ..SELECT "miq_servers".* |
|||
| 0.4 | 1 | 0.3 | 1 | ..SELECT "zones".* |
|||
| 1.7 | 1.7 | 1 | 0.6 | ..Metric::Capture.perf_capture_health_check |
|||
| 0.6 | 0.6 | ...SELECT "miq_queue"."method_name", "miq_queue"."created_on" |
|||||
| 1,650.5 | 0.1 | ..Metric::Targets.capture_targets |
|||||
| 1,650.2 | 1,555.0 | 11 | 713.1 | 11,045 | ...Metric::Targets.capture_infra_targets |
||
| 0.5 | 1 | 0.2 | 1 | ....SELECT "ext_management_systems".* |
|||
| 6.4 | 1 | 1.0 | 200 | ....SELECT "hosts".* |
|||
| 1.0 | 1 | 0.6 | 20 | ....SELECT "ems_clusters".* |
|||
| 9.7 | 3 | 9.7 | ....SELECT "taggings".* |
||||
| 7.2 | 1 | 1.3 | 600 | ....SELECT "host_storages".* |
|||
| 10.6 | 1 | 7.4 | 221 | ....SELECT "storages".* |
|||
| 676.5 | 1 | 64.2 | 10,000 | ....SELECT "vms".* |
|||
| 0.6 | 1 | 0.5 | 1 | ....SELECT "miq_regions".* |
|||
| 0.6 | 1 | 0.5 | 2 | ....SELECT "tags".* |
|||
| 11.0 | 11.0 | ....Metric::Targets.capture_storage_targets |
|||||
| 84.2 | 84.2 | ....Metric::Targets.capture_vm_targets |
|||||
| 620.4 | 620.4 | 203 | 116.3 | 1 | ..Metric::Capture.calc_targets_by_rollup_parent |
||
| 0.4 | 1 | 0.4 | ...SELECT "miq_sets".* |
||||
| 0.4 | 1 | 0.4 | ...SELECT "tags"."id" AS t0_r0, "tags"."name" AS t0_r1, "taggings"."id" AS t1_r0, "taggings"."taggable_i |
||||
| 0.3 | 1 | 0.2 | 1 | ...SELECT "miq_enterprises".* |
|||
| 115.2 | 200 | 115.2 | ...SELECT "taggings"."id" AS t0_r0, "taggings"."taggable_id" AS t0_r1, "taggings"."tag_id" AS t0_r2, "ta |
||||
| 114.5 | 114.5 | 80 | 23.1 | ..Metric::Capture.calc_tasks_by_rollup_parent |
|||
| 7.2 | 20 | 7.2 | ...SELECT "miq_tasks".* |
||||
| 2.7 | 20 | 2.7 | ...BEGIN |
||||
| 9.7 | 20 | 9.7 | ...INSERT INTO "miq_tasks" |
||||
| 3.5 | 20 | 3.5 | ...COMMIT |
||||
| 58.0 | 58.0 | ..Metric::Capture.calc_target_options |
|||||
| 153,032.9 | 153,032.9 | 81,909 | 42,155.5 | 95,000 | ..Metric::Capture.queue_captures |
||
| 9,014.1 | 5,421 | 8,997.5 | ...SELECT "miq_queue".* |
||||
| 817.9 | 5,421 | 817.9 | ...BEGIN |
||||
| 3,406.2 | 5,421 | 3,406.2 | ...INSERT INTO "miq_queue" |
||||
| 983.4 | 5,421 | 983.4 | ...COMMIT |
||||
| 6,175.0 | 5,221 | 4,944.3 | 10,000 | ...SELECT "taggings"."id" AS t0_r0, "taggings"."taggable_id" AS t0_r1, "taggings"."tag_id" AS t0_r2, "ta |
|||
| 5,350.8 | 10,000 | 4,296.6 | 30,000 | ...SELECT "relationships".* |
|||
| 9,573.9 | 30,000 | 8,587.2 | 30,000 | ...SELECT "relationships".* |
|||
| 4,563.3 | 10,000 | 3,206.6 | 20,000 | ...SELECT "ems_folders".* |
|||
| 2,269.0 | 5,000 | 1,729.0 | 5,000 | ...SELECT "resource_pools".* |
|||
| 0.8 | 2 | 0.8 | ...SELECT "miq_sets".* |
||||
| 1.1 | 2 | 1.1 | ...SELECT "tags"."id" AS t0_r0, "tags"."name" AS t0_r1, "taggings"."id" AS t1_r0, "taggings"."taggable_i |
||||
| 5.2 | 5.2 | 4 | 1.1 | ..MiqTask.delete_older |
|||
| 0.3 | 1 | 0.3 | ...SELECT "miq_tasks"."id" |
||||
| 0.1 | 1 | 0.1 | ...BEGIN |
||||
| 0.5 | 1 | 0.5 | ...INSERT INTO "miq_queue" |
||||
| 0.2 | 1 | 0.2 | ...COMMIT |
* Memory usage does not reflect 73,463,803 freed objects.
