Select statements that are in execution during database CPU utilization peak times - licenses table
After investigating spikes over 70% of CPU usage on the database here:
Link to reports/investigations
we find out this statement being executed thousands of times:
Could be possible creating or improving our caching on those tables? Could we have a unified cache to query, and when we execute updates on it, we could refresh the cache?
Collected from https://gitlab.com/gitlab-com/gl-infra/infrastructure/-/snippets/2047044
|Total number of calls|
|% of Total time|