Investigate and reduce amount of 'CACHE' SQL for Projects::JobsController#show
As listed in epic: &3873 (closed), we detected several end-points that have a big amount of CACHE
SQL.
Projects::JobsController#show
is one of them.
It consistently appears among top 30 db_cached_count
controller#action list, when query the last 24 hours on Kibana. It is also very popular in terms of how many times(count
) it is invoked daily.
There are potentially several benefits if we could improve the SQL/Cached_SQL calls for this endpoint:
- from the database CPU cost perspective, 4523052 * 0.0929273990589387 / 3600 = 116 hours. So if we could make some improvements, it would reduce CPU costs.
- reduce memory consumption in Rails application.
json.meta.caller_id.keyword: Descending | Count | Max json.db_cached_count | 50th percentile of json.db_count | 95th percentile of json.db_count | 50th percentile of json.db_cached_count | 95th percentile of json.db_cached_count | Average json.db_duration_s |
---|---|---|---|---|---|---|---|
Projects::JobsController#show | 4523052 | 1826 | 64.9999497601192 | 114.371385251551 | 0 | 0 | 0.0929273990589387 |
Edited by Qingyu Zhao