Missing index in alert table leads to slowness in RHACS
Issue
- The table
alertshas an index missing on the policy_id column. In this case, PostgreSQL has no choice but to read the entire table and since the table is about 1G in size, it will exhaust cache on every call to the alert table and everything else will also become slower.
Environment
- Red Hat Advance Cluster Security for Kubernetes (RHACS)
- 4.5.0
- 4.5.1
- 4.5.2
- 4.4.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
