have you tried looking at historical_events with a type of 84? this I believe is an access request event which identifies rendering of a dashboard and it should have the user indicatives.
But I can't calculate the load time with historical event. How can I associate it with http_requests.
The idea is to add to the http_requests table the user ID when it is missing (ex: BootStrapSession request).
ah, I see what you are up against. We have found no means of calcing load time and associating it to a user by just using the http_requests table. To get around this, we have a script / parser of the vizql logs that we capture each night, within these logs is the request / session data along with the user data. And then we blend the http_requests data with the vizql log data to get the correlated info. It's a bit involved, but it works.
I will try it.
Please let me know if you have some example of application on this topic.
Thank you Jeffrey.