select report "all hosts". Enter a full text name without "host=" in filter control.
Can lead to postgres database crash!!!

The generated query by foreman

SELECT DISTINCT "reports".id, "reports"."reported_at" AS alias_0 FROM "reports" LEFT OUTER JOIN "hosts" ON "hosts"."id" = "reports"."host_id" AND "hosts"."type" IN ('Host::Managed') LEFT OUTER JOIN "hosts" "hosts_reports_join" ON "hosts_reports_join"."id" = "reports"."host_id" AND "hosts_reports_join"."type" IN ('Host::Managed') LEFT OUTER JOIN "environments" ON "environments"."id" = "hosts_reports_join"."environment_id" LEFT OUTER JOIN "logs" ON "logs"."report_id" = "reports"."id" LEFT OUTER JOIN "messages" ON "messages"."id" = "logs"."message_id" LEFT OUTER JOIN "logs" "logs_reports_join" ON "logs_reports_join"."report_id" = "reports"."id" LEFT OUTER JOIN "sources" ON "sources"."id" = "logs_reports_join"."source_id" LEFT OUTER JOIN "hosts" "hosts_reports_join_2" ON "hosts_reports_join_2"."id" = "reports"."host_id" AND "hosts_reports_join_2"."type" IN ('Host::Managed') LEFT OUTER JOIN "hostgroups" ON "hostgroups"."id" = "hosts_reports_join_2"."hostgroup_id" WHERE (("hosts"."name"
ILIKE '%vmname%' OR "environments"."name" ILIKE '%vmname%' OR "messages"."value" ILIKE '%vmname%' OR "sources"."value" ILIKE '%vmname%' OR "hostgroups"."name" ILIKE '%vmname%' OR "hostgroups"."title" ILIKE '%vmname%' OR "hostgroups"."title" ILIKE '%vmname%')) ORDER BY "reports"."reported_at" DESC LIMIT 150 OFFSET 0