You can find that information in HTTP_REQUESTS as the difference between created_at and completed_at (duration = ([completed_at]-[created_at])*24*60*60). However, for every interaction which invokes a Vizql render, there are a ton of rows created. You can either try to add all of the durations together or just pull out the most important rows. You can do this be actively watching the HTTP_REQUESTS table as you interact with a dashboard to see what rows are added. I've found that applying the following filters gives me an accurate count of actual interactions and maybe 90% of the duration for each click...
1) [action]="sessions" or [action]="bootstrapSession"
2) FIND([controller],"set-port-size")=0 and FIND([controller],"render-tooltip-server")=0
Trick on render times from HTTP_REQUESTS is to identify the start of render and the finish of the render.
You end up with two subqueries, one for the minimum end time and one for the VIZQL start time.
The finish of the render uses the following criteria ACTION = 'performPostLoadOperations'
I can email you the full SQL, but your email is marked private.
Chauncey, you could post the SQL here for everyone to use
Really helpful guys, thank you! My other idea was to try and use subscriptions data, since all of the rendering is packaged up in one request that registers as a Background Task--but correlating the task data with the actual views (or workbooks) being subscribed to is not simple either.
I don't love the idea of having to run subqueries to get the perf data, but at least I have that info now. Thanks again!
FYI: Please note that the "postLoadOperations" records will not be pushed into http_requests starting in 9.1, so using it as an anchor point for when the viz stopped loading will no longer work. "get customized views" is probably the next-best substitute. However, http_requests will probably be populated less and less, so I wouldn't advocate for building new stuff on top of that table.
What's the process / tools you use to replicate the postgres data into Teradata?
We are planning to do the same thing.