Description of problem:
Setting a filter based on the following causes reporting worker to hit 10GB+
VM Template and Image.Management Events : Dest Ems Cluster Name
In customer environment removing the filter allows the report to complete as expected
Version-Release number of selected component (if applicable):
Always in customer environment
Steps to Reproduce:
1. Go to Cloud Intel > Reports
2. create a custom report with the above filter
Reporting worker exceeds memory
Report should complete
It looks like the report is downloading all the events in the event stream.
Are you really looking for a template that has an event associated with a particular cluster?
I expect it to not to go through events and reference the template.ems_cluster.name.
I'll look into optimizing this relationship, but do wonder if it is the report definition at fault.
I played with the expression, and I feel it could possibly be INCLUDES (or EQUAL) instead of CONTAINS.
From what I understand, CONTAINS is for tags while INCLUDES/EQUAL is for field values (like cluster name)
This regular expression is showing all templates with a cluster name that includes Recurso (or is equal to) Recurso
I'll update the customer with the change and will follow up if it works for them.