Skip to content

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:

Query
SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT $1

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?

Metrics

Collected from https://gitlab.com/gitlab-com/gl-infra/infrastructure/-/snippets/2047044

Metric Measurement
Total number of calls
% of Total time
TPS
Duration
Edited by Craig Gomes