As part of our Kaminari pagination code pathway, we remove offset/limit/order parts of a query. When Rails performs a count on this modified relation, it may use SELECT count(count_column) rather than SELECT count(*) resulting in poor performance.
This MR will force the SELECT count(*) for this specific REST endpoint by explicitly defining a select value.
Numbered steps to set up and validate the change are strongly suggested.
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
