Skip to content

Instantly share code, notes, and snippets.

@dLobatog

dLobatog/gist:c3b65aa9ea4f4f81356c5ecac9846cc7

Created April 23, 2019 16:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dLobatog/c3b65aa9ea4f4f81356c5ecac9846cc7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dLobatog/c3b65aa9ea4f4f81356c5ecac9846cc7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Started POST "/api/compliance/graphql" for 127.0.0.1 at 2019-04-23 18:56:27 +0200
Processing by GraphqlController#query as */*
Parameters: {"operationName"=>"System", "variables"=>{"systemId"=>"f5cf6f1c-fccf-4f41-8001-f12434cb0943"}, "query"=>"query System($systemId: String!) {\n system(id: $systemId) {\n id\n name\n profiles {\n name\n ref_id\n compliant(system_id: $systemId)\n rules_failed(system_id: $systemId)\n rules_passed(system_id: $systemId)\n last_scanned(system_id: $systemId)\n rules {\n title\n severity\n rationale\n ref_id\n description\n compliant(system_id: $systemId)\n __typename\n }\n __typename\n }\n __typename\n }\n}\n", "graphql"=>{"operationName"=>"System", "variables"=>{"systemId"=>"f5cf6f1c-fccf-4f41-8001-f12434cb0943"}, "query"=>"query System($systemId: String!) {\n system(id: $systemId) {\n id\n name\n profiles {\n name\n ref_id\n compliant(system_id: $systemId)\n rules_failed(system_id: $systemId)\n rules_passed(system_id: $systemId)\n last_scanned(system_id: $systemId)\n rules {\n title\n severity\n rationale\n ref_id\n description\n compliant(system_id: $systemId)\n __typename\n }\n __typename\n }\n __typename\n }\n}\n"}}
User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."username" = $1 LIMIT $2 [["username", "dlobatog@redhat.com"], ["LIMIT", 1]]
↳ app/controllers/graphql_controller.rb:9
Host Load (0.5ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:173
Profile Load (0.7ms) SELECT "profiles".* FROM "profiles" INNER JOIN "profile_hosts" ON "profiles"."id" = "profile_hosts"."profile_id" WHERE "profile_hosts"."host_id" = $1 [["host_id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"]]
↳ app/controllers/graphql_controller.rb:10
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:50
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:66
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:58
Rule Load (5.9ms) SELECT "rules".* FROM "rules" INNER JOIN "profile_rules" ON "rules"."id" = "profile_rules"."rule_id" WHERE "profile_rules"."profile_id" = $1 [["profile_id", "e0c64a9b-003e-4c66-b87d-50059ebcf673"]]
↳ app/models/schema.rb:75
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
Prometheus Exporter is dropping a message: Connection reset by peer
Prometheus Exporter, failed to send message Connection reset by peer
↳ app/models/schema.rb:77
(12.7ms) SELECT MAX("rule_results"."updated_at") FROM "rule_results" WHERE "rule_results"."rule_id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367) AND "rule_results"."host_id" = $368 [["rule_id", "174ba014-46db-464d-a18d-95fdcfd21caa"], ["rule_id", "d8efea75-0e80-401c-b243-778b0c2c43a8"], ["rule_id", "0787e391-516d-4da6-8193-eb0e1c9d32bc"], ["rule_id", "9b79e846-b90e-4158-89ac-f202c5999a15"], ["rule_id", "67c7a93d-e648-4d1a-9b5b-e0536fa26920"], ["rule_id", "dfd2c629-f75b-4e80-a378-e8de4f030cdb"], ["rule_id", "9c8db7e5-5b75-4367-99fd-f9facb0e9404"], ["rule_id", "b4f1be1d-05ed-4780-b714-bdc8c0477691"], ["rule_id", "e7ca0dd1-1dcf-4020-8840-2ec2a8da0cd9"], ["rule_id", "26a2e4bc-6671-4587-9f0b-9cf167a6e77b"], ["rule_id", "c0f15852-6bd0-4b2a-b6ca-232b171d128d"], ["rule_id", "88dfd2c6-7f00-4904-a71f-bc15d0555011"], ["rule_id", "b45c1d40-2677-4b92-9eb2-2b6e9860c198"], ["rule_id", "ddaf4faf-2b53-4e5b-a9b2-c1344ce96df7"], ["rule_id", "34a13fb7-c80f-49ef-8600-b81c2216f5bc"], ["rule_id", "38d54e8a-7701-4635-85ff-29f3879809e5"], ["rule_id", "ecbfddf6-2910-4f2d-a04c-76570b093aee"], ["rule_id", "0e55bd25-364b-4bf3-93a4-f983984d15a1"], ["rule_id", "6ba3d742-3715-4e08-a2a1-3a4132f71101"], ["rule_id", "f05c0e09-29ec-4107-8584-0b6519bd5b94"], ["rule_id", "eb05594d-71c7-47f8-8708-a0b59cf010b3"], ["rule_id", "d836b0a4-1910-41ed-8632-1d496fdc4c99"], ["rule_id", "c2843f13-fba1-4a63-8ce2-a20d52b350d9"], ["rule_id", "1d3202ba-b04d-4753-b4ba-9b239d108d0d"], ["rule_id", "b350706f-f2da-4d12-ad24-771435fe800a"], ["rule_id", "01652af4-a551-4a17-8fa4-077458333d2e"], ["rule_id", "1fe9cf2c-d488-4099-95bd-ba06a6416225"], ["rule_id", "d17521e0-045b-4b9b-97c4-aab66ed5fee4"], ["rule_id", "d646b30a-9c63-4938-abdd-f7bd45b7f604"], ["rule_id", "140b2bfe-ec18-4a42-be87-04e605e462da"], ["rule_id", "c5235b3d-a034-4fbb-b9d6-b70556d2ffb3"], ["rule_id", "6a37f53b-7000-43fa-bbe5-d7c3b26229d3"], ["rule_id", "e51d6b44-4883-4575-9f87-ad42c7213423"], ["rule_id", "05817a7b-f9a9-4816-ada2-3fcb27f5abce"], ["rule_id", "5b63d7f4-a4c3-4a05-9fac-8fbcd61ad4b2"],
↳ app/models/schema.rb:78
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (5.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '174ba014-46db-464d-a18d-95fdcfd21caa'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd8efea75-0e80-401c-b243-778b0c2c43a8'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0787e391-516d-4da6-8193-eb0e1c9d32bc'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9b79e846-b90e-4158-89ac-f202c5999a15'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '67c7a93d-e648-4d1a-9b5b-e0536fa26920'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'dfd2c629-f75b-4e80-a378-e8de4f030cdb'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9c8db7e5-5b75-4367-99fd-f9facb0e9404'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b4f1be1d-05ed-4780-b714-bdc8c0477691'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e7ca0dd1-1dcf-4020-8840-2ec2a8da0cd9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (6.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '26a2e4bc-6671-4587-9f0b-9cf167a6e77b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c0f15852-6bd0-4b2a-b6ca-232b171d128d'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '88dfd2c6-7f00-4904-a71f-bc15d0555011'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b45c1d40-2677-4b92-9eb2-2b6e9860c198'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'ddaf4faf-2b53-4e5b-a9b2-c1344ce96df7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '34a13fb7-c80f-49ef-8600-b81c2216f5bc'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '38d54e8a-7701-4635-85ff-29f3879809e5'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'ecbfddf6-2910-4f2d-a04c-76570b093aee'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0e55bd25-364b-4bf3-93a4-f983984d15a1'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '6ba3d742-3715-4e08-a2a1-3a4132f71101'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f05c0e09-29ec-4107-8584-0b6519bd5b94'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'eb05594d-71c7-47f8-8708-a0b59cf010b3'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd836b0a4-1910-41ed-8632-1d496fdc4c99'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c2843f13-fba1-4a63-8ce2-a20d52b350d9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '1d3202ba-b04d-4753-b4ba-9b239d108d0d'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b350706f-f2da-4d12-ad24-771435fe800a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '01652af4-a551-4a17-8fa4-077458333d2e'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '1fe9cf2c-d488-4099-95bd-ba06a6416225'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd17521e0-045b-4b9b-97c4-aab66ed5fee4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (9.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd646b30a-9c63-4938-abdd-f7bd45b7f604'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '140b2bfe-ec18-4a42-be87-04e605e462da'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c5235b3d-a034-4fbb-b9d6-b70556d2ffb3'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '6a37f53b-7000-43fa-bbe5-d7c3b26229d3'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e51d6b44-4883-4575-9f87-ad42c7213423'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '05817a7b-f9a9-4816-ada2-3fcb27f5abce'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '5b63d7f4-a4c3-4a05-9fac-8fbcd61ad4b2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2006d3ea-1aec-4f5e-ac77-efa438a1c35d'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '96d9f45a-0ac4-4959-8175-fca84300ec35'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '43e24267-715b-45f7-b6a5-a23dd78817bc'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'aceabf4e-0f91-40a5-99c3-944dcd5c074e'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd4b79834-d7be-44c0-94e1-6f52ae0027c5'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2bf76a20-50e7-4dcc-9193-bd6366cb2ee3'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '201b2a94-0d8b-44ef-a269-34d3a81ac8db'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2488f84d-5b20-4459-93e3-919c26d5a597'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'dd348b39-5a7b-4132-a460-779049e9d818'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2db23684-f5dc-4862-a1a6-23b68898f2e0'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'da45283b-490a-4691-b995-134d9e6ccdbe'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e61fa1b1-fbff-4df8-b529-87286d4ee21a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e027afef-cfe1-48df-ba3c-000c58881ca1'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (4.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '274915e2-af76-41b4-b7a0-874b92e8b9ae'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '691d4a7d-32a3-45ec-ace8-e6b13b16f9b7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd7ad0657-7161-4c53-bced-f9dff5af2c5d'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'de8fd042-0678-4e8c-91a1-852b3df2948b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b7d762b8-e30a-48e1-9538-483f44c8c80c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3289ed45-1b0f-44d3-a559-9239f272b0f0'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '4b64d5aa-51c4-49c6-83e5-49def89afdae'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b2c01b32-2114-4c7c-871c-08948b1b814c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '4cc42ce5-fe92-4f3b-a5ed-776bbf7f0f9f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '1c13ca2d-78ff-4560-bbec-319bde86d086'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '639430f0-a9cc-4365-988c-c1bfd458c8d7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '37a96f35-4757-492d-8371-c03cd99661b4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f5113dbe-25ea-45d4-9e89-2fd1b54d6c96'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c1cdd31c-fc2e-473d-b6fb-88c27f78879e'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f7e8b655-e87f-471d-a5bb-a7844b454089'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (8.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '63aff25b-9973-4f31-a230-758f36351fb8'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (6.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd273719d-76a8-47f6-b6d9-64f3476b08b3'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '16be2b83-826c-4237-bb1b-f8608331544c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (4.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f543dee1-61cc-4236-80b0-edb8e446b671'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'cb4948f7-2c97-42eb-8b89-b94953cc83e2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '74bd071d-0264-4f1b-84dd-65adf34f5703'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'cb7460a9-3cc6-40b5-8325-576bd625f88a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (6.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '7f8bb58c-4964-49a0-b7ab-3bb2857f4ded'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f0a42484-92de-4dc1-ab00-71d9c145e7d2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f24e5300-8ce5-4c76-bef2-fe377e3493a6'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'dceb59a0-6bf6-4246-b404-4085a86ad2ef'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (5.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '8fb91c01-fe77-413c-b791-df17e3b2e76b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '66248880-d781-403b-b0eb-012616d20fb7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'bdcaa618-0bc4-4485-a244-b9638b26463b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'a397cd39-04e9-4318-bc79-3b21a9a3b46b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e3378363-64d0-4dd6-a7af-949fa8000f38'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '5e95bee6-7d76-42de-bb0f-90ec3a71f2f4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd4439abf-7701-4b60-8fc3-dde23cb00818'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (5.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f4a6f5ed-29d0-4e2f-9caf-7aa40a1377e1'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0f9cc90c-ee45-41be-824f-95cb433a5b19'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '879c3483-b89a-47f0-9327-2a6ac200a20c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'a331c2de-8e59-403f-ad7d-2f4e59b4c770'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e6dd4a31-6643-408b-92b2-ac248cef26c8'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0dd4e0ac-8ba8-4713-af70-f15144fd32e4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3be733ba-6791-42a8-965c-f09343b03cba'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (6.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '309ba30a-38e0-464f-b8b4-3756cfa0100b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9969cc36-9f2b-40bf-b42c-489ca788602a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9cbf3e43-8580-4057-8dd1-588eb409684b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3ac35253-9bfd-4b99-b53d-08b40eff8315'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (8.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '49da587e-ab4a-4ebc-bca5-e9dd1464412f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '33b31543-9ebe-4a15-8751-21695afd6be7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0271df82-b456-4666-b0d5-b04e75608b34'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c8435aa6-e42d-4ecd-b963-57db057305b7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3833f214-fade-4fce-a52c-58e0c3960fa1'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd7f3e6a1-799c-4c00-b846-3dfe64ebdf0a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '996e8199-f7a2-4945-a10f-b46ea2af0bbb'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'fee168bb-d7b2-40bd-a52c-3546b2b38067'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'bfccdbfd-7955-4fb6-b67d-a87dbe0e83a2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '86e8fa1a-5a12-41d7-bd8f-57b68017a157'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c672971a-23cf-42e3-a7fa-389387e55a39'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e4feef7a-a5d8-40e0-9474-ea6bc18d3a3b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd07f6731-ad34-448d-aacf-6faa9488e0e9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '155dc384-ffb8-4dad-8be1-b71cb1d82b0c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '09427ba3-24ed-4ffb-b278-965ccc0f2fb2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '5446b045-654e-4f7c-a242-3a0937600a97'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (4.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'fb48c42a-3cdc-4262-ac9a-ac898dcb7e2d'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9a5d7f3f-ffb8-4d44-a5b6-4f618778b587'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '8740a188-f1fa-4b13-b264-af78fc197a14'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'cd0a964a-07d5-4a75-9b42-eca218dc2ba2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '892feae3-b1b5-437d-b242-11b482d6002b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '11ab5acc-3d42-4362-967b-6a369feff263'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3e5f76aa-5b7a-4c9c-991b-656c32886241'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '30b5e593-52a1-4f92-8fcf-6802de037845'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '27554f7c-dda8-435d-b26d-9a9c337cfc91'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b770f149-177d-4d15-b463-07111dd41310'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '48c6914c-8f25-4912-bbb6-079feadb431a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (4.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '52c9e180-537f-4c48-b451-347f8d195ea4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c42bab7d-f511-4a21-b899-d2afa6ccfe43'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '6609bd8c-8886-4f93-ad49-3f542ef3dbc8'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '551e3e8e-3585-4451-b675-589bff6f1b0c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '1d4b75c4-bba7-4dd8-840e-17ed4d81f373'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '5a6d2a7f-2951-40de-9be0-cdac2b00e34d'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '072677b2-85f3-496b-a6fa-90ec0e517ed6'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f77251b2-61ad-48ca-9a4f-248c562d98e9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'fdad7f2a-a1b1-4dfc-ba7a-2c7fdfa0120e'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c405b721-7905-4116-908b-dab8c9e1f62f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3e0ef1c9-e582-4991-91dc-9876e637cd27'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (4.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0c7eab8a-d7c4-4788-a065-e6e39ee36c91'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b22ca52f-cb5e-4816-8c0d-b054fd5e3647'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '6690c501-4136-4460-8753-7c99aaec8de4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '6b8647d7-0f29-42c4-8239-307860c772b0'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '49b06711-0205-4750-85d6-e14a209c4672'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b703335b-4210-4548-b30d-4c09072b8252'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '34723144-3759-42b6-870a-7c8be75da8ee'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '90bad258-1641-43e4-a142-c050af5457de'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2b72aced-447f-49d7-b914-b74eff423e7b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0629c446-ad13-496c-b0ed-59be5adf5417'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2a4bb0ba-e87b-47ea-919c-ea98a660d847'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3ca90337-748f-49e4-a5f0-4b6073b4f81a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3c7c0bf2-7056-4416-ab62-0212c767580d'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'aeb2b7dc-80ef-4af4-88d2-009a62d9b6f2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'ded1d229-bb83-4f48-8fdd-57f597208381'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f656ff8c-bb44-4956-b6eb-10dba0546c4e'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '36d7086b-c88a-4c57-9eae-a8d102390f5b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (5.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '47582247-7227-4958-a72a-a3a082fdd75b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2af66d29-5d4f-47a6-8956-27fc80020232'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0035135c-6ae8-4425-94da-d6bcab3c441f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '934ea9e2-5638-41c9-acc6-044eda2e3d56'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '38c7c691-66bf-4c96-a5f2-43ffad88c30e'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'a73b7d18-1b24-4c23-b550-32c25a0fc06e'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '708c7eb5-5aa9-4091-bcf8-f44e85eed597'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '6f553a71-8603-439a-9dbe-35aa7516eba7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (4.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'dae6979b-eee6-40c3-931a-3bb16328ca4a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '4a1de925-26d1-4694-8836-ab1a5e3bf6a9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '690169f0-08c6-409f-9873-bb4c1612c6a4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '408528b3-40cc-4f77-b102-680d9c8136bd'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '5025283d-52ef-4f43-b2a6-2f1143cb528f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '118d1819-c333-4044-baca-9fb445c259c5'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'bb5313d4-fb62-4044-8f20-59e937d13f48'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '1939aa89-4255-43a0-9957-61e5ceaad646'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd2359aa4-d111-4a19-99e1-cbb8e2771ede'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '22909286-f54b-4132-8937-951ef793634d'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f4ac3cab-96ae-4e21-934f-ee090237ac8b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c6b0d654-5da7-4a80-8f21-8b38c30d1bcd'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f30a1404-990d-44f4-b12c-3a4093c157c8'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '275f7473-f5ef-4060-9cb2-4686dfa481af'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3da13c49-50fd-4a23-a09d-11316f7e7c7f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd7208200-f3b1-4eb7-930e-198f7f95d941'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9fe4c53b-45ad-44b9-824c-9abaea595363'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2ac8600b-bf92-49c3-9d8e-9bd4dcbe2a8a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '57812e64-d99b-4fe3-9797-e4314a3648fc'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3639a62c-fb41-4a5f-9859-5b82205abee4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'cc73cef5-64af-4b3f-b586-431f0d974cec'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '852bf4f7-d33c-4472-8578-3f498df7f1ff'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '146c80e6-2646-48ef-80db-c2265da2a50a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd0f597f6-342c-489a-9172-b686c1269288'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd1efe6bd-8644-481d-ac2e-c081691fe523'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '8ec166d4-ea36-4390-bd84-f02480799090'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e9ac73d4-9dfc-48e3-ae2a-e97015c7aaf4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'af640127-1d80-4ab6-b215-981ce443bc00'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'bb1a8861-beb6-48f2-8062-5caffe08ea83'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'ec64f75b-6cf5-4b8e-b001-64861dd06c9b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0b0aa086-b1af-417e-a0c9-af0b02501a68'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '761de4a0-dad9-4167-885c-553bbf476afe'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (13.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '20b18b0d-10fe-4884-8763-8c718c32cdf2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'cb1120b5-79ba-4134-a15e-193ffab9da3a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'bf69a757-c9ca-4ccf-9a19-8ab6adb6f5a2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'fe46a4cc-5078-4c69-a777-ed22c3d182f5'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '97da0792-8f88-42f5-b751-ccc8535f4357'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3bfb8397-584e-46de-a86b-77b9289c2ddf'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '8da5472d-646b-4ea5-9b65-691eeb0ab713'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '53417cde-cbbb-40e5-855e-bc04ee8d1dc2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '1102947b-a419-4676-b652-3056599d2791'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c5be75f3-e929-4e40-8dd1-4150cdacda35'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3501fdee-d6a7-4897-8518-65b471699365'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'ed7d86e6-9dfe-4234-b144-4151183747ec'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '4c9da7a6-fd72-4a12-bc22-a6ade4823150'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0833bdfe-424c-4195-9ca7-67cb495b38e9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'ac6db9f8-a566-468e-8dcb-46bfa795ef36'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '68920c0b-f284-4a44-b9eb-4d5a666325a8'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '6839c5be-dda1-42db-9f58-5802ab9c3dad'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2a210d7a-b0da-42dd-83a8-37c9023b394c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '1235f6df-4e67-453c-8514-7e47e4ce1539'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c7eaa46a-2a47-4f2d-8945-4494b24b5776'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (6.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '356f8587-e73f-462b-aaf2-699478ff76d5'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b4b9a885-6010-403b-b329-157183b31019'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '21a99833-8c4e-48e8-a0d8-c00f95c681b9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '169c1fc4-393f-4572-9c62-8872652695de'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'a1e5f69e-041d-4329-a8ee-ceafb70708a8'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'cf2354f1-098f-41e4-bf5c-56d1c2f869d5'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '4c90a3ee-2bb3-4be6-933c-f4ac8186c214'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '8faa00a2-5d8a-42bd-afb9-b49125d5f5b2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f56cd699-6595-434c-a0d3-63beff8e9f7e'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '88a2fbab-70bc-4a06-ba24-29ae446833eb'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '23a5e6f1-9a6c-46c3-a7ff-d7d663f7293d'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c14a6828-cc94-45e6-9a25-357c93857d04'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b9d37755-3ba7-4546-a428-9a00efcbb36b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (4.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '6d60f539-6ef2-4add-b934-9956f5ad182c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'bb5fe452-156b-48c5-b91f-5b7124fd6045'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c4c0196a-deaa-4728-9932-2877fd29fe54'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '344d40d3-c1e3-432d-9a3e-bf79c22f6bf7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b5f69d59-ae6b-4c3b-873f-edadf8979ccc'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'afd5a3cb-5669-49d2-afc6-f423ce51f4d3'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0bdd00df-4aed-4ddb-9d39-9c901461cb08'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '81d06a84-c70a-47ad-bc64-1893539832b7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '20398fec-25bc-4522-9cd0-fc228e6e6d86'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (7.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3353672c-dfd4-4dfd-b685-a244323358fb'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'acd76a6b-1472-4b41-89b2-d39c4eaaf75a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '68c27719-da5b-42d9-a60a-bcdcacf12136'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '728727e9-2a95-4c02-a94b-634b4343eb2c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2f42e6d7-028d-45ed-b49a-33038d7da07f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9527864c-3c40-4f8d-8dc8-d3de21d49cf9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '1cb494e4-93ca-484c-a5db-d41f8c1e930b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '6635233f-fb62-44c2-9db1-f25904bd0e54'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '7612b529-a190-4e91-9fc2-fe701e05b371'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (4.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9e11a35e-bc54-469c-b5ac-ea09839ecf00'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'ba6a92eb-adfd-4ed6-9762-1a848d666560'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '782e5983-5202-4d4d-8ae5-28fd7b24cc0a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'cfc670af-a98d-4e42-b36e-abcf829593e9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '5455f5ad-ccf1-451c-b45a-07dfba033982'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '67e2f990-7d8a-44a7-9525-16556e0c52a2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'fb8540b2-cc4f-4853-aef7-d6e9ffa3cecd'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e9b0f690-27fe-45bf-967a-ef18d6243cc3'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (4.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'a4a52cf4-1e40-443e-a7ab-16741f765cb4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'bb5a578a-6c22-496f-a20f-e2cf86ef3193'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '161883fe-2d82-43c5-b32d-c20ddca86988'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '7bd4029a-ca02-476a-9038-4e9c44abb310'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'dcd2f676-e5a4-4bcc-ac7f-67db874c55bb'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'db96469a-9053-449d-b9a9-633f1c2cc9c7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd9539f0f-07a7-4697-843f-46ce6ae1931e'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9feb3c5d-229c-4a19-a39e-07d3b9230ee8'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'a0c5312f-11b9-4c97-9997-3ef7ba78894e'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '1bf973ff-dc7e-4ed2-b215-eafa1cc6ef09'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f8e3fb89-4ae2-41ad-80d0-81d568eeca2a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '5377f465-e43d-4150-a64d-d8bb2f7eca7b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '944704ec-2a2b-40c7-bfbe-b351bd49f1c5'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '69980821-1c46-41f6-8135-52d408376b8d'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (4.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9428a537-adf5-4e26-937a-03a5b4fe72fb'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '5d1633db-643b-49ed-9ce0-c50edec590b4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '37720b8d-a1be-476f-b255-0e7ed8cf9227'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '8b3fd0dd-7bd0-4a34-a3f0-3a820363b364'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '64ae0cd3-3879-4439-b78f-f2d225c74e0c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0b8283c5-af76-472a-8dcb-424d76eb9d58'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c6dd9d27-3105-4f50-9187-98f37883e73b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '950d262d-2c79-46f5-8921-30dfe87ac540'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b4944de5-a493-4edd-86bc-e464e660d34f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3f45b480-5f94-4bc8-91e7-a0c2424e669a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'a71e377a-3104-431a-89ad-0a247d582e99'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '1a9caa1a-12a0-42d9-8623-13a31d4c2b71'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '5152f7b1-a251-4c46-8c41-8254155ce6a1'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '33af420a-8921-454a-9a6e-086547250105'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '8f48bb29-be84-46cb-9cc5-d56507c4a666'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f3fea1e2-011b-472e-b7a8-b8b9a1466a02'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '02d93037-b4f1-4785-a751-a21d39338d53'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b5b0ab59-8316-4335-a855-922816d69812'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b7761b27-2f4d-4e9d-be26-d8808afecef6'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.4ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e80ba710-23aa-4260-9341-818454644054'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'bd6e1924-afb8-4d44-aeac-6698e8509778'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e682f430-6cd0-4705-a2e9-bc2978ba7ac4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (5.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '8f857d58-2af4-46c2-9d2e-0d095058e97d'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b6f7cf44-6789-468e-837c-c38869822f73'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'adb42f18-4eab-45c5-a728-991a4c11a192'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '494014c6-f0e0-4f74-8fdc-40abf256fa1c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f3d2eab4-a5c1-4f0d-93f5-bbfed75e57f4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '75273f89-76a9-48d3-be9b-2aa6319184a4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'ccb1cc92-a654-4af6-b557-e3fa33c878db'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c38ce663-5c73-4da4-a80c-01e7335c9050'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '7f8a9015-f2ce-4aea-844b-d8ea42f2d2f9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'ddd42f4a-0cc8-4ef6-ad6f-9e93cd997d6f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3f69da52-8523-444b-b774-c65fed8ef96a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '88bc3573-9538-40e6-a78d-4b5343c04d2c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f9320c1d-31c8-4398-ae65-3dc9395ee23f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '592e8350-6906-491a-8314-42e45879aae9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd3b833a2-c98f-4568-8704-4fb45a6aabae'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0a40df5d-2b39-46a8-8e67-37173cc28038'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (6.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2ae072a1-3920-4d1e-9fc6-bab3c19756e2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0e692299-1896-4a48-8176-82f655582591'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '1ded7563-e145-4496-a98b-0756ad993c38'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '741e749b-3b72-40fa-a64a-70b872e553c3'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'ba8fd80c-6af6-4e25-8688-822e07a89802'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0ed174d1-4a2f-478c-a380-f214b4204d66'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '897755f5-aadd-4ebf-9919-faef9a8f4bcc'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '816dedc0-bc0e-47a3-a724-e3ddba2ec74b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '05b77dec-0504-4352-a5df-ee449ae04820'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '93afb912-8cc5-4ac4-a483-d64849a0536f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '98bfbc47-b9bd-4490-ae1b-2ae1b9e6f71b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (4.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd124379c-f837-48e7-aa9b-7443f2ef31c7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '8843202d-2849-41f3-a410-5bb022de030a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f8c0f168-c53b-42b6-add7-e3bfa6069b66'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '233cef76-2a80-4497-917e-b366cebfcac0'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'fb24cce2-3ed9-4c7a-b09c-0404981a0913'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'fe85814c-093e-4f47-9839-186457d651d9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'ff27836c-ce1b-4cb5-a45b-1a2eef16e9a7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9c45a8ee-8d7b-4b56-81bf-1fe5601a06e6'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e1e07c20-0b1b-4b4c-9da4-525708f44626'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '7f554da7-0516-4218-b8a6-87f969cd0d9e'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b1dc5ad5-4038-4e80-a7da-36a75aea131b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3b082d72-4db6-47c2-9668-e1515a8b082f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e889ae2c-f3ad-4148-90c6-e225c5ff43a8'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b6433e37-1b56-4437-b3b9-0e4f3b8d521c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2ddd5c65-7f16-437b-a342-0504fab95ea7'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'c086eb7f-4437-492c-911c-4b4e534cc0c2'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '69ccb3f6-e8f5-4776-ad3e-5b2b452ef139'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd2a8dc72-a907-46ba-a733-e347114338b4'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (7.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd7ce0a4d-0984-4328-bed5-03e2585e371c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (4.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '133c9a82-90e5-4ef6-871b-f0dbc2570b70'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '5da139c1-637e-4b21-81eb-84e4be493315'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '0a235101-cb17-4671-9990-67f78d4a2936'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'dc997a6e-f07c-4718-8331-f755154a12b9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '054632cc-a859-4b11-bf6e-cd5f5f4e8d61'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.4ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '777a9505-6457-4559-ac25-2ac3a4e02bd3'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '293be419-d1d4-4652-93cc-78b8c30d88ff'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '29053e12-fa4f-4275-a4a7-42d6aa952d36'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (5.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '49fdd7b7-eb42-4a08-a860-63a2daac647d'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e126b2af-269e-4331-82ae-dc8014795b98'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '549b0676-e1c6-4b4f-b948-1f1d475fe853'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'aabe13ca-feb3-4e3c-b6f2-eca1f3589c4c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '3a592f47-f3e3-4cde-8374-c29efa6dd750'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9dbd724d-a25e-4d01-a296-ea08b1e22b2c'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '49b416f8-ab61-4688-9835-05f979fca823'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '87765108-a23b-40c7-919b-ce152e249c45'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '034b9c76-e13b-4a8c-87aa-481f77dc66db'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '9f654356-68ad-4704-8d86-3383b34c7c2e'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'eb36348e-a862-47b7-9133-a2fc60017c8f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '89fe824e-937a-4eca-bfed-eab25c4bdbc9'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '51d87033-281f-477b-aab9-4223cb26fc93'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f6a7dd1d-38f9-4fa3-ac40-c48fc38b87c1'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b8b6f048-0509-4f20-a0a0-4a961bc80aad'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (7.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '974b2b15-2a58-4acc-9868-f914ed64af05'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '259d44b7-e899-45fc-9647-1fd565fa2564'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (3.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '5d631907-a1ea-4006-8b22-2f6b8b05be66'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '33308468-a0b1-42a2-a841-6e737ed3264f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.5ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '2fb6c725-1446-48e3-b4a7-e3972a3c2d63'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'b325185f-ec72-4d02-8694-728e5d2a2b95'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.8ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '025b249c-b9db-4492-925b-06e9ec54712b'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (0.9ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '6210bb8a-5b0f-445d-b4fd-ea82a0290d10'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.2ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'a4857115-d646-4f6f-a076-b2b486df58cb'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.6ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'cdcc4f3e-97aa-4ee7-84dd-bfacce8163df'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.7ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'a6ce676f-6e0e-43f8-80dd-509b66226e14'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = '1d5a9dcb-6bda-4f12-a90e-d7339c468ade'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.2ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'ea51cd38-66b9-4cfd-985e-e6ff934daac8'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.0ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'd4f195d4-dbac-4999-bef0-6dd5c4c6e21f'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (1.3ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'f4fde3e0-e0dc-4543-ad07-a3226aba663a'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
CACHE Host Load (0.0ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT $2 [["id", "f5cf6f1c-fccf-4f41-8001-f12434cb0943"], ["LIMIT", 1]]
↳ app/models/schema.rb:20
RuleResult Load (2.1ms) SELECT rule_results.* FROM (
SELECT rr2.*,
rank() OVER (
PARTITION BY rule_id, host_id
ORDER BY created_at DESC
)
FROM rule_results rr2
WHERE rr2.host_id = 'f5cf6f1c-fccf-4f41-8001-f12434cb0943' AND rr2.rule_id = 'e00dfdb5-d402-4e63-9827-ecf62d4b3f44'
) rule_results WHERE RANK = 1
↳ app/models/rule.rb:32
Completed 200 OK in 2482ms (Views: 16.6ms | ActiveRecord: 767.0ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment