Improve database response time for listing user activity
All threads resolved!
This MR improves a database query to display activity of a given user to the currently logged in user. It leverages the user_interacted_tables
table introduced in https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/17327.
LATERAL
join because https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/17454#note_61882724 -- anything I'm not seeing?For some users, displaying the user activity page times out. That is, the related query runs into the statement timeout.
A URL to test this is https://gitlab.com/ather-embitel (note we fail to show something for 'most recent activity' after a while).
Grafana links: Controller performance
package-qa
manual pipeline job)Closes #40525 (closed)